[Home] [Help]
263: from
264: msc_supplies ms
265: -- Table to get org equivalent company_site_id
266: ,msc_companies mc
267: ,msc_company_sites mcs
268: ,msc_company_site_id_lid mcsil
269: -- Tables to get Supplier's company_id
270: ,msc_trading_partner_maps mtpm
271: ,msc_company_relationships mcr
271: ,msc_company_relationships mcr
272: ,msc_companies mc1
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
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
389: -- Tables to get Supplier Site
390: ,msc_trading_partner_maps map2
391: , msc_trading_partners mtp2
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
396: -- Table to get order type description
483: --========================================
484: -- Tables to get Publisher's organization_id
485: --========================================
486: , msc_company_site_id_lid mcsil
487: , msc_company_sites mcs
488: , msc_companies mc
489: --========================================
490: -- Tables to get Supplier's information
491: --========================================
490: -- Tables to get Supplier's information
491: --========================================
492: , msc_trading_partner_sites mtps
493: , msc_trading_partner_maps mtpm
494: , msc_company_sites mcs1
495: , msc_companies mc1
496: --========================================
497: -- Tables to get Item information
498: --========================================
623: --========================================
624: -- Tables to get Publisher's organization_id
625: --========================================
626: , msc_company_site_id_lid mcsil
627: , msc_company_sites mcs
628: , msc_companies mc
629: --========================================
630: -- Tables to get Supplier's information
631: --========================================
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
637: --========================================
638: -- Tables to get Item information
639: --========================================
768: --========================================
769: -- Tables to get Publisher's organization_id
770: --========================================
771: , msc_company_site_id_lid mcsil
772: , msc_company_sites mcs
773: , msc_companies mc
774: --========================================
775: -- Tables to get Supplier's information
776: --========================================
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
782: --========================================
783: -- Tables to get Item information
784: --========================================
917: --========================================
918: -- Tables to get Publisher's organization_id
919: --========================================
920: , msc_company_site_id_lid mcsil
921: , msc_company_sites mcs
922: , msc_companies mc
923: --========================================
924: -- Tables to get Supplier's information
925: --========================================
924: -- Tables to get Supplier's information
925: --========================================
926: , msc_trading_partner_sites mtps
927: , msc_trading_partner_maps mtpm
928: , msc_company_sites mcs1
929: , msc_companies mc1
930: --========================================
931: -- Tables to get Item information
932: --========================================
1069: --========================================
1070: -- Tables to get Publisher's organization_id
1071: --========================================
1072: , msc_company_site_id_lid mcsil
1073: , msc_company_sites mcs
1074: , msc_companies mc
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
1084: --========================================
1085: -- Tables to get Item information
1086: --========================================
1231: --========================================
1232: -- Tables to get Publisher's organization_id
1233: --========================================
1234: , msc_company_site_id_lid mcsil
1235: , msc_company_sites mcs
1236: , msc_companies mc
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
1246: --========================================
1247: -- Tables to get Item information
1248: --========================================
1383: mi.base_item_id BASE_ITEM_ID,
1384: itm.item_name BASE_ITEM_NAME
1385: ,mi.planner_code PLANNER_CODE --Bug 4424426
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,
1472: mi.base_item_id BASE_ITEM_ID,
1473: itm.item_name BASE_ITEM_NAME
1474: ,mi.planner_code PLANNER_CODE --Bug 4424426
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,
1616: --========================================
1617: -- Tables to get Publisher's organization_id
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
1624: -- Tables to get Customer and Customer Site information
1625: --========================================
1626: , msc_trading_partner_sites mtps
1627: , msc_trading_partner_maps mtpm
1628: , msc_company_sites mcs1
1629: , msc_companies mc1
1630: --========================================
1631: -- Tables to get Item information
1632: --========================================
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
1781: , msc_company_sites mcs_modeled
1782: , msc_companies mc_modeled
1783: , msc_company_sites mcs
1777: , msc_trading_partner_maps map2
1778: , msc_trading_partner_maps mtpm_org
1779: , msc_company_sites mcs_org
1780: , msc_companies mc_org
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
1779: , msc_company_sites mcs_org
1780: , msc_companies mc_org
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
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,
1930: msc_trading_partners mtp2,
1931: msc_trading_partner_maps map2,
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,
1935: fnd_lookup_values flv
1936: where mso.sr_instance_id = p_sr_instance_id
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 ,'||
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 '||
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,'||
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'||
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,'||
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||
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,'||
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||
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 ,'||
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 '||
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,'||
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'||
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,'||
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||
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,'||
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||