[Home] [Help]
1033: ln.line_id = t_line_id(j) and
1034: NVL(ln.row_status, G_PROCESS) = G_PROCESS and
1035: ln.sync_indicator = 'D' and
1036: not exists (select i.inventory_item_id
1037: from msc_items i
1038: where i.item_name = ln.item_name
1039: UNION
1040: select msi.inventory_item_id
1041: from msc_system_items msi
1904: ln.line_id = t_line_id(j) and
1905: NVL(ln.row_status, G_PROCESS) = G_PROCESS and
1906: ln.sync_indicator = 'R' and
1907: not exists ( select i.inventory_item_id
1908: from msc_items i
1909: where i.item_name = ln.item_name
1910: UNION
1911: select msi.inventory_item_id
1912: from msc_system_items msi,
2437: FORALL j in t_line_id.FIRST..t_line_id.LAST
2438: update msc_supdem_lines_interface l
2439: set l.inventory_item_id =
2440: (select i.inventory_item_id
2441: from msc_items i,
2442: msc_supdem_lines_interface ln
2443: where i.item_name = ln.item_name and
2444: ln.parent_header_id = p_header_id AND
2445: ln.line_id = t_line_id(j) AND
7768: itm.item_name,
7769: msi.planner_code
7770: from msc_item_suppliers mis,
7771: msc_system_items msi,
7772: msc_items itm,
7773: msc_items itm1,
7774: msc_trading_partner_maps map,
7775: msc_trading_partner_maps map1,
7776: msc_trading_partner_maps map2,
7769: msi.planner_code
7770: from msc_item_suppliers mis,
7771: msc_system_items msi,
7772: msc_items itm,
7773: msc_items itm1,
7774: msc_trading_partner_maps map,
7775: msc_trading_partner_maps map1,
7776: msc_trading_partner_maps map2,
7777: msc_trading_partners mtp,
7814: select mis.supplier_item_name,
7815: nvl(mis.description,itm.description),
7816: mis.uom_code
7817: from msc_item_suppliers mis,
7818: msc_items itm,
7819: msc_trading_partner_maps map,
7820: msc_trading_partner_maps map1,
7821: msc_trading_partner_maps map2,
7822: msc_trading_partners mtp,
8470: select item_name,
8471: description
8472: into l_item_name,
8473: l_desc
8474: from msc_items
8475: where inventory_item_id = t_item_id(j);
8476:
8477: t_ins_item_desc(t_insert_id.COUNT) := l_desc;
8478: t_ins_item_name(t_insert_id.COUNT) := l_item_name;
8493: l_base_item_id,
8494: l_base_item_name,
8495: l_planner_code--Bug 4424426
8496: from msc_system_items msi,
8497: msc_items itm,
8498: msc_trading_partners part,
8499: msc_trading_partner_maps map
8500: where msi.inventory_item_id = t_item_id(j) and
8501: msi.organization_id = part.sr_tp_id and
8568: into l_uom,
8569: l_base_item_id,
8570: l_base_item_name
8571: from msc_system_items msi,
8572: msc_items itm,
8573: msc_trading_partners part,
8574: msc_trading_partner_maps map
8575: where itm.inventory_item_id (+)=
8576: msi.base_item_id and
10011: UPDATE /*+ parallel(mssn,5) */
10012: msc_st_serial_numbers mssn
10013: SET mssn.inventory_item_id = (SELECT /*+ parallel(mi,5) */
10014: mi.inventory_item_id
10015: FROM msc_items mi
10016: WHERE mi.item_name = mssn.master_item_name AND
10017: mssn.master_item_name IS NOT NULL
10018:
10019: UNION ALL