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

Line 329: FROM bom_bill_of_materials b

325: DELETE FROM bom_lists l
326: WHERE l.sequence_id = p_list_id
327: AND EXISTS (
328: SELECT NULL
329: FROM bom_bill_of_materials b
330: WHERE b.assembly_item_id = l.assembly_item_id
331: AND b.organization_id = p_org_id
332: AND ( (b.alternate_bom_designator IS NULL AND l.alternate_designator IS NULL)
333: OR (b.alternate_bom_designator = l.alternate_designator) )

Line 632: bom_bill_of_materials bom,

628: SELECT NULL
629: FROM mtl_system_items_b ri_itm, -- revised item
630: mtl_system_items_b ci_itm, -- component item
631: bom_inventory_components c,
632: bom_bill_of_materials bom,
633: bom_inventory_comps_interface o, -- old component
634: bom_inventory_comps_interface n, -- new component
635: eng_revised_items_interface ri
636: WHERE ri_itm.inventory_item_id = bom.assembly_item_id

Line 799: bom_bill_of_materials b

795: AND ri_itm.inventory_item_id = l.assembly_item_id
796: AND NOT EXISTS (
797: SELECT NULL
798: FROM bom_inventory_components c,
799: bom_bill_of_materials b
800: WHERE c.component_item_id = ri.use_up_item_id
801: AND b.bill_sequence_id = c.bill_sequence_id
802: AND b.assembly_item_id = l.assembly_item_id
803: AND b.organization_id = p_organization

Line 893: bom_bill_of_materials b,

889: WHERE l.sequence_id = p_list_id
890: AND EXISTS (
891: SELECT NULL
892: FROM bom_inventory_components c,
893: bom_bill_of_materials b,
894: bom_inventory_comps_interface ci,
895: eng_revised_items_interface ri
896: WHERE c.implementation_date IS NOT NULL
897: AND c.operation_seq_num =

Line 990: FROM bom_bill_of_materials b

986: AND ri.organization_id = p_organization
987: )
988: AND EXISTS (
989: SELECT NULL
990: FROM bom_bill_of_materials b
991: WHERE b.assembly_type = mfg
992: AND b.assembly_item_id = l.assembly_item_id
993: AND b.organization_id = p_organization
994: AND ( (b.alternate_bom_designator IS NULL AND l.alternate_designator IS NULL)

Line 1079: FROM bom_bill_of_materials cb,

1075: DELETE FROM bom_lists l
1076: WHERE l.sequence_id = p_list_id
1077: AND EXISTS (
1078: SELECT NULL
1079: FROM bom_bill_of_materials cb,
1080: bom_bill_of_materials b,
1081: bom_inventory_comps_interface ci,
1082: eng_revised_items_interface ri
1083: WHERE NOT EXISTS (

Line 1080: bom_bill_of_materials b,

1076: WHERE l.sequence_id = p_list_id
1077: AND EXISTS (
1078: SELECT NULL
1079: FROM bom_bill_of_materials cb,
1080: bom_bill_of_materials b,
1081: bom_inventory_comps_interface ci,
1082: eng_revised_items_interface ri
1083: WHERE NOT EXISTS (
1084: SELECT NULL

Line 1166: FROM bom_bill_of_materials b

1162: DELETE FROM bom_lists l
1163: WHERE l.sequence_id = p_list_id
1164: AND EXISTS (
1165: SELECT NULL
1166: FROM bom_bill_of_materials b
1167: WHERE b.common_bill_sequence_id <> b.bill_sequence_id
1168: AND ( (b.alternate_bom_designator IS NULL AND l.alternate_designator IS NULL)
1169: OR (b.alternate_bom_designator = l.alternate_designator) )
1170: AND b.organization_id = p_organization

Line 1180: FROM bom_bill_of_materials b

1176: DELETE FROM bom_lists l
1177: WHERE l.sequence_id = p_list_id
1178: AND EXISTS (
1179: SELECT NULL
1180: FROM bom_bill_of_materials b
1181: WHERE b.assembly_item_id = l.assembly_item_id
1182: AND b.organization_id = p_organization
1183: AND ( (b.alternate_bom_designator IS NULL AND l.alternate_designator IS NULL)
1184: OR (b.alternate_bom_designator = l.alternate_designator) )

Line 1426: -- This is done to avoid FULL Table scan on Bom_bill_of_materials Table

1422: -- Bug 1807268
1423: -- Changed the following cursor for performance issue
1424: -- Remove NVL from alternate designator.
1425: -- Also added condition l.organization_id = p_org_id
1426: -- This is done to avoid FULL Table scan on Bom_bill_of_materials Table
1427: -- and thus reduce the Cost
1428: --
1429: CURSOR c_get_bom_list(p_list_id IN bom_lists.sequence_id%TYPE,
1430: p_org_id IN bom_lists.organization_id%TYPE) IS

Line 1447: bom_bill_of_materials b,

1443: ri.use_up_plan_name,
1444: ri.from_end_item_unit_number
1445: FROM bom_lists l,
1446: eng_revised_items_interface ri,
1447: bom_bill_of_materials b,
1448: mtl_system_items_b itm
1449: WHERE
1450: ((l.alternate_designator IS NULL
1451: AND b.alternate_bom_designator IS NULL)

Line 1546: bom_bill_of_materials b,

1542: Nvl(o.component_remarks,c.component_remarks)
1543: component_remarks --Bug 3347094
1544: FROM mtl_system_items_b ci_itm,
1545: mtl_system_items_b ri_itm,
1546: bom_bill_of_materials b,
1547: bom_inventory_components c,
1548: bom_inventory_comps_interface o,
1549: eng_revised_items_interface ri
1550: WHERE (c.item_num = o.item_num OR o.item_num IS NULL)

Line 1688: bom_bill_of_materials b,

1684: Nvl(o.component_remarks,c.component_remarks)
1685: component_remarks --Bug 3347094
1686: FROM mtl_system_items_b ci_itm,
1687: mtl_system_items_b ri_itm,
1688: bom_bill_of_materials b,
1689: bom_inventory_components c,
1690: bom_inventory_comps_interface n, -- new attributes
1691: bom_inventory_comps_interface o, -- old attributes
1692: eng_revised_items_interface ri

Line 1883: bom_bill_of_materials b,

1879: -- added attribute information to resolve BUG# 2784395
1880:
1881: FROM mtl_system_items_b ci_itm,
1882: mtl_system_items_b ri_itm,
1883: bom_bill_of_materials b,
1884: bom_inventory_components c,
1885: bom_inventory_comps_interface n, -- new attributes
1886: bom_inventory_comps_interface o, -- old attributes
1887: eng_revised_items_interface ri

Line 2028: bom_bill_of_materials b,

2024: i.attribute15
2025: -- added Attribute information for BUG #2784395
2026: FROM mtl_system_items_b ci_itm,
2027: mtl_system_items_b bi_itm,
2028: bom_bill_of_materials b,
2029: bom_inventory_comps_interface i,
2030: eng_revised_items_interface ri
2031: WHERE i.acd_type = action_add
2032: AND ci_itm.inventory_item_id = i.component_item_id

Line 2084: bom_bill_of_materials b

2080: bom_inventory_comps_interface o, -- old attributes
2081: eng_revised_items_interface ri,
2082: bom_reference_designators brd,
2083: mtl_system_items_b ri_itm,
2084: bom_bill_of_materials b
2085: WHERE n.old_component_sequence_id = o.component_sequence_id
2086: AND brd.component_sequence_id = c.component_Sequence_id
2087: AND (n.component_item_id <> o.component_item_id)
2088: AND (c.item_num = o.item_num OR o.item_num IS NULL)