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.BOMPIMPL dependencies on BOM_INVENTORY_COMPONENTS

Line 152: BOM_INVENTORY_COMPONENTS BIC,

148: DECODE(BIC.IMPLEMENTATION_DATE, NULL, 2, 1) IMPF,
149: BBM.ORGANIZATION_ID OI
150: FROM
151: BOM_IMPLOSION_TEMP BITT,
152: BOM_INVENTORY_COMPONENTS BIC,
153: BOM_BILL_OF_MATERIALS BBM
154: where bic.pk1_value = BITT.PARENT_ITEM_ID -- 8470695
155: and bic.pk2_value = NVL(bbm.common_organization_id, bbm.organization_id) -- 8470695
156: and bitt.current_level = 0

Line 243: from bom_inventory_components bic2

239: ( c_display_option = 2
240: and
241: bic.effectivity_date =
242: (select max(effectivity_date)
243: from bom_inventory_components bic2
244: where bic2.bill_sequence_id = bic.bill_sequence_id
245: and bic2.component_item_id = bic.component_item_id
246: and NVL(bic2.ECO_FOR_PRODUCTION,2) = 2
247: and decode(bic.implementation_date, NULL,

Line 258: FROM bom_inventory_components bic3

254: to_date(c_implosion_date,
255: 'YYYY/MM/DD HH24:MI:SS')
256: --* AND Clause added for Bug 3085543
257: and NOT EXISTS (SELECT null
258: FROM bom_inventory_components bic3
259: WHERE bic3.bill_sequence_id =
260: bic.bill_sequence_id
261: AND bic3.old_component_sequence_id =
262: bic.component_sequence_id

Line 279: from bom_inventory_components bic2

275: or
276: ( c_display_option = 3
277: and bic.effectivity_date =
278: (select max(effectivity_date)
279: from bom_inventory_components bic2
280: where bic2.bill_sequence_id = bic.bill_sequence_id
281: and bic2.component_item_id = bic.component_item_id
282: and NVL(bic2.ECO_FOR_PRODUCTION,2) = 2
283: and nvl(bic2.old_component_sequence_id,

Line 292: FROM Bom_Inventory_Components bic4

288: to_date(c_implosion_date,
289: 'YYYY/MM/DD HH24:MI:SS')
290: --* AND Clause added for Bug - 3155946
291: AND NOT EXISTS ( SELECT Null
292: FROM Bom_Inventory_Components bic4
293: WHERE bic4.bill_sequence_id =
294: bic.bill_sequence_id
295: AND bic4.old_component_sequence_id =
296: bic.component_sequence_id

Line 493: BOM_INVENTORY_COMPONENTS BIC,

489: DECODE(BIC.IMPLEMENTATION_DATE, NULL, 2, 1) IMPF,
490: BBM.ORGANIZATION_ID OI
491: FROM
492: BOM_IMPLOSION_TEMP BITT,
493: BOM_INVENTORY_COMPONENTS BIC,
494: BOM_BILL_OF_MATERIALS BBM
495: where bic.pk1_value = BITT.PARENT_ITEM_ID
496: and bic.pk2_value = NVL(bbm.common_organization_id, bbm.organization_id)
497: and bitt.current_level = c_current_level

Line 588: from bom_inventory_components bic2

584: or
585: ( c_implemented_only_option = 2
586: and bic.effectivity_date =
587: (select max(effectivity_date)
588: from bom_inventory_components bic2
589: where bic.bill_sequence_id = bic2.bill_sequence_id
590: and bic.component_item_id = bic2.component_item_id
591: and NVL(bic2.ECO_FOR_PRODUCTION,2) = 2
592: and decode(bic.implementation_date, NULL,

Line 602: FROM bom_inventory_components bic3

598: and bic2.effectivity_date <= to_date(c_implosion_date,
599: 'YYYY/MM/DD HH24:MI:SS')
600: --* AND Clause added for Bug 3085543
601: and NOT EXISTS (SELECT null
602: FROM bom_inventory_components bic3
603: WHERE bic3.bill_sequence_id =
604: bic.bill_sequence_id
605: AND bic3.old_component_sequence_id =
606: bic.component_sequence_id