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.BOMPIINQ dependencies on BOM_BILL_OF_MATERIALS

Line 368: BOM_BILL_OF_MATERIALS BBM,

364: BIC.TO_END_ITEM_UNIT_NUMBER TUN
365: FROM
366: BOM_SMALL_IMPL_TEMP BITT,
367: BOM_INVENTORY_COMPONENTS BIC,
368: BOM_BILL_OF_MATERIALS BBM,
369: MTL_SYSTEM_ITEMS MSI
370: where bitt.current_level = 0
371: and bitt.organization_id = c_org_id
372: and MSI.ORGANIZATION_ID = BBM.ORGANIZATION_ID

Line 398: from bom_bill_of_materials bbm2

394: ( bitt.lowest_alternate_designator is null /*and bill with spec*/
395: and bbm.alternate_bom_designator is not null
396: /* alt doesnt exist */
397: and not exists (select NULL /*for current item */
398: from bom_bill_of_materials bbm2
399: where bbm2.organization_id = c_org_id
400: and bbm2.assembly_item_id = bitt.parent_item_id
401: and bbm2.alternate_bom_designator =
402: bbm.alternate_bom_designator

Line 417: from bom_bill_of_materials bbm2

413: /* same par doesnt */
414: and bbm.alternate_bom_designator is null
415: /* exist with this alt */
416: and not exists (select NULL
417: from bom_bill_of_materials bbm2
418: where bbm2.organization_id = c_org_id
419: and bbm2.assembly_item_id = bbm.assembly_item_id
420: and bbm2.alternate_bom_designator =
421: bitt.lowest_alternate_designator

Line 1019: BOM_BILL_OF_MATERIALS BBM,

1015: BIC.TO_END_ITEM_UNIT_NUMBER TUN
1016: FROM
1017: BOM_SMALL_IMPL_TEMP BITT,
1018: BOM_INVENTORY_COMPONENTS BIC,
1019: BOM_BILL_OF_MATERIALS BBM,
1020: MTL_SYSTEM_ITEMS MSI
1021: where
1022: bitt.current_level = c_current_level
1023: and bitt.organization_id = c_org_id

Line 1044: from bom_bill_of_materials bbm2

1040: or bbm.alternate_bom_designator = bitt.lowest_alternate_designator
1041: or ( bitt.lowest_alternate_designator is null
1042: and bbm.alternate_bom_designator is not null
1043: and not exists (select NULL /*for current item */
1044: from bom_bill_of_materials bbm2
1045: where bbm2.organization_id = c_org_id
1046: and bbm2.assembly_item_id =
1047: bitt.parent_item_id
1048: and bbm2.alternate_bom_designator =

Line 1060: from bom_bill_of_materials bbm2

1056: null and bill for .. */
1057: (bitt.lowest_alternate_designator is not null
1058: and bbm.alternate_bom_designator is null
1059: and not exists (select NULL
1060: from bom_bill_of_materials bbm2
1061: where bbm2.organization_id = c_org_id
1062: and bbm2.assembly_item_id =
1063: bbm.assembly_item_id
1064: and bbm2.alternate_bom_designator =