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 MTL_SYSTEM_ITEMS_B

Line 537: FROM mtl_system_items_b ri,

533: DELETE FROM bom_lists l
534: WHERE l.sequence_id = p_list_id
535: AND EXISTS (
536: SELECT NULL
537: FROM mtl_system_items_b ri,
538: mtl_system_items_b ci,
539: bom_inventory_comps_interface c,
540: eng_revised_items_interface r
541: WHERE ((ci.bom_item_type = planning_type AND

Line 538: mtl_system_items_b ci,

534: WHERE l.sequence_id = p_list_id
535: AND EXISTS (
536: SELECT NULL
537: FROM mtl_system_items_b ri,
538: mtl_system_items_b ci,
539: bom_inventory_comps_interface c,
540: eng_revised_items_interface r
541: WHERE ((ci.bom_item_type = planning_type AND
542: ri.bom_item_type <> planning_type)

Line 597: FROM mtl_system_items_b i,

593: DELETE FROM bom_lists l
594: WHERE l.sequence_id = p_list_id
595: AND EXISTS (
596: SELECT NULL
597: FROM mtl_system_items_b i,
598: mtl_system_items_b ci,
599: bom_inventory_comps_interface c,
600: eng_revised_items_interface r
601: WHERE ((c.optional = yes AND i.bom_item_type

Line 598: mtl_system_items_b ci,

594: WHERE l.sequence_id = p_list_id
595: AND EXISTS (
596: SELECT NULL
597: FROM mtl_system_items_b i,
598: mtl_system_items_b ci,
599: bom_inventory_comps_interface c,
600: eng_revised_items_interface r
601: WHERE ((c.optional = yes AND i.bom_item_type
602: NOT IN (model_type, option_class_type))

Line 628: FROM mtl_system_items_b ri_itm, -- revised item

624: DELETE FROM bom_lists bl
625: WHERE bl.sequence_id = p_list_id
626: AND EXISTS (
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

Line 629: mtl_system_items_b ci_itm, -- component item

625: WHERE bl.sequence_id = p_list_id
626: AND EXISTS (
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

Line 788: mtl_system_items_b ri_itm

784: WHERE l.sequence_id = p_list_id
785: AND EXISTS (
786: SELECT NULL
787: FROM eng_revised_items_interface ri,
788: mtl_system_items_b ri_itm
789: WHERE ri.use_up = yes
790: AND ri.change_notice = p_eco
791: AND ri.organization_id = p_organization
792: AND ri.use_up_item_id <> l.assembly_item_id

Line 935: mtl_system_items_b ri_itm

931: bom_inventory_comps_interface ci,
932: bom_inventory_comps_interface cir,
933: eng_revised_items_interface ri,
934: bom_components_b co,
935: mtl_system_items_b ri_itm
936: WHERE c.implementation_date IS NOT NULL
937: AND c.operation_seq_num =
938: NVL(ci.operation_seq_num, NVL(cir.operation_seq_num,
939: co.operation_seq_num))

Line 976: FROM mtl_system_items_b i,

972: DELETE FROM bom_lists l
973: WHERE l.sequence_id = p_list_id
974: AND EXISTS (
975: SELECT NULL
976: FROM mtl_system_items_b i,
977: bom_inventory_comps_interface ci,
978: eng_revised_items_interface ri
979: WHERE i.eng_item_flag = 'Y'
980: AND i.inventory_item_id = ci.component_item_id

Line 1005: FROM mtl_system_items_b i,

1001: DELETE FROM bom_lists l
1002: WHERE l.sequence_id = p_list_id
1003: AND EXISTS (
1004: SELECT NULL
1005: FROM mtl_system_items_b i,
1006: bom_inventory_comps_interface ci,
1007: bom_inventory_comps_interface cir,
1008: eng_revised_items_interface ri
1009: WHERE i.eng_item_flag = 'Y'

Line 1042: mtl_system_items_b ri_itm

1038: FROM bom_components_b c,
1039: bom_structures_b b,
1040: bom_inventory_comps_interface ci,
1041: eng_revised_items_interface ri,
1042: mtl_system_items_b ri_itm
1043: WHERE c.operation_seq_num =
1044: NVL(ci.operation_seq_num, c.operation_seq_num)
1045: AND c.component_item_id = ci.component_item_id
1046: AND c.bill_sequence_id = b.bill_sequence_id

Line 1084: FROM mtl_system_items_b i

1080: bom_inventory_comps_interface ci,
1081: eng_revised_items_interface ri
1082: WHERE NOT EXISTS (
1083: SELECT NULL
1084: FROM mtl_system_items_b i
1085: WHERE i.eng_item_flag = DECODE(cb.assembly_type,
1086: 1, 'N',
1087: 2, i.eng_item_flag)
1088: AND i.bom_enabled_flag = 'Y'

Line 1197: FROM mtl_system_items_b msi

1193: DELETE FROM bom_lists l
1194: WHERE l.sequence_id = p_list_id
1195: AND EXISTS (
1196: SELECT NULL
1197: FROM mtl_system_items_b msi
1198: WHERE msi.inventory_item_id = l.assembly_item_id
1199: AND msi.organization_id = p_organization
1200: AND msi.bom_item_type = 5
1201: );

Line 1210: FROM mtl_system_items_b i

1206: DELETE FROM bom_lists l
1207: WHERE l.sequence_id = p_list_id
1208: AND EXISTS (
1209: SELECT NULL
1210: FROM mtl_system_items_b i
1211: WHERE i.inventory_item_id = l.assembly_item_id
1212: AND i.organization_id = p_organization
1213: AND ((i.bom_item_type = DECODE(p_model_item_access,
1214: no, model_type))

Line 1235: mtl_system_items_b i

1231: WHERE l.sequence_id = p_list_id
1232: AND EXISTS (
1233: SELECT NULL
1234: FROM eng_revised_items_interface r,
1235: mtl_system_items_b i
1236: WHERE r.item_type <> NVL(i.item_type, 'NONE')
1237: AND i.organization_id = p_organization
1238: AND i.inventory_item_id = l.assembly_item_id
1239: AND r.change_notice = p_change_order

Line 1250: mtl_system_items_b i

1246: WHERE l.sequence_id = p_list_id
1247: AND EXISTS (
1248: SELECT NULL
1249: FROM eng_revised_items_interface r,
1250: mtl_system_items_b i
1251: WHERE r.base_item_id <> NVL(i.base_item_id, -1)
1252: AND i.organization_id = r.organization_id
1253: AND i.inventory_item_id = l.assembly_item_id
1254: AND r.change_notice = p_change_order

Line 1262: mtl_system_items_b i

1258: DELETE FROM bom_lists l
1259: WHERE l.sequence_id = p_list_id
1260: AND EXISTS (SELECT NULL
1261: FROM eng_revised_items_interface r,
1262: mtl_system_items_b i
1263: WHERE i.inventory_item_status_code in ('Obsolete','Inactive')
1264: AND i.organization_id = r.organization_id
1265: AND i.inventory_item_id = l.assembly_item_id
1266: AND r.change_notice = p_change_order

Line 1279: FROM mtl_system_items_b i

1275: DELETE FROM bom_lists l
1276: WHERE l.sequence_id = p_list_id
1277: AND EXISTS (
1278: SELECT NULL
1279: FROM mtl_system_items_b i
1280: WHERE i.effectivity_control <> 1
1281: AND i.organization_id = p_organization
1282: AND i.inventory_item_id = l.assembly_item_id);
1283: */

Line 1443: mtl_system_items_b itm

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)
1447: OR b.alternate_bom_designator = l.alternate_designator)

Line 1539: FROM mtl_system_items_b ci_itm,

1535: ri.from_end_item_unit_number,
1536: o.to_end_item_unit_number,
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,

Line 1540: mtl_system_items_b ri_itm,

1536: o.to_end_item_unit_number,
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

Line 1681: FROM mtl_system_items_b ci_itm,

1677: ri.from_end_item_unit_number,
1678: NVL(o.to_end_item_unit_number, c.to_end_item_unit_number) to_end_item_unit_number,
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

Line 1682: mtl_system_items_b ri_itm,

1678: NVL(o.to_end_item_unit_number, c.to_end_item_unit_number) to_end_item_unit_number,
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

Line 1876: FROM mtl_system_items_b ci_itm,

1872: NVL(n.attribute14, c.attribute14) attribute14,
1873: NVL(n.attribute15, c.attribute15) attribute15
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

Line 1877: mtl_system_items_b ri_itm,

1873: NVL(n.attribute15, c.attribute15) attribute15
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

Line 2021: FROM mtl_system_items_b ci_itm,

2017: i.attribute13,
2018: i.attribute14,
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

Line 2022: mtl_system_items_b bi_itm,

2018: i.attribute14,
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

Line 2077: mtl_system_items_b ri_itm,

2073: bom_inventory_comps_interface n, -- new attributes
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)

Line 2622: FROM mtl_system_items_b itm,

2618: NVL(i.supply_subinventory, c.supply_subinventory),
2619: NVL(i.supply_locator_id, c.supply_locator_id),
2620: r.revised_item_sequence_id,
2621: itm.bom_item_type
2622: FROM mtl_system_items_b itm,
2623: bom_inventory_components c,
2624: bom_inventory_comps_interface i,
2625: eng_revised_items_interface ri,
2626: eng_revised_items r

Line 2847: FROM mtl_system_items_b itm,

2843: NVL(o.supply_subinventory, c.supply_subinventory),
2844: NVL(o.supply_locator_id, c.supply_locator_id),
2845: r.revised_item_sequence_id,
2846: itm.bom_item_type
2847: FROM mtl_system_items_b itm,
2848: bom_inventory_components c,
2849: bom_inventory_comps_interface n, -- new attributes
2850: bom_inventory_comps_interface o, -- old attributes
2851: eng_revised_items_interface ri,

Line 3118: FROM mtl_system_items_b itm,

3114: NVL(n.supply_locator_id, DECODE(o.supply_locator_id, NULL,
3115: c.supply_locator_id, NULL)),
3116: r.revised_item_sequence_id,
3117: itm.bom_item_type
3118: FROM mtl_system_items_b itm,
3119: bom_inventory_components c,
3120: bom_inventory_comps_interface n, -- new attributes
3121: bom_inventory_comps_interface o, -- old attributes
3122: eng_revised_items_interface ri,

Line 3407: FROM mtl_system_items_b itm,

3403: i.supply_subinventory,
3404: i.supply_locator_id,
3405: r.revised_item_sequence_id,
3406: itm.bom_item_type
3407: FROM mtl_system_items_b itm,
3408: bom_inventory_comps_interface i,
3409: eng_revised_items_interface ri,
3410: eng_revised_items r
3411: WHERE r.revised_item_sequence_id =

Line 3668: mtl_system_items_b i

3664: SET check_atp = no
3665: WHERE revised_item_sequence_id IN (
3666: SELECT r.revised_item_sequence_id
3667: FROM eng_revised_items r,
3668: mtl_system_items_b i
3669: WHERE i.atp_components_flag = 'N'
3670: AND i.pick_components_flag = 'N'
3671: AND i.replenish_to_order_flag = 'N'
3672: AND i.wip_supply_type <> phantom

Line 3718: FROM mtl_system_items_b i,

3714: UPDATE bom_inventory_components
3715: SET wip_supply_type = phantom
3716: WHERE component_sequence_id IN (
3717: SELECT c.component_sequence_id
3718: FROM mtl_system_items_b i,
3719: mtl_system_items_b ci,
3720: bom_inventory_components c,
3721: eng_revised_items r
3722: WHERE ci.bom_item_type IN (model_type, option_class_type)

Line 3719: mtl_system_items_b ci,

3715: SET wip_supply_type = phantom
3716: WHERE component_sequence_id IN (
3717: SELECT c.component_sequence_id
3718: FROM mtl_system_items_b i,
3719: mtl_system_items_b ci,
3720: bom_inventory_components c,
3721: eng_revised_items r
3722: WHERE ci.bom_item_type IN (model_type, option_class_type)
3723: AND ci.inventory_item_id = c.component_item_id

Line 3735: FROM mtl_system_items_b i,

3731: UPDATE bom_inventory_components
3732: SET optional = yes
3733: WHERE component_sequence_id IN (
3734: SELECT c.component_sequence_id
3735: FROM mtl_system_items_b i,
3736: mtl_system_items_b ci,
3737: bom_inventory_components c,
3738: eng_revised_items r
3739: WHERE ci.base_item_id IS NULL

Line 3736: mtl_system_items_b ci,

3732: SET optional = yes
3733: WHERE component_sequence_id IN (
3734: SELECT c.component_sequence_id
3735: FROM mtl_system_items_b i,
3736: mtl_system_items_b ci,
3737: bom_inventory_components c,
3738: eng_revised_items r
3739: WHERE ci.base_item_id IS NULL
3740: AND ci.replenish_to_order_flag = 'Y'