eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CTO_DEACTIVATE_CONFIG_PK dependencies on BOM_BILL_OF_MATERIALS

Line 582: from bom_bill_of_materials bom,

578: and msi.organization_id = mp.organization_id
579: and mp.master_organization_id = l_org_id
580: and msi.inventory_item_id in (
581: select bom.assembly_item_id
582: from bom_bill_of_materials bom,
583: bom_inventory_components b1,
584: bom_inventory_components b2
585: where b1.bill_sequence_id =b2.bill_sequence_id
586: and b1.component_item_id = l_Model_Id

Line 781: from bom_bill_of_materials bom,

777: and inventory_item_status_code <> l_del_status
778: and option_specific_sourced in (1,2)
779: and inventory_item_id in (
780: select bom.assembly_item_id
781: from bom_bill_of_materials bom,
782: bom_inventory_components b1,
783: bom_inventory_components b2
784: where b1.bill_sequence_id =b2.bill_sequence_id
785: and b1.component_item_id = l_Model_Id

Line 806: from bom_bill_of_materials bom,

802: and base_item_id = l_Model_Id
803: and inventory_item_status_code <> l_del_status
804: and inventory_item_id in (
805: select bom.assembly_item_id
806: from bom_bill_of_materials bom,
807: bom_inventory_components b1,
808: bom_inventory_components b2
809: where b1.bill_sequence_id =b2.bill_sequence_id
810: and b1.component_item_id = l_Model_Id

Line 1818: from bom_bill_of_materials b, mtl_pending_item_status m

1814: program_id = p_program_id,
1815: program_update_date = sysdate
1816: WHERE bill_sequence_id in (
1817: select b.bill_sequence_id
1818: from bom_bill_of_materials b, mtl_pending_item_status m
1819: where m.status_code = p_status_code
1820: and m.pending_flag = 'Y'
1821: and m.request_id = p_request_id
1822: -- and m.organization_id = b.organization_id --mbsk: for master level control

Line 1865: from bom_bill_of_materials b, mtl_pending_item_status m

1861: program_id = p_program_id,
1862: program_update_date = sysdate
1863: WHERE bill_sequence_id in (
1864: select b.bill_sequence_id
1865: from bom_bill_of_materials b, mtl_pending_item_status m
1866: where m.status_code = p_status_code
1867: and m.pending_flag = 'Y'
1868: and m.request_id = p_request_id
1869: and m.organization_id = b.organization_id

Line 2253: FROM bom_bill_of_materials

2249: l_return_status VARCHAR2(1);
2250:
2251: CURSOR common_bom IS
2252: SELECT bill_sequence_id,assembly_item_id,organization_id
2253: FROM bom_bill_of_materials
2254: WHERE common_bill_sequence_id = l_bill_sequence_id
2255: AND bill_sequence_id <> l_bill_sequence_id;
2256:
2257: BEGIN

Line 2263: FROM bom_bill_of_materials

2259: x_return_status := FND_API.G_FALSE;
2260:
2261: BEGIN
2262: SELECT bill_sequence_id INTO l_bill_sequence_id
2263: FROM bom_bill_of_materials
2264: WHERE assembly_item_id = p_inventory_item_id
2265: AND organization_id = p_org_id
2266: AND alternate_bom_designator IS NULL;
2267: EXCEPTION

Line 2724: from bom_bill_of_materials bom,

2720: l_return_status VARCHAR2(1);
2721:
2722: cursor parent_ato is
2723: select assembly_item_id
2724: from bom_bill_of_materials bom,
2725: bom_inventory_components bic,
2726: mtl_system_items msi
2727: where bom.common_bill_sequence_id = bic.bill_sequence_id
2728: and bic.component_item_id = p_inventory_item_id