DBA Data[Home] [Help]

APPS.BOM_OE_EXPLODER_PKG dependencies on MTL_SYSTEM_ITEMS_TL

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 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 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