[Home] [Help]
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
1042: where msi.item_name = NVL(ln.owner_item_name,
1043: NVL(ln.customer_item_name,
1044: ln.supplier_item_name)) and
1045: msi.plan_id = -1
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,
1913: msc_trading_partners part,
1914: msc_trading_partner_maps map,
1915: msc_company_sites cs,
1916: msc_companies c
2029: where ln.parent_header_id = p_header_id and
2030: ln.line_id = t_line_id(j) and
2031: NVL(ln.row_status, G_PROCESS) = G_PROCESS and
2032: not exists ( select msi.inventory_item_id
2033: from msc_system_items msi,
2034: msc_trading_partners part,
2035: msc_trading_partner_maps map,
2036: msc_company_sites cs,
2037: msc_companies c
2053: where c.company_id <> 1 and G_CONS_ADVICE <> t_order_type(j) and
2054: UPPER(c.company_name) = upper(ln.publisher_company)
2055: /* For Consumption Advice, Item should be valid in the Org modelled as the customer (publisher) */
2056: union select 1
2057: from msc_system_items msi,
2058: msc_trading_partners part,
2059: msc_trading_partner_maps map,
2060: msc_company_sites cs,
2061: msc_companies c
2445: ln.line_id = t_line_id(j) AND
2446: NVL(ln.row_status, G_PROCESS) = G_SUCCESS
2447: UNION
2448: select msi.inventory_item_id
2449: from msc_system_items msi,
2450: msc_trading_partners part,
2451: msc_trading_partner_maps map,
2452: msc_company_sites cs,
2453: msc_companies c,
7767: msi.base_item_id,
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,
8492: l_uom,
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
8567: itm.item_name
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 (+)=
8617: msi.uom_code
8618: into l_item_name,
8619: l_desc,
8620: l_uom
8621: from msc_system_items msi,
8622: msc_trading_partners part,
8623: msc_trading_partner_maps map
8624: where msi.plan_id = -1 and
8625: msi.inventory_item_id = t_item_id(j) and
8678: msi.uom_code
8679: into l_item_name,
8680: l_desc,
8681: l_uom
8682: from msc_system_items msi,
8683: msc_trading_partners part,
8684: msc_trading_partner_maps map
8685: where msi.plan_id = -1 and
8686: msi.inventory_item_id = t_item_id(j) and
10017: mssn.master_item_name IS NOT NULL
10018:
10019: UNION ALL
10020: SELECT msi.inventory_item_id
10021: FROM msc_system_items msi,
10022: msc_trading_partners mtp,
10023: msc_trading_partner_maps mtpm,
10024: msc_company_sites mcs,
10025: msc_companies mc
10134: WHERE mssn.parent_header_id = p_header_id AND
10135: mssn.line_id = t_line_id(j) AND
10136: NVL(mssn.row_status, G_PROCESS) = G_PROCESS AND
10137: NOT EXISTS (SELECT msi.serial_number_control_code
10138: FROM msc_system_items msi,
10139: msc_trading_partners mtp,
10140: msc_trading_partner_maps mtpm
10141: WHERE msi.plan_id = -1 AND
10142: msi.inventory_item_id = mssn.inventory_item_id AND