[Home] [Help]
534: DELETE FROM bom_lists l
535: WHERE l.sequence_id = p_list_id
536: AND EXISTS (
537: SELECT NULL
538: FROM mtl_system_items_b ri,
539: mtl_system_items_b ci,
540: bom_inventory_comps_interface c,
541: eng_revised_items_interface r
542: WHERE ((ci.bom_item_type = planning_type AND
535: WHERE l.sequence_id = p_list_id
536: AND EXISTS (
537: SELECT NULL
538: FROM mtl_system_items_b ri,
539: mtl_system_items_b ci,
540: bom_inventory_comps_interface c,
541: eng_revised_items_interface r
542: WHERE ((ci.bom_item_type = planning_type AND
543: ri.bom_item_type <> planning_type)
594: DELETE FROM bom_lists l
595: WHERE l.sequence_id = p_list_id
596: AND EXISTS (
597: SELECT NULL
598: FROM mtl_system_items_b i,
599: mtl_system_items_b ci,
600: bom_inventory_comps_interface c,
601: eng_revised_items_interface r
602: WHERE ((c.optional = yes AND i.bom_item_type
595: WHERE l.sequence_id = p_list_id
596: AND EXISTS (
597: SELECT NULL
598: FROM mtl_system_items_b i,
599: mtl_system_items_b ci,
600: bom_inventory_comps_interface c,
601: eng_revised_items_interface r
602: WHERE ((c.optional = yes AND i.bom_item_type
603: NOT IN (model_type, option_class_type))
625: DELETE FROM bom_lists bl
626: WHERE bl.sequence_id = p_list_id
627: AND EXISTS (
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
626: WHERE bl.sequence_id = p_list_id
627: AND EXISTS (
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
785: WHERE l.sequence_id = p_list_id
786: AND EXISTS (
787: SELECT NULL
788: FROM eng_revised_items_interface ri,
789: mtl_system_items_b ri_itm
790: WHERE ri.use_up = yes
791: AND ri.change_notice = p_eco
792: AND ri.organization_id = p_organization
793: AND ri.use_up_item_id <> l.assembly_item_id
932: bom_inventory_comps_interface ci,
933: bom_inventory_comps_interface cir,
934: eng_revised_items_interface ri,
935: bom_components_b co,
936: mtl_system_items_b ri_itm
937: WHERE c.implementation_date IS NOT NULL
938: AND c.operation_seq_num =
939: NVL(ci.operation_seq_num, NVL(cir.operation_seq_num,
940: co.operation_seq_num))
973: DELETE FROM bom_lists l
974: WHERE l.sequence_id = p_list_id
975: AND EXISTS (
976: SELECT NULL
977: FROM mtl_system_items_b i,
978: bom_inventory_comps_interface ci,
979: eng_revised_items_interface ri
980: WHERE i.eng_item_flag = 'Y'
981: AND i.inventory_item_id = ci.component_item_id
1002: DELETE FROM bom_lists l
1003: WHERE l.sequence_id = p_list_id
1004: AND EXISTS (
1005: SELECT NULL
1006: FROM mtl_system_items_b i,
1007: bom_inventory_comps_interface ci,
1008: bom_inventory_comps_interface cir,
1009: eng_revised_items_interface ri
1010: WHERE i.eng_item_flag = 'Y'
1039: FROM bom_components_b c,
1040: bom_structures_b b,
1041: bom_inventory_comps_interface ci,
1042: eng_revised_items_interface ri,
1043: mtl_system_items_b ri_itm
1044: WHERE c.operation_seq_num =
1045: NVL(ci.operation_seq_num, c.operation_seq_num)
1046: AND c.component_item_id = ci.component_item_id
1047: AND c.bill_sequence_id = b.bill_sequence_id
1081: bom_inventory_comps_interface ci,
1082: eng_revised_items_interface ri
1083: WHERE NOT EXISTS (
1084: SELECT NULL
1085: FROM mtl_system_items_b i
1086: WHERE i.eng_item_flag = DECODE(cb.assembly_type,
1087: 1, 'N',
1088: 2, i.eng_item_flag)
1089: AND i.bom_enabled_flag = 'Y'
1194: DELETE FROM bom_lists l
1195: WHERE l.sequence_id = p_list_id
1196: AND EXISTS (
1197: SELECT NULL
1198: FROM mtl_system_items_b msi
1199: WHERE msi.inventory_item_id = l.assembly_item_id
1200: AND msi.organization_id = p_organization
1201: AND msi.bom_item_type = 5
1202: );
1207: DELETE FROM bom_lists l
1208: WHERE l.sequence_id = p_list_id
1209: AND EXISTS (
1210: SELECT NULL
1211: FROM mtl_system_items_b i
1212: WHERE i.inventory_item_id = l.assembly_item_id
1213: AND i.organization_id = p_organization
1214: AND ((i.bom_item_type = DECODE(p_model_item_access,
1215: no, model_type))
1232: WHERE l.sequence_id = p_list_id
1233: AND EXISTS (
1234: SELECT NULL
1235: FROM eng_revised_items_interface r,
1236: mtl_system_items_b i
1237: WHERE r.item_type <> NVL(i.item_type, 'NONE')
1238: AND i.organization_id = p_organization
1239: AND i.inventory_item_id = l.assembly_item_id
1240: AND r.change_notice = p_change_order
1247: WHERE l.sequence_id = p_list_id
1248: AND EXISTS (
1249: SELECT NULL
1250: FROM eng_revised_items_interface r,
1251: mtl_system_items_b i
1252: WHERE r.base_item_id <> NVL(i.base_item_id, -1)
1253: AND i.organization_id = r.organization_id
1254: AND i.inventory_item_id = l.assembly_item_id
1255: AND r.change_notice = p_change_order
1259: DELETE FROM bom_lists l
1260: WHERE l.sequence_id = p_list_id
1261: AND EXISTS (SELECT NULL
1262: FROM eng_revised_items_interface r,
1263: mtl_system_items_b i,
1264: bom_parameters bp
1265: WHERE (i.inventory_item_status_code in ('Obsolete','Inactive')
1266: OR i.inventory_item_status_code = nvl(bp.bom_delete_status_code, FND_API.G_MISS_CHAR)
1267: OR i.bom_enabled_flag = 'N' )-- Modified for bug 13362684
1280: DELETE FROM bom_lists l
1281: WHERE l.sequence_id = p_list_id
1282: AND EXISTS (
1283: SELECT NULL
1284: FROM mtl_system_items_b i
1285: WHERE i.effectivity_control <> 1
1286: AND i.organization_id = p_organization
1287: AND i.inventory_item_id = l.assembly_item_id);
1288: */
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)
1452: OR b.alternate_bom_designator = l.alternate_designator)
1540: ri.from_end_item_unit_number,
1541: o.to_end_item_unit_number,
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,
1541: o.to_end_item_unit_number,
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
1682: ri.from_end_item_unit_number,
1683: NVL(o.to_end_item_unit_number, c.to_end_item_unit_number) to_end_item_unit_number,
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
1683: NVL(o.to_end_item_unit_number, c.to_end_item_unit_number) to_end_item_unit_number,
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
1877: NVL(n.attribute14, c.attribute14) attribute14,
1878: NVL(n.attribute15, c.attribute15) attribute15
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
1878: NVL(n.attribute15, c.attribute15) attribute15
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
2022: i.attribute13,
2023: i.attribute14,
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
2023: i.attribute14,
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
2079: bom_inventory_comps_interface n, -- new attributes
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)
2624: NVL(i.supply_subinventory, c.supply_subinventory),
2625: NVL(i.supply_locator_id, c.supply_locator_id),
2626: r.revised_item_sequence_id,
2627: itm.bom_item_type
2628: FROM mtl_system_items_b itm,
2629: bom_inventory_components c,
2630: bom_inventory_comps_interface i,
2631: eng_revised_items_interface ri,
2632: eng_revised_items r
2849: NVL(o.supply_subinventory, c.supply_subinventory),
2850: NVL(o.supply_locator_id, c.supply_locator_id),
2851: r.revised_item_sequence_id,
2852: itm.bom_item_type
2853: FROM mtl_system_items_b itm,
2854: bom_inventory_components c,
2855: bom_inventory_comps_interface n, -- new attributes
2856: bom_inventory_comps_interface o, -- old attributes
2857: eng_revised_items_interface ri,
3120: NVL(n.supply_locator_id, DECODE(o.supply_locator_id, NULL,
3121: c.supply_locator_id, NULL)),
3122: r.revised_item_sequence_id,
3123: itm.bom_item_type
3124: FROM mtl_system_items_b itm,
3125: bom_inventory_components c,
3126: bom_inventory_comps_interface n, -- new attributes
3127: bom_inventory_comps_interface o, -- old attributes
3128: eng_revised_items_interface ri,
3409: i.supply_subinventory,
3410: i.supply_locator_id,
3411: r.revised_item_sequence_id,
3412: itm.bom_item_type
3413: FROM mtl_system_items_b itm,
3414: bom_inventory_comps_interface i,
3415: eng_revised_items_interface ri,
3416: eng_revised_items r
3417: WHERE r.revised_item_sequence_id =
3670: SET check_atp = no
3671: WHERE revised_item_sequence_id IN (
3672: SELECT r.revised_item_sequence_id
3673: FROM eng_revised_items r,
3674: mtl_system_items_b i
3675: WHERE i.atp_components_flag = 'N'
3676: AND i.pick_components_flag = 'N'
3677: AND i.replenish_to_order_flag = 'N'
3678: AND i.wip_supply_type <> phantom
3720: UPDATE bom_inventory_components
3721: SET wip_supply_type = phantom
3722: WHERE component_sequence_id IN (
3723: SELECT c.component_sequence_id
3724: FROM mtl_system_items_b i,
3725: mtl_system_items_b ci,
3726: bom_inventory_components c,
3727: eng_revised_items r
3728: WHERE ci.bom_item_type IN (model_type, option_class_type)
3721: SET wip_supply_type = phantom
3722: WHERE component_sequence_id IN (
3723: SELECT c.component_sequence_id
3724: FROM mtl_system_items_b i,
3725: mtl_system_items_b ci,
3726: bom_inventory_components c,
3727: eng_revised_items r
3728: WHERE ci.bom_item_type IN (model_type, option_class_type)
3729: AND ci.inventory_item_id = c.component_item_id
3737: UPDATE bom_inventory_components
3738: SET optional = yes
3739: WHERE component_sequence_id IN (
3740: SELECT c.component_sequence_id
3741: FROM mtl_system_items_b i,
3742: mtl_system_items_b ci,
3743: bom_inventory_components c,
3744: eng_revised_items r
3745: WHERE ci.base_item_id IS NULL
3738: SET optional = yes
3739: WHERE component_sequence_id IN (
3740: SELECT c.component_sequence_id
3741: FROM mtl_system_items_b i,
3742: mtl_system_items_b ci,
3743: bom_inventory_components c,
3744: eng_revised_items r
3745: WHERE ci.base_item_id IS NULL
3746: AND ci.replenish_to_order_flag = 'Y'