[Home] [Help]
380: , SYS_YES
381: ,mi.planner_code --Bug 4424426
382: from
383: msc_supplies ms
384: , msc_trading_partners mtp
385: -- Table to get customer/customer site
386: ,msc_companies mc
387: ,msc_company_sites mcs
388: , msc_trading_partner_maps map1
387: ,msc_company_sites mcs
388: , msc_trading_partner_maps map1
389: -- Tables to get Supplier Site
390: ,msc_trading_partner_maps map2
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
628: , msc_companies mc
629: --========================================
630: -- Tables to get Supplier's information
631: --========================================
632: , msc_trading_partners mtp
633: , msc_trading_partner_sites mtps
634: , msc_trading_partner_maps mtpm
635: , msc_company_sites mcs1
636: , msc_companies mc1
773: , msc_companies mc
774: --========================================
775: -- Tables to get Supplier's information
776: --========================================
777: , msc_trading_partners mtp
778: , msc_trading_partner_sites mtps
779: , msc_trading_partner_maps mtpm
780: , msc_company_sites mcs1
781: , msc_companies mc1
1075:
1076: --========================================
1077: -- Tables to get Supplier's information
1078: --========================================
1079: , msc_trading_partners mtp /* added sbala */
1080: , msc_trading_partner_sites mtps
1081: , msc_trading_partner_maps mtpm
1082: , msc_company_sites mcs1
1083: , msc_companies mc1
1141: -- Local View to get Net change information.
1142: --==========================================
1143: select 1
1144: from msc_supplies ms1,
1145: msc_trading_partners mtp2
1146: where plan_id = G_PLAN_ID /* Changes for modeled suppliers sbala */
1147: and ms1.sr_instance_id = p_sr_instance_id
1148: --==============================================
1149: -- Joins for getting net change Item information
1237:
1238: --========================================
1239: -- Tables to get Customer's information
1240: --========================================
1241: , msc_trading_partners mtp /* added sbala */
1242: , msc_trading_partner_sites mtps
1243: , msc_trading_partner_maps mtpm
1244: , msc_company_sites mcs1
1245: , msc_companies mc1
1303: -- Local View to get Net change information.
1304: --==========================================
1305: (select 1
1306: from msc_supplies ms1,
1307: msc_trading_partners mtp2
1308: where plan_id = G_PLAN_ID /* Changes for modeled customers sbala */
1309: and ms1.sr_instance_id = p_sr_instance_id
1310: and ms1.order_type = G_MRP_ONHAND
1311: and ms1.organization_id = mtp2.sr_tp_id
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
1395: ms.plan_id = G_PLAN_ID
1396: and ms.sr_instance_id = p_sr_instance_id
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
1484: --==============================================
1485: -- Joins for getting net change Item information
1618: --========================================
1619: , msc_company_site_id_lid mcsil
1620: , msc_company_sites mcs
1621: , msc_companies mc
1622: , msc_trading_partners mtp
1623: --========================================
1624: -- Tables to get Customer and Customer Site information
1625: --========================================
1626: , msc_trading_partner_sites mtps
1769: mc_modeled.company_name supplier_name,
1770: mcs_modeled.company_site_name supplier_site_name
1771: ,mi.planner_code PLANNER_CODE --Bug 4424426
1772: from msc_sales_orders mso
1773: , msc_trading_partners mtp
1774: , msc_trading_partner_maps mtpm
1775: , msc_supplies ms
1776: , msc_trading_partners mtp2
1777: , msc_trading_partner_maps map2
1772: from msc_sales_orders mso
1773: , msc_trading_partners mtp
1774: , msc_trading_partner_maps mtpm
1775: , msc_supplies ms
1776: , msc_trading_partners mtp2
1777: , msc_trading_partner_maps map2
1778: , msc_trading_partner_maps mtpm_org
1779: , msc_company_sites mcs_org
1780: , msc_companies mc_org
1921: mc.company_name SUPPLIER_NAME,
1922: mcs.company_site_name SUPPLIER_SITE_NAME
1923: ,mi.planner_code PLANNER_CODE --Bug 4424426
1924: from msc_sales_orders mso,
1925: msc_trading_partners mtp,
1926: msc_trading_partner_maps map,
1927: msc_company_sites mcs,
1928: msc_companies mc,
1929: msc_supplies ms,
1926: msc_trading_partner_maps map,
1927: msc_company_sites mcs,
1928: msc_companies mc,
1929: msc_supplies ms,
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,
1977: ;
1978:
1979: cursor org IS
1980: select mtpm.company_key org_id
1981: from msc_trading_partners mtp,
1982: msc_trading_partner_maps mtpm,
1983: msc_instance_orgs mio,
1984: msc_coll_parameters mcp
1985: where mtp.sr_instance_id = p_sr_instance_id
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 ,'||
4867: ' msc_sup_dem_entries asn ,'||
4868: ' msc_company_relationships mcr ,'||
4869: ' msc_trading_partner_maps mtpm ,'||
4870: ' msc_companies mc1 ,'||
4871: ' msc_company_sites mcs1 ,'||
4872: ' msc_trading_partners mtp1 ,'||
4873: ' msc_trading_partner_maps mtpm1 ,'||
4874: ' mrp_ap_vmi_intransits_v'||v_sr_dblink ||' mavv '||
4875: ' where mtp.partner_type = 3 '||
4876: ' and mtp.sr_instance_id = '||p_sr_instance_id||
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,'||
4944: ' msc_sup_dem_entries asn,'||
4945: ' msc_company_relationships mcr,'||
4946: ' msc_trading_partner_maps mtpm,'||
4947: ' msc_companies mc1,'||
4948: ' msc_company_sites mcs1,'||
4949: ' msc_trading_partners mtp1 ,'||
4950: ' msc_trading_partner_maps mtpm1,'||
4951: ' mrp_ap_vmi_intransits_v'||v_sr_dblink ||' mavv'||
4952: ' where mtp.partner_type = 3'||
4953: ' and mtp.sr_instance_id = '||p_sr_instance_id||
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,'||
5023: ' msc_sup_dem_entries asn,'||
5024: ' msc_company_relationships mcr,'||
5025: ' msc_trading_partner_maps mtpm,'||
5026: ' msc_companies mc1,'||
5027: ' msc_company_sites mcs1,'||
5028: ' msc_trading_partners mtp1 ,'||
5029: ' msc_trading_partner_maps mtpm1'||
5030: ' where mtp.partner_type = 3'||
5031: ' and mtp.sr_instance_id = '||p_sr_instance_id||
5032: ' and mtp.modeled_customer_id is not null'||
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,'||
5100: ' msc_sup_dem_entries asn,'||
5101: ' msc_company_relationships mcr,'||
5102: ' msc_trading_partner_maps mtpm,'||
5103: ' msc_companies mc1,'||
5104: ' msc_company_sites mcs1,'||
5105: ' msc_trading_partners mtp1 ,'||
5106: ' msc_trading_partner_maps mtpm1'||
5107: ' where mtp.partner_type = 3'||
5108: ' and mtp.sr_instance_id = '||p_sr_instance_id||
5109: ' and mtp.modeled_customer_id is not 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 ,'||
5178: ' msc_sup_dem_entries asn ,'||
5179: ' msc_company_relationships mcr ,'||
5180: ' msc_trading_partner_maps mtpm ,'||
5181: ' msc_companies mc1 ,'||
5182: ' msc_company_sites mcs1 ,'||
5183: ' msc_trading_partners mtp1 ,'||
5184: ' msc_trading_partner_maps mtpm1 ,'||
5185: ' mrp_ap_vmi_intransits_v'||v_sr_dblink ||' mavv '||
5186: ' where mtp.partner_type = 3 '||
5187: ' and mtp.sr_instance_id = '||p_sr_instance_id||
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,'||
5255: ' msc_sup_dem_entries asn,'||
5256: ' msc_company_relationships mcr,'||
5257: ' msc_trading_partner_maps mtpm,'||
5258: ' msc_companies mc1,'||
5259: ' msc_company_sites mcs1,'||
5260: ' msc_trading_partners mtp1 ,'||
5261: ' msc_trading_partner_maps mtpm1,'||
5262: ' mrp_ap_vmi_intransits_v'||v_sr_dblink ||' mavv'||
5263: ' where mtp.partner_type = 3'||
5264: ' and mtp.sr_instance_id = '||p_sr_instance_id||
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,'||
5334: ' msc_sup_dem_entries asn,'||
5335: ' msc_company_relationships mcr,'||
5336: ' msc_trading_partner_maps mtpm,'||
5337: ' msc_companies mc1,'||
5338: ' msc_company_sites mcs1,'||
5339: ' msc_trading_partners mtp1 ,'||
5340: ' msc_trading_partner_maps mtpm1'||
5341: ' where mtp.partner_type = 3'||
5342: ' and mtp.sr_instance_id = '||p_sr_instance_id||
5343: ' and mtp.modeled_customer_id is not null'||
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,'||
5411: ' msc_sup_dem_entries asn,'||
5412: ' msc_company_relationships mcr,'||
5413: ' msc_trading_partner_maps mtpm,'||
5414: ' msc_companies mc1,'||
5415: ' msc_company_sites mcs1,'||
5416: ' msc_trading_partners mtp1 ,'||
5417: ' msc_trading_partner_maps mtpm1'||
5418: ' where mtp.partner_type = 3'||
5419: ' and mtp.sr_instance_id = '||p_sr_instance_id||
5420: ' and mtp.modeled_customer_id is not null'||