eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BOMPBEXP dependencies on BOM_INVENTORY_COMPONENTS

Line 136: BOM_INVENTORY_COMPONENTS BIC,

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
140: AND MSI.INVENTORY_ITEM_ID = BOM.ASSEMBLY_ITEM_ID

Line 228: FROM BOM_INVENTORY_COMPONENTS CIB

224: OR
225: (c_explode_option = 2 AND
226: BIC.EFFECTIVITY_DATE =
227: (SELECT MAX(EFFECTIVITY_DATE)
228: FROM BOM_INVENTORY_COMPONENTS CIB
229: WHERE CIB.BILL_SEQUENCE_ID = BIC.BILL_SEQUENCE_ID
230: AND CIB.COMPONENT_ITEM_ID = BIC.COMPONENT_ITEM_ID
231: AND NVL(CIB.ECO_FOR_PRODUCTION,2) = 2
232: AND ( decode(CIB.IMPLEMENTATION_DATE, NULL,

Line 249: FROM BOM_INVENTORY_COMPONENTS CIB

245: OR
246: (c_explode_option = 3 AND
247: BIC.EFFECTIVITY_DATE =
248: (SELECT MAX(EFFECTIVITY_DATE)
249: FROM BOM_INVENTORY_COMPONENTS CIB
250: WHERE CIB.BILL_SEQUENCE_ID = BIC.BILL_SEQUENCE_ID
251: AND CIB.COMPONENT_ITEM_ID = BIC.COMPONENT_ITEM_ID
252: AND NVL(CIB.ECO_FOR_PRODUCTION,2) = 2
253: AND ( decode(CIB.IMPLEMENTATION_DATE, NULL,