DBA Data[Home] [Help]

APPS.BOMPBXIN dependencies on BOM_INVENTORY_COMPONENTS

Line 248: BOM_INVENTORY_COMPONENTS BIC

244: BIC.ATTRIBUTE14,
245: BIC.ATTRIBUTE15
246: FROM BOM_SMALL_EXPL_TEMP BET, BOM_BILL_OF_MATERIALS BOM,
247: MTL_SYSTEM_ITEMS SI,
248: BOM_INVENTORY_COMPONENTS BIC
249: WHERE BET.PLAN_LEVEL = c_level - 1
250: AND BET.GROUP_ID = c_grp_id
251: AND BOM.ASSEMBLY_ITEM_ID = SI.INVENTORY_ITEM_ID
252: AND BOM.ORGANIZATION_ID = SI.ORGANIZATION_ID

Line 365: FROM BOM_INVENTORY_COMPONENTS CIB

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

Line 386: FROM BOM_INVENTORY_COMPONENTS CIB

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