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 148: BOM_BILL_OF_MATERIALS BBM

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
152: and bitt.parent_item_id = bic.component_item_id

Line 173: from bom_bill_of_materials bbm2

169: ( bitt.lowest_alternate_designator is null /*and bill with spec*/
170: and bbm.alternate_bom_designator is not null
171: /* alt doesnt exist */
172: and not exists (select NULL /*for current item */
173: from bom_bill_of_materials bbm2
174: where bbm2.organization_id = c_org_id
175: and bbm2.assembly_item_id = bitt.parent_item_id
176: and bbm2.alternate_bom_designator =
177: bbm.alternate_bom_designator

Line 192: from bom_bill_of_materials bbm2

188: /* same par doesnt */
189: and bbm.alternate_bom_designator is null
190: /* exist with this alt */
191: and not exists (select NULL
192: from bom_bill_of_materials bbm2
193: where bbm2.organization_id = c_org_id
194: and bbm2.assembly_item_id = bbm.assembly_item_id
195: and bbm2.alternate_bom_designator =
196: bitt.lowest_alternate_designator

Line 482: BOM_BILL_OF_MATERIALS BBM

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
486: and bitt.sequence_id = c_sequence_id

Line 525: from bom_bill_of_materials bbm2

521: ( bitt.lowest_alternate_designator is null
522: and bbm.alternate_bom_designator is not null
523: /* alt doesnt exist */
524: and not exists (select NULL /*for current item */
525: from bom_bill_of_materials bbm2
526: where bbm2.organization_id = c_org_id
527: and bbm2.assembly_item_id = bitt.parent_item_id
528: and bbm2.alternate_bom_designator =
529: bbm.alternate_bom_designator

Line 546: from bom_bill_of_materials bbm2

542: /* .. same par doesnt */
543: and bbm.alternate_bom_designator is null
544: /* .. exist with this alt */
545: and not exists (select NULL
546: from bom_bill_of_materials bbm2
547: where bbm2.organization_id = c_org_id
548: and bbm2.assembly_item_id = bbm.assembly_item_id
549: and bbm2.alternate_bom_designator =
550: bitt.lowest_alternate_designator