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 147: BOM_INVENTORY_COMPONENTS BIC,

143: DECODE(BIC.IMPLEMENTATION_DATE, NULL, 2, 1) IMPF,
144: BBM.ORGANIZATION_ID OI
145: FROM
146: BOM_IMPLOSION_TEMP BITT,
147: BOM_INVENTORY_COMPONENTS BIC,
148: BOM_BILL_OF_MATERIALS BBM
149: where bitt.current_level = 0
150: and bitt.organization_id = c_org_id
151: and bitt.sequence_id = c_sequence_id

Line 236: from bom_inventory_components bic2

232: ( c_display_option = 2
233: and
234: bic.effectivity_date =
235: (select max(effectivity_date)
236: from bom_inventory_components bic2
237: where bic2.bill_sequence_id = bic.bill_sequence_id
238: and bic2.component_item_id = bic.component_item_id
239: and NVL(bic2.ECO_FOR_PRODUCTION,2) = 2
240: and decode(bic.implementation_date, NULL,

Line 251: FROM bom_inventory_components bic3

247: to_date(c_implosion_date,
248: 'YYYY/MM/DD HH24:MI:SS')
249: --* AND Clause added for Bug 3085543
250: and NOT EXISTS (SELECT null
251: FROM bom_inventory_components bic3
252: WHERE bic3.bill_sequence_id =
253: bic.bill_sequence_id
254: AND bic3.old_component_sequence_id =
255: bic.component_sequence_id

Line 272: from bom_inventory_components bic2

268: or
269: ( c_display_option = 3
270: and bic.effectivity_date =
271: (select max(effectivity_date)
272: from bom_inventory_components bic2
273: where bic2.bill_sequence_id = bic.bill_sequence_id
274: and bic2.component_item_id = bic.component_item_id
275: and NVL(bic2.ECO_FOR_PRODUCTION,2) = 2
276: and nvl(bic2.old_component_sequence_id,

Line 285: FROM Bom_Inventory_Components bic4

281: to_date(c_implosion_date,
282: 'YYYY/MM/DD HH24:MI:SS')
283: --* AND Clause added for Bug - 3155946
284: AND NOT EXISTS ( SELECT Null
285: FROM Bom_Inventory_Components bic4
286: WHERE bic4.bill_sequence_id =
287: bic.bill_sequence_id
288: AND bic4.old_component_sequence_id =
289: bic.component_sequence_id

Line 481: BOM_INVENTORY_COMPONENTS BIC,

477: DECODE(BIC.IMPLEMENTATION_DATE, NULL, 2, 1) IMPF,
478: BBM.ORGANIZATION_ID OI
479: FROM
480: BOM_IMPLOSION_TEMP BITT,
481: BOM_INVENTORY_COMPONENTS BIC,
482: BOM_BILL_OF_MATERIALS BBM
483: where
484: bitt.current_level = c_current_level
485: and bitt.organization_id = c_org_id

Line 575: from bom_inventory_components bic2

571: or
572: ( c_implemented_only_option = 2
573: and bic.effectivity_date =
574: (select max(effectivity_date)
575: from bom_inventory_components bic2
576: where bic.bill_sequence_id = bic2.bill_sequence_id
577: and bic.component_item_id = bic2.component_item_id
578: and NVL(bic2.ECO_FOR_PRODUCTION,2) = 2
579: and decode(bic.implementation_date, NULL,

Line 589: FROM bom_inventory_components bic3

585: and bic2.effectivity_date <= to_date(c_implosion_date,
586: 'YYYY/MM/DD HH24:MI:SS')
587: --* AND Clause added for Bug 3085543
588: and NOT EXISTS (SELECT null
589: FROM bom_inventory_components bic3
590: WHERE bic3.bill_sequence_id =
591: bic.bill_sequence_id
592: AND bic3.old_component_sequence_id =
593: bic.component_sequence_id