APPS.MSC_CL_PUBLISH dependencies on MSC_TRADING_PARTNER_MAPS

Line 270: ,msc_trading_partner_maps mtpm

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
272: ,msc_companies mc1
273: -- Tables to get Supplier's company_site_id
274: ,msc_trading_partner_maps mtpm1

Line 274: ,msc_trading_partner_maps mtpm1

270: ,msc_trading_partner_maps mtpm
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

Line 309: -- with msc_trading_partner_maps since some order types

305: and mtpm.map_type = 1
306: and mtpm.company_key = mcr.relationship_id
307: and mcr.object_id = mc1.company_id
308: -- Get the supplier's company_site_id. Use Outer joint
309: -- with msc_trading_partner_maps since some order types
310: -- supplier site is optional
311: and nvl(ms.supplier_site_id, -99) = mtpm1.tp_key
312: and mtpm1.map_type = 3
313: and mtpm1.company_key = mcs1.company_site_id

Line 388: , msc_trading_partner_maps map1

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
392: ,msc_company_sites mcs2

Line 390: ,msc_trading_partner_maps map2

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
392: ,msc_company_sites mcs2
393: , msc_companies mc2
394: -- Table to get global item_id

Line 493: , msc_trading_partner_maps mtpm

489: --========================================
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

Line 634: , msc_trading_partner_maps mtpm

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
637: --========================================
638: -- Tables to get Item information

Line 779: , msc_trading_partner_maps mtpm

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
782: --========================================
783: -- Tables to get Item information

Line 927: , msc_trading_partner_maps mtpm

923: --========================================
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

Line 1081: , msc_trading_partner_maps mtpm

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

Line 1243: , msc_trading_partner_maps mtpm

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

Line 1627: , msc_trading_partner_maps mtpm

1623: --========================================
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

Line 1774: , msc_trading_partner_maps mtpm

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
1778: , msc_trading_partner_maps mtpm_org

Line 1777: , msc_trading_partner_maps map2

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
1781: , msc_company_sites mcs_modeled

Line 1778: , msc_trading_partner_maps mtpm_org

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
1781: , msc_company_sites mcs_modeled
1782: , msc_companies mc_modeled

Line 1926: msc_trading_partner_maps map,

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,
1930: msc_trading_partners mtp2,

Line 1931: msc_trading_partner_maps map2,

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,
1935: fnd_lookup_values flv

Line 1982: msc_trading_partner_maps mtpm,

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
1986: and mtp.partner_type = 3

Line 4869: ' msc_trading_partner_maps mtpm ,'||

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 ,'||

Line 4873: ' msc_trading_partner_maps mtpm1 ,'||

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||
4877: ' and mtp.modeled_customer_id is not null '||

Line 4946: ' msc_trading_partner_maps mtpm,'||

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,'||

Line 4950: ' msc_trading_partner_maps mtpm1,'||

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||
4954: ' and mtp.modeled_customer_id is not null '||

Line 5025: ' msc_trading_partner_maps mtpm,'||

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'||

Line 5029: ' msc_trading_partner_maps mtpm1'||

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'||
5033: ' and mtp.modeled_customer_site_id is not null'||

Line 5102: ' msc_trading_partner_maps mtpm,'||

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'||

Line 5106: ' msc_trading_partner_maps mtpm1'||

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'||
5110: ' and mtp.modeled_customer_site_id is not null'||

Line 5180: ' msc_trading_partner_maps mtpm ,'||

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 ,'||

Line 5184: ' msc_trading_partner_maps mtpm1 ,'||

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||
5188: ' and mtp.modeled_customer_id is not null '||

Line 5257: ' msc_trading_partner_maps mtpm,'||

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,'||

Line 5261: ' msc_trading_partner_maps mtpm1,'||

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||
5265: ' and mtp.modeled_customer_id is not null '||

Line 5336: ' msc_trading_partner_maps mtpm,'||

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'||

Line 5340: ' msc_trading_partner_maps mtpm1'||

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'||
5344: ' and mtp.modeled_customer_site_id is not null'||

Line 5413: ' msc_trading_partner_maps mtpm,'||

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'||

Line 5417: ' msc_trading_partner_maps mtpm1'||

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'||
5421: ' and mtp.modeled_customer_site_id is not null'||