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_BILL_OF_MATERIALS

Line 153: BOM_BILL_OF_MATERIALS BBM

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
157: and bitt.organization_id = c_org_id

Line 180: from bom_bill_of_materials bbm2

176: ( bitt.lowest_alternate_designator is null /*and bill with spec*/
177: and bbm.alternate_bom_designator is not null
178: /* alt doesnt exist */
179: and not exists (select NULL /*for current item */
180: from bom_bill_of_materials bbm2
181: where bbm2.organization_id = c_org_id
182: and bbm2.assembly_item_id = bitt.parent_item_id
183: and bbm2.alternate_bom_designator =
184: bbm.alternate_bom_designator

Line 199: from bom_bill_of_materials bbm2

195: /* same par doesnt */
196: and bbm.alternate_bom_designator is null
197: /* exist with this alt */
198: and not exists (select NULL
199: from bom_bill_of_materials bbm2
200: where bbm2.organization_id = c_org_id
201: and bbm2.assembly_item_id = bbm.assembly_item_id
202: and bbm2.alternate_bom_designator =
203: bitt.lowest_alternate_designator

Line 494: BOM_BILL_OF_MATERIALS BBM

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
498: and bitt.organization_id = c_org_id

Line 538: from bom_bill_of_materials bbm2

534: ( bitt.lowest_alternate_designator is null
535: and bbm.alternate_bom_designator is not null
536: /* alt doesnt exist */
537: and not exists (select NULL /*for current item */
538: from bom_bill_of_materials bbm2
539: where bbm2.organization_id = c_org_id
540: and bbm2.assembly_item_id = bitt.parent_item_id
541: and bbm2.alternate_bom_designator =
542: bbm.alternate_bom_designator

Line 559: from bom_bill_of_materials bbm2

555: /* .. same par doesnt */
556: and bbm.alternate_bom_designator is null
557: /* .. exist with this alt */
558: and not exists (select NULL
559: from bom_bill_of_materials bbm2
560: where bbm2.organization_id = c_org_id
561: and bbm2.assembly_item_id = bbm.assembly_item_id
562: and bbm2.alternate_bom_designator =
563: bitt.lowest_alternate_designator