INSERT
INTO mtl_transactions_interface(
transaction_interface_id
, Source_code
, source_header_id
, source_line_id
, process_flag
, transaction_mode
, item_segment1
, inventory_item_id
, organization_id
, distribution_account_id
, subinventory_code
, transaction_uom
, transaction_date
, transaction_type_id
, transaction_quantity
, creation_date
, created_by
, last_update_date
, last_updated_by
)
SELECT MTL_MATERIAL_TRANSACTIONS_S.nexval transaction_interface_id
, 'Costing/Non-costing adjustment' Source_code
, 199 source_header_id
, 199 source_line_id
, -9 process_flag
, 3 transaction_mode
, msi.segment1 item_segment1
, msi.inventory_item_id inventory_item_id
--, ood.organization_code
, ood.organization_id
, DECODE(ood.set_of_books_id,1,50066,NULL) distribution_account_id
, moq.subinventory_code
, moq.transaction_uom_code transaction_uom
, TRUNC(SYSDATE) transaction_date
, 32 transaction_type_id -- issue 42--receipt
, SUM(moq.transaction_quantity) transaction_quantity
, SYSDATE
, 17879
, SYSDATE
, 17879
FROM mtl_system_items msi
, mtl_onhand_quantities_detail moq
, org_organization_definitions ood
WHERE msi.organization_id = 2
AND moq.inventory_item_id = msi.inventory_item_id
AND ood.organization_id = moq.organization_id
AND msi.segment1 IN ('TSTITM')
GROUP BY msi.segment1
, msi.inventory_item_id
--, ood.organization_code
, ood.organization_id
, ood.set_of_books_id
, moq.subinventory_code
, moq.transaction_uom_code
Musings by Dr Aarti
Thursday, September 9, 2010
Wednesday, September 8, 2010
User Responsibility
SELECT DISTINCT u.user_name, wur.role_orig_system_id responsibility_id
, wura.start_date, wura.end_date end_date, wura.created_by created_by
, wura.creation_date creation_date, wura.last_updated_by last_updated_by
, wura.last_update_date last_update_date
, wura.last_update_login last_update_login
, wura.assignment_reason description
, res.responsibility_name
FROM fnd_user u
, wf_user_role_assignments wura
, wf_all_user_roles wur
, fnd_responsibility_tl res
WHERE u.user_name = wura.user_name
AND wura.relationship_id = -1
AND wur.role_orig_system = 'FND_RESP'
AND NOT wura.role_name LIKE 'FND_RESP|%|ANY'
AND wura.role_name = wur.role_name
AND wura.user_name = wur.user_name
AND res.responsibility_id = wur.role_orig_system_id
AND u.user_id = 17879
--AND wur.role_orig_system_id IN ( 53721, 53741 )
, wura.start_date, wura.end_date end_date, wura.created_by created_by
, wura.creation_date creation_date, wura.last_updated_by last_updated_by
, wura.last_update_date last_update_date
, wura.last_update_login last_update_login
, wura.assignment_reason description
, res.responsibility_name
FROM fnd_user u
, wf_user_role_assignments wura
, wf_all_user_roles wur
, fnd_responsibility_tl res
WHERE u.user_name = wura.user_name
AND wura.relationship_id = -1
AND wur.role_orig_system = 'FND_RESP'
AND NOT wura.role_name LIKE 'FND_RESP|%|ANY'
AND wura.role_name = wur.role_name
AND wura.user_name = wur.user_name
AND res.responsibility_id = wur.role_orig_system_id
AND u.user_id = 17879
--AND wur.role_orig_system_id IN ( 53721, 53741 )
Request Set Details
SELECT rs.request_set_name
, rs.user_request_set_name
, rss.stage_name
, rss.user_stage_name
, rss.display_sequence
, rss.success_link_name
, rss.warning_link_name
, c.concurrent_program_name
, c.user_concurrent_program_name
, e.executable_name
, e.execution_method_code
, e.execution_file_name
FROM fnd_concurrent_programs_vl c
, fnd_executables e
, fnd_request_set_programs rsp
, fnd_req_set_stages_form_v rss
, fnd_request_sets_vl rs
WHERE c.executable_id = e.executable_id
AND rsp.concurrent_program_id = c.concurrent_program_id
AND rsp.request_set_id=rs.request_set_id
AND rsp.request_set_stage_id=rss.request_set_stage_id
AND rss.request_set_id=rs.request_set_id
AND rs.request_set_name = 'FNDRSSUB1128'
ORDER BY rss.display_sequence
, rs.user_request_set_name
, rss.stage_name
, rss.user_stage_name
, rss.display_sequence
, rss.success_link_name
, rss.warning_link_name
, c.concurrent_program_name
, c.user_concurrent_program_name
, e.executable_name
, e.execution_method_code
, e.execution_file_name
FROM fnd_concurrent_programs_vl c
, fnd_executables e
, fnd_request_set_programs rsp
, fnd_req_set_stages_form_v rss
, fnd_request_sets_vl rs
WHERE c.executable_id = e.executable_id
AND rsp.concurrent_program_id = c.concurrent_program_id
AND rsp.request_set_id=rs.request_set_id
AND rsp.request_set_stage_id=rss.request_set_stage_id
AND rss.request_set_id=rs.request_set_id
AND rs.request_set_name = 'FNDRSSUB1128'
ORDER BY rss.display_sequence
Monday, August 30, 2010
ADD Responsibility
fnd_user_resp_groups_api.insert_assignment(
user_id => 17879,
responsibility_id => 51661,
responsibility_application_id => 660,
security_group_id => 0,
start_date => SYSDATE,
end_date => NULL,
description => 'Order Management Super User')
user_id => 17879,
responsibility_id => 51661,
responsibility_application_id => 660,
security_group_id => 0,
start_date => SYSDATE,
end_date => NULL,
description => 'Order Management Super User')
VAASTU - Living room
http://www.amitlamba.com/vastu-mumbai-free-tips-home-apartment.html
http://www.gharexpert.com/articles/Drawing-Room-1058/Vastu-Living-Room_0.aspx
http://www.vastushastraguru.com/vastu-remedies-north-east-kitchen/
According to Vastu Shastra living room or drawing room should be located in east or north direction. The ideal location of a living room depends on plot facing. The living room can be in northeast direction for east and north facing house. The living room can be in northwest for west facing house. In south facing house, living room can be in southeast.
Where to Place Furniture as per Vastu
The furniture should be placed in west or south direction. The furniture such as showcase or heavy articles etc. should be in south or west direction. It should be rectangular or square, not in oval, circular or odd shape.
Television, A.C and Telephone Place according to Vastu
T.V. should be placed in southeast direction. Living room vastu opposes to place T.V. in north-east or south-west corner.
Cooler or A.C should be placed in west or north direction. Avoid A.C or Cooler in southeast and northwest. Telephone should be placed in East, North or south-east. It should not be in south-west or the north-west corners.
Aquarium Placement as per Vastu Directions
Aquariums are beneficial to place in the North, East and North-East of living room. The faults related to north-west corner can be corrected by putting an aquarium. Avoid aquarium in south direction as it draws out positive energies from house.
Painting and Pictures according to Vastu
The use of painting can create a pleasant environment in the room. Painting of waterfall, rising sun provides positive energy. Avoid paintings that symbolize death, violence and negative aspects of life.
Vastu Color Scheme
The color of wall in living room should be white, yellow, blue or green. Prefer light color over dark colors. Avoid black and red color in living room.
Vastu and Lighting
Lighting of living room should be bright. If chandelier is in living room, it should be slightly towards west, not at the centre of the room.
Vastu for Doors and Windows
The door of living room should be in east or north direction because doors are very auspicious in these directions. There should not be a photograph of any God in living room or at entrance door. Windows in east and north are beneficial.
Vastu Tips for Living Room
The East and North are best directions for living room.
The furniture should be square or rectangular.
Air-conditioner or cooler should be placed in West direction, not in South-east.
Portraits of women, animals, birds, scene of war should never be displayed in living room.
The sitting arrangement for the head of family should be in East or North direction.
A painting showing depression should not be placed on a wall.
http://www.gharexpert.com/articles/Drawing-Room-1058/Vastu-Living-Room_0.aspx
http://www.vastushastraguru.com/vastu-remedies-north-east-kitchen/
According to Vastu Shastra living room or drawing room should be located in east or north direction. The ideal location of a living room depends on plot facing. The living room can be in northeast direction for east and north facing house. The living room can be in northwest for west facing house. In south facing house, living room can be in southeast.
Where to Place Furniture as per Vastu
The furniture should be placed in west or south direction. The furniture such as showcase or heavy articles etc. should be in south or west direction. It should be rectangular or square, not in oval, circular or odd shape.
Television, A.C and Telephone Place according to Vastu
T.V. should be placed in southeast direction. Living room vastu opposes to place T.V. in north-east or south-west corner.
Cooler or A.C should be placed in west or north direction. Avoid A.C or Cooler in southeast and northwest. Telephone should be placed in East, North or south-east. It should not be in south-west or the north-west corners.
Aquarium Placement as per Vastu Directions
Aquariums are beneficial to place in the North, East and North-East of living room. The faults related to north-west corner can be corrected by putting an aquarium. Avoid aquarium in south direction as it draws out positive energies from house.
Painting and Pictures according to Vastu
The use of painting can create a pleasant environment in the room. Painting of waterfall, rising sun provides positive energy. Avoid paintings that symbolize death, violence and negative aspects of life.
Vastu Color Scheme
The color of wall in living room should be white, yellow, blue or green. Prefer light color over dark colors. Avoid black and red color in living room.
Vastu and Lighting
Lighting of living room should be bright. If chandelier is in living room, it should be slightly towards west, not at the centre of the room.
Vastu for Doors and Windows
The door of living room should be in east or north direction because doors are very auspicious in these directions. There should not be a photograph of any God in living room or at entrance door. Windows in east and north are beneficial.
Vastu Tips for Living Room
The East and North are best directions for living room.
The furniture should be square or rectangular.
Air-conditioner or cooler should be placed in West direction, not in South-east.
Portraits of women, animals, birds, scene of war should never be displayed in living room.
The sitting arrangement for the head of family should be in East or North direction.
A painting showing depression should not be placed on a wall.
Friday, July 30, 2010
LFS ( Local Fish shops)
DADAR
Fish Fantacy (yes, with a 'c' and not an 's')
Prem Kamal, Gokhale Road,
North, Dadar. It's situated about 200m after the Portuguese Church traffic light.
Prop. Vinod Khade 9869524302
Fish Fantacy (yes, with a 'c' and not an 's')
Prem Kamal, Gokhale Road,
North, Dadar. It's situated about 200m after the Portuguese Church traffic light.
Prop. Vinod Khade 9869524302
Grep SED
The grep -il statement finds all instances of Hello in files ending in txt (i = ignore case, , l = only list the filename). The file names are passed to sed, which runs a regular expression to change all instances of Hello to Goodbye. Since sed doesn't overwrite a file, I redirected the output to a temp file and then renamed it back to the original file name.
#!/bin/sh
for file in $(grep -il "Hello" *.txt)
do
sed -e "s/Hello/Goodbye/ig" $file > /tmp/tempfile.tmp
mv /tmp/tempfile.tmp $file
done
#!/bin/sh
for file in $(grep -il "Hello" *.txt)
do
sed -e "s/Hello/Goodbye/ig" $file > /tmp/tempfile.tmp
mv /tmp/tempfile.tmp $file
done
Subscribe to:
Posts (Atom)