[Home] [Help]
273: -- Tables to get Supplier's company_site_id
274: ,msc_trading_partner_maps mtpm1
275: ,msc_company_sites mcs1
276: -- Table to get global item_id
277: , msc_system_items mi
278: , msc_items itm
279: -- Table to get order type description
280: ,fnd_lookup_values flv
281: where
292: and mcsil.company_site_id = mcs.company_site_id
293: and mcs.company_id = mc.company_id
294: -- Make sure that only OEM's PO are published
295: and mcs.company_id = G_OEM_ID
296: -- Join with msc_system_items to get Item related information
297: and ms.inventory_item_id = mi.inventory_item_id
298: and ms.organization_id = mi.organization_id
299: and ms.sr_instance_id = mi.sr_instance_id
300: and ms.plan_id = mi.plan_id
391: , msc_trading_partners mtp2
392: ,msc_company_sites mcs2
393: , msc_companies mc2
394: -- Table to get global item_id
395: ,msc_system_items mi
396: -- Table to get order type description
397: ,fnd_lookup_values flv
398: where
399: ms.sr_instance_id = p_sr_instance_id
424: and mtp2.partner_id = map2.tp_key
425: and map2.map_type = 2
426: and map2.company_key = mcs2.company_site_id
427: and mc2.company_id = mcs2.company_id
428: -- Join with msc_system_items to get Item related information
429: and ms.inventory_item_id = mi.inventory_item_id
430: and ms.organization_id = mi.organization_id
431: and ms.sr_instance_id = mi.sr_instance_id
432: and ms.plan_id = mi.plan_id
495: , msc_companies mc1
496: --========================================
497: -- Tables to get Item information
498: --========================================
499: , msc_system_items mi
500: , msc_items itm
501: --==================================
502: -- Tables to lookup type description
503: --==================================
636: , msc_companies mc1
637: --========================================
638: -- Tables to get Item information
639: --========================================
640: , msc_system_items mi
641: , msc_items itm
642: --==================================
643: -- Tables to lookup type description
644: --==================================
781: , msc_companies mc1
782: --========================================
783: -- Tables to get Item information
784: --========================================
785: , msc_system_items mi
786: , msc_items itm
787: --==================================
788: -- Tables to lookup type description
789: --==================================
929: , msc_companies mc1
930: --========================================
931: -- Tables to get Item information
932: --========================================
933: , msc_system_items mi
934: , msc_items itm
935: --==================================
936: -- Tables to lookup type description
937: --==================================
1083: , msc_companies mc1
1084: --========================================
1085: -- Tables to get Item information
1086: --========================================
1087: , msc_system_items mi
1088: , msc_items itm
1089: --==================================
1090: -- Tables to lookup type description
1091: --==================================
1245: , msc_companies mc1
1246: --========================================
1247: -- Tables to get Item information
1248: --========================================
1249: , msc_system_items mi
1250: , msc_items itm
1251: --==================================
1252: -- Tables to lookup type description
1253: --==================================
1386: FROM msc_company_site_id_lid mcsil,
1387: msc_company_sites mcs,
1388: msc_companies mc,
1389: msc_supplies ms,
1390: msc_system_items mi,
1391: msc_items itm,
1392: msc_trading_partners mtp,
1393: fnd_lookup_values flv
1394: WHERE
1475: FROM msc_company_site_id_lid mcsil,
1476: msc_company_sites mcs,
1477: msc_companies mc,
1478: msc_supplies ms,
1479: msc_system_items mi,
1480: msc_items itm,
1481: msc_trading_partners mtp,
1482: fnd_lookup_values flv
1483: WHERE
1629: , msc_companies mc1
1630: --========================================
1631: -- Tables to get Item information
1632: --========================================
1633: , msc_system_items mi
1634: , msc_items itm
1635: --==================================
1636: -- Tables to lookup type description
1637: --==================================
1781: , msc_company_sites mcs_modeled
1782: , msc_companies mc_modeled
1783: , msc_company_sites mcs
1784: , msc_companies mc
1785: , msc_system_items mi
1786: , msc_items itm
1787: , fnd_lookup_values flv
1788: where
1789: --============================================
1930: msc_trading_partners mtp2,
1931: msc_trading_partner_maps map2,
1932: msc_company_sites mcs2,
1933: msc_companies mc2,
1934: msc_system_items mi,
1935: fnd_lookup_values flv
1936: where mso.sr_instance_id = p_sr_instance_id
1937: and mso.demand_source_type = 8 --- Internal Sales order
1938: and mso.organization_id = mtp.sr_tp_id
4858: ' ,to_char(null) ' ||
4859: ' ,to_char(null) ' ||
4860: ' ,mavv.status_code '||
4861: ' ,msi.planner_code '||
4862: ' from msc_system_items msi ,'||
4863: ' msc_trading_partners mtp ,'||
4864: ' msc_company_site_id_lid mcsil ,'||
4865: ' msc_company_sites mcs ,'||
4866: ' msc_companies mc ,'||
4935: ' ,to_char(null) ' ||
4936: ' ,to_char(null) ' ||
4937: ' ,mavv.status_code '||
4938: ' ,msi.planner_code '||
4939: ' from msc_system_items msi,'||
4940: ' msc_trading_partners mtp,'||
4941: ' msc_company_site_id_lid mcsil,'||
4942: ' msc_company_sites mcs,'||
4943: ' msc_companies mc,'||
5014: ' ,to_char(mavv.req_line_number) ' ||
5015: ' ,mavv.status_code '||
5016: ' ,msi.planner_code '||
5017: ' from mrp_ap_vmi_intransits_v'||v_sr_dblink ||' mavv, '||
5018: ' msc_system_items msi,'||
5019: ' msc_trading_partners mtp,'||
5020: ' msc_company_site_id_lid mcsil,'||
5021: ' msc_company_sites mcs,'||
5022: ' msc_companies mc,'||
5091: ' ,to_char(mavv.req_line_number) ' ||
5092: ' ,mavv.status_code '||
5093: ' ,msi.planner_code '||
5094: ' from mrp_ap_vmi_intransits_v'||v_sr_dblink ||' mavv, '||
5095: ' msc_system_items msi,'||
5096: ' msc_trading_partners mtp,'||
5097: ' msc_company_site_id_lid mcsil,'||
5098: ' msc_company_sites mcs,'||
5099: ' msc_companies mc,'||
5169: ' ,to_char(null) ' ||
5170: ' ,to_char(null) ' ||
5171: ' ,mavv.status_code '||
5172: ' ,msi.planner_code '||
5173: ' from msc_system_items msi ,'||
5174: ' msc_trading_partners mtp ,'||
5175: ' msc_company_site_id_lid mcsil ,'||
5176: ' msc_company_sites mcs ,'||
5177: ' msc_companies mc ,'||
5246: ' ,to_char(null) ' ||
5247: ' ,to_char(null) ' ||
5248: ' ,mavv.status_code '||
5249: ' ,msi.planner_code '||
5250: ' from msc_system_items msi,'||
5251: ' msc_trading_partners mtp,'||
5252: ' msc_company_site_id_lid mcsil,'||
5253: ' msc_company_sites mcs,'||
5254: ' msc_companies mc,'||
5325: ' ,to_char(mavv.req_line_number) ' ||
5326: ' ,mavv.status_code '||
5327: ' ,msi.planner_code '||
5328: ' from mrp_ap_vmi_intransits_v'||v_sr_dblink ||' mavv, '||
5329: ' msc_system_items msi,'||
5330: ' msc_trading_partners mtp,'||
5331: ' msc_company_site_id_lid mcsil,'||
5332: ' msc_company_sites mcs,'||
5333: ' msc_companies mc,'||
5402: ' ,to_char(mavv.req_line_number) ' ||
5403: ' ,mavv.status_code '||
5404: ' ,msi.planner_code '||
5405: ' from mrp_ap_vmi_intransits_v'||v_sr_dblink ||' mavv, '||
5406: ' msc_system_items msi,'||
5407: ' msc_trading_partners mtp,'||
5408: ' msc_company_site_id_lid mcsil,'||
5409: ' msc_company_sites mcs,'||
5410: ' msc_companies mc,'||