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 381: BOM_BILL_OF_MATERIALS BBM,

377: BIC.TO_END_ITEM_UNIT_NUMBER TUN
378: FROM
379: BOM_SMALL_IMPL_TEMP BITT,
380: BOM_INVENTORY_COMPONENTS BIC,
381: BOM_BILL_OF_MATERIALS BBM,
382: MTL_SYSTEM_ITEMS MSI
383: where bic.pk1_value = BITT.PARENT_ITEM_ID and
384: bic.pk2_value = NVL(bbm.common_organization_id,bbm.organization_id) and
385: bitt.current_level = 0

Line 413: from bom_bill_of_materials bbm2

409: ( bitt.lowest_alternate_designator is null /*and bill with spec*/
410: and bbm.alternate_bom_designator is not null
411: /* alt doesnt exist */
412: and not exists (select NULL /*for current item */
413: from bom_bill_of_materials bbm2
414: where bbm2.organization_id = c_org_id
415: and bbm2.assembly_item_id = bitt.parent_item_id
416: and bbm2.alternate_bom_designator =
417: bbm.alternate_bom_designator

Line 432: from bom_bill_of_materials bbm2

428: /* same par doesnt */
429: and bbm.alternate_bom_designator is null
430: /* exist with this alt */
431: and not exists (select NULL
432: from bom_bill_of_materials bbm2
433: where bbm2.organization_id = c_org_id
434: and bbm2.assembly_item_id = bbm.assembly_item_id
435: and bbm2.alternate_bom_designator =
436: bitt.lowest_alternate_designator

Line 1047: BOM_BILL_OF_MATERIALS BBM,

1043: BIC.TO_END_ITEM_UNIT_NUMBER TUN
1044: FROM
1045: BOM_SMALL_IMPL_TEMP BITT,
1046: BOM_INVENTORY_COMPONENTS BIC,
1047: BOM_BILL_OF_MATERIALS BBM,
1048: MTL_SYSTEM_ITEMS MSI
1049: where bic.pk1_value = BITT.PARENT_ITEM_ID and
1050: bic.pk2_value = NVL(bbm.common_organization_id, bbm.organization_id) and
1051: bitt.current_level = c_current_level

Line 1073: from bom_bill_of_materials bbm2

1069: or bbm.alternate_bom_designator = bitt.lowest_alternate_designator
1070: or ( bitt.lowest_alternate_designator is null
1071: and bbm.alternate_bom_designator is not null
1072: and not exists (select NULL /*for current item */
1073: from bom_bill_of_materials bbm2
1074: where bbm2.organization_id = c_org_id
1075: and bbm2.assembly_item_id =
1076: bitt.parent_item_id
1077: and bbm2.alternate_bom_designator =

Line 1089: from bom_bill_of_materials bbm2

1085: null and bill for .. */
1086: (bitt.lowest_alternate_designator is not null
1087: and bbm.alternate_bom_designator is null
1088: and not exists (select NULL
1089: from bom_bill_of_materials bbm2
1090: where bbm2.organization_id = c_org_id
1091: and bbm2.assembly_item_id =
1092: bbm.assembly_item_id
1093: and bbm2.alternate_bom_designator =