DBA Data[Home] [Help]

APPS.BOMPBEXP dependencies on BOM_BILL_OF_MATERIALS

Line 135: BOM_BILL_OF_MATERIALS BOM,

131: BIC.LOW_QUANTITY LQ,
132: BIC.HIGH_QUANTITY HQ,
133: BIC.SO_BASIS SB
134: FROM BOM_EXPLOSION_TEMP BET,
135: BOM_BILL_OF_MATERIALS BOM,
136: BOM_INVENTORY_COMPONENTS BIC,
137: MTL_SYSTEM_ITEMS MSI
138: WHERE BET.PLAN_LEVEL = c_level - 1
139: AND BET.GROUP_ID = c_grp_id

Line 179: FROM BOM_BILL_OF_MATERIALS BOM2

175: ( BET.TOP_ALTERNATE_DESIGNATOR IS NOT NULL
176: AND BOM.ALTERNATE_BOM_DESIGNATOR IS NULL
177: AND NOT EXISTS
178: (SELECT 'X'
179: FROM BOM_BILL_OF_MATERIALS BOM2
180: WHERE BOM2.ORGANIZATION_ID = BET.ORGANIZATION_ID
181: AND BOM2.ASSEMBLY_ITEM_ID = BET.COMPONENT_ITEM_ID
182: AND BOM2.ALTERNATE_BOM_DESIGNATOR =
183: BET.TOP_ALTERNATE_DESIGNATOR