APPS.BOM_OE_EXPLODER_PKG dependencies on MTL_SYSTEM_ITEMS

Line 482: MTL_SYSTEM_ITEMS MSI,

478: BIC.COMMON_COMPONENT_SEQUENCE_ID,
479: BBOM_C.SOURCE_BILL_SEQUENCE_ID COMP_SOURCE_BILL_SEQ_ID
480: FROM
481: BOM_STRUCTURES_B BBOM_C,
482: MTL_SYSTEM_ITEMS MSI,
483: MTL_SYSTEM_ITEMS_TL MSITL,
484: BOM_COMPONENTS_B BIC,
485: BOM_STRUCTURES_B BOM,
486: BOM_EXPLOSIONS BE

Line 483: MTL_SYSTEM_ITEMS_TL MSITL,

479: BBOM_C.SOURCE_BILL_SEQUENCE_ID COMP_SOURCE_BILL_SEQ_ID
480: FROM
481: BOM_STRUCTURES_B BBOM_C,
482: MTL_SYSTEM_ITEMS MSI,
483: MTL_SYSTEM_ITEMS_TL MSITL,
484: BOM_COMPONENTS_B BIC,
485: BOM_STRUCTURES_B BOM,
486: BOM_EXPLOSIONS BE
487: -- FP bug fix for 12.1.1. The bug # is 7307613.

Line 774: FROM mtl_system_items msi,

770: 'Y',
771: x_top_source_bill_id,
772: x_top_source_bill_id,
773: NULL
774: FROM mtl_system_items msi,
775: mtl_system_items_tl msitl
776: WHERE msi.organization_id = arg_org_id
777: AND msi.inventory_item_id = arg_item_id
778: AND msitl.organization_id = msi.organization_id

Line 775: mtl_system_items_tl msitl

771: x_top_source_bill_id,
772: x_top_source_bill_id,
773: NULL
774: FROM mtl_system_items msi,
775: mtl_system_items_tl msitl
776: WHERE msi.organization_id = arg_org_id
777: AND msi.inventory_item_id = arg_item_id
778: AND msitl.organization_id = msi.organization_id
779: AND msitl.inventory_item_id = msi.inventory_item_id

Line 812: FROM MTL_SYSTEM_ITEMS msi

808: where be.rexplode_flag = 1
809: And be.top_bill_sequence_id = x_top_bill_id
810: And be.explosion_type = arg_expl_type
811: and exists (select *
812: FROM MTL_SYSTEM_ITEMS msi
813: WHERE msi.organization_id = arg_org_id
814: and be.component_item_id = msi.inventory_item_id);
815:
816: if(l_count > 0) then

Line 853: from MTL_SYSTEM_ITEMS msi,

849: msi.INTERNAL_ORDER_FLAG ,
850: msi.CUSTOMER_ORDER_ENABLED_FLAG ,
851: msi.INTERNAL_ORDER_ENABLED_FLAG ,
852: msi.SO_TRANSACTIONS_FLAG
853: from MTL_SYSTEM_ITEMS msi,
854: MTL_SYSTEM_ITEMS_TL msitl
855: WHERE msi.organization_id = arg_org_id
856: and msi.inventory_item_id = be.component_item_id
857: AND msitl.organization_id = msi.organization_id

Line 854: MTL_SYSTEM_ITEMS_TL msitl

850: msi.CUSTOMER_ORDER_ENABLED_FLAG ,
851: msi.INTERNAL_ORDER_ENABLED_FLAG ,
852: msi.SO_TRANSACTIONS_FLAG
853: from MTL_SYSTEM_ITEMS msi,
854: MTL_SYSTEM_ITEMS_TL msitl
855: WHERE msi.organization_id = arg_org_id
856: and msi.inventory_item_id = be.component_item_id
857: AND msitl.organization_id = msi.organization_id
858: AND msitl.inventory_item_id = msi.inventory_item_id