DBA Data[Home] [Help]

APPS.BOM_OE_EXPLODER_PKG dependencies on MTL_SYSTEM_ITEMS_TL

Line 479: MTL_SYSTEM_ITEMS_TL MSITL,

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

Line 760: mtl_system_items_tl msitl

756: x_top_source_bill_id,
757: x_top_source_bill_id,
758: NULL
759: FROM mtl_system_items msi,
760: mtl_system_items_tl msitl
761: WHERE msi.organization_id = arg_org_id
762: AND msi.inventory_item_id = arg_item_id
763: AND msitl.organization_id = msi.organization_id
764: AND msitl.inventory_item_id = msi.inventory_item_id

Line 809: MTL_SYSTEM_ITEMS_TL msitl

805: msi.CUSTOMER_ORDER_ENABLED_FLAG ,
806: msi.INTERNAL_ORDER_ENABLED_FLAG ,
807: msi.SO_TRANSACTIONS_FLAG
808: from MTL_SYSTEM_ITEMS msi,
809: MTL_SYSTEM_ITEMS_TL msitl
810: WHERE msi.organization_id = arg_org_id
811: and msi.inventory_item_id = be.component_item_id
812: AND msitl.organization_id = msi.organization_id
813: AND msitl.inventory_item_id = msi.inventory_item_id