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_INVENTORY_COMPONENTS

Line 583: bom_inventory_components b1,

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
587: and b2.component_item_id = l_OptionItem_Id

Line 584: bom_inventory_components b2

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
587: and b2.component_item_id = l_OptionItem_Id
588: and b1.bill_sequence_id = bom.common_bill_sequence_id

Line 782: bom_inventory_components b1,

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
786: and b2.component_item_id = l_OptionItem_Id

Line 783: bom_inventory_components b2

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
786: and b2.component_item_id = l_OptionItem_Id
787: and b1.bill_sequence_id = bom.common_bill_sequence_id

Line 807: bom_inventory_components b1,

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
811: and b2.component_item_id = l_OptionItem_Id

Line 808: bom_inventory_components b2

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
811: and b2.component_item_id = l_OptionItem_Id
812: and b1.bill_sequence_id = bom.common_bill_sequence_id

Line 1806: UPDATE bom_inventory_components bic

1802: -- Child level control but ran from Master Orgn
1803: -- Update the BOM in all the orgn.. Disable the components
1804: --
1805:
1806: UPDATE bom_inventory_components bic
1807: SET disable_date = greatest(least(nvl(bic.disable_date,sysdate)),
1808: bic.effectivity_date),
1809: last_update_date = sysdate,
1810: last_updated_by = p_user_id,

Line 1853: UPDATE bom_inventory_components bic

1849: -- Organization Level Control
1850: -- Update the BOM in the specific orgn. Disable the components
1851: --
1852:
1853: UPDATE bom_inventory_components bic
1854: SET disable_date = greatest(least(nvl(bic.disable_date,sysdate)),
1855: bic.effectivity_date),
1856: last_update_date = sysdate,
1857: last_updated_by = p_user_id,

Line 2725: bom_inventory_components bic,

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
2729: and bom.organization_id = p_org_id