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 631: bom_bill_of_materials bom,

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

Line 798: bom_bill_of_materials b

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

Line 892: bom_bill_of_materials b,

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

Line 989: FROM bom_bill_of_materials b

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

Line 1078: FROM bom_bill_of_materials cb,

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

Line 1079: bom_bill_of_materials b,

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

Line 1165: FROM bom_bill_of_materials b

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

Line 1179: FROM bom_bill_of_materials b

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

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

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

Line 1442: bom_bill_of_materials b,

1438: ri.use_up_plan_name,
1439: ri.from_end_item_unit_number
1440: FROM bom_lists l,
1441: eng_revised_items_interface ri,
1442: bom_bill_of_materials b,
1443: mtl_system_items_b itm
1444: WHERE
1445: ((l.alternate_designator IS NULL
1446: AND b.alternate_bom_designator IS NULL)

Line 1541: bom_bill_of_materials b,

1537: Nvl(o.component_remarks,c.component_remarks)
1538: component_remarks --Bug 3347094
1539: FROM mtl_system_items_b ci_itm,
1540: mtl_system_items_b ri_itm,
1541: bom_bill_of_materials b,
1542: bom_inventory_components c,
1543: bom_inventory_comps_interface o,
1544: eng_revised_items_interface ri
1545: WHERE (c.item_num = o.item_num OR o.item_num IS NULL)

Line 1683: bom_bill_of_materials b,

1679: Nvl(o.component_remarks,c.component_remarks)
1680: component_remarks --Bug 3347094
1681: FROM mtl_system_items_b ci_itm,
1682: mtl_system_items_b ri_itm,
1683: bom_bill_of_materials b,
1684: bom_inventory_components c,
1685: bom_inventory_comps_interface n, -- new attributes
1686: bom_inventory_comps_interface o, -- old attributes
1687: eng_revised_items_interface ri

Line 1878: bom_bill_of_materials b,

1874: -- added attribute information to resolve BUG# 2784395
1875:
1876: FROM mtl_system_items_b ci_itm,
1877: mtl_system_items_b ri_itm,
1878: bom_bill_of_materials b,
1879: bom_inventory_components c,
1880: bom_inventory_comps_interface n, -- new attributes
1881: bom_inventory_comps_interface o, -- old attributes
1882: eng_revised_items_interface ri

Line 2023: bom_bill_of_materials b,

2019: i.attribute15
2020: -- added Attribute information for BUG #2784395
2021: FROM mtl_system_items_b ci_itm,
2022: mtl_system_items_b bi_itm,
2023: bom_bill_of_materials b,
2024: bom_inventory_comps_interface i,
2025: eng_revised_items_interface ri
2026: WHERE i.acd_type = action_add
2027: AND ci_itm.inventory_item_id = i.component_item_id

Line 2078: bom_bill_of_materials b

2074: bom_inventory_comps_interface o, -- old attributes
2075: eng_revised_items_interface ri,
2076: bom_reference_designators brd,
2077: mtl_system_items_b ri_itm,
2078: bom_bill_of_materials b
2079: WHERE n.old_component_sequence_id = o.component_sequence_id
2080: AND brd.component_sequence_id = c.component_Sequence_id
2081: AND (n.component_item_id <> o.component_item_id)
2082: AND (c.item_num = o.item_num OR o.item_num IS NULL)