DBA Data[Home] [Help]

APPS.BOMPBXIN dependencies on BOM_INVENTORY_COMPONENTS

Line 244: BOM_INVENTORY_COMPONENTS BIC

240: BIC.ATTRIBUTE14,
241: BIC.ATTRIBUTE15
242: FROM BOM_SMALL_EXPL_TEMP BET, BOM_BILL_OF_MATERIALS BOM,
243: MTL_SYSTEM_ITEMS SI,
244: BOM_INVENTORY_COMPONENTS BIC
245: WHERE BET.PLAN_LEVEL = c_level - 1
246: AND BET.GROUP_ID = c_grp_id
247: AND BOM.ASSEMBLY_ITEM_ID = SI.INVENTORY_ITEM_ID
248: AND BOM.ORGANIZATION_ID = SI.ORGANIZATION_ID

Line 361: FROM BOM_INVENTORY_COMPONENTS CIB

357: ( c_explode_option = 1
358: OR
359: (c_explode_option = 2 AND not exists
360: (SELECT null
361: FROM BOM_INVENTORY_COMPONENTS CIB
362: WHERE CIB.BILL_SEQUENCE_ID = BIC.BILL_SEQUENCE_ID
363: AND CIB.COMPONENT_ITEM_ID = BIC.COMPONENT_ITEM_ID
364: AND NVL(CIB.ECO_FOR_PRODUCTION,2) = 2
365: AND ( decode(CIB.IMPLEMENTATION_DATE, NULL,

Line 382: FROM BOM_INVENTORY_COMPONENTS CIB

378: ) -- CURRENT
379: OR
380: (c_explode_option = 3 AND not exists
381: (SELECT null
382: FROM BOM_INVENTORY_COMPONENTS CIB
383: WHERE CIB.BILL_SEQUENCE_ID = BIC.BILL_SEQUENCE_ID
384: AND CIB.COMPONENT_ITEM_ID = BIC.COMPONENT_ITEM_ID
385: AND NVL(CIB.ECO_FOR_PRODUCTION,2) = 2
386: AND ( decode(CIB.IMPLEMENTATION_DATE, NULL,