APPS.MSC_CL_SCE_COLLECTION dependencies on MSC_ST_TRADING_PARTNER_SITES

Line 429: FROM msc_st_Trading_partner_sites mtps,

425: -- Cursor for changed company site names
426: CURSOR updCompanyNameRecords IS
427: SELECT mcs.company_id, mcs.company_site_id,
428: decode(mtps.partner_type,G_SUPPLIER, mtps.tp_site_code, G_CUSTOMER, mtps.LOCATION)
429: FROM msc_st_Trading_partner_sites mtps,
430: msc_company_site_id_lid mcsl,
431: msc_company_sites mcs --bug 5097405
432: WHERE mtps.sr_instance_id = mcsl.sr_instance_id
433: AND mtps.sr_instance_id = v_sr_instance_id

Line 719: -- Add Sites from msc_st_trading_partner_sites for CUSTOMERS

715: and mst.partner_type = 3
716:
717: UNION
718:
719: -- Add Sites from msc_st_trading_partner_sites for CUSTOMERS
720: -- This step is required because for Oracle ERP data there won't be
721: -- any record in msc_trading_partners for Supplier and Customer Sites.
722:
723: select mcil.company_id company_id,

Line 725: from msc_st_trading_partner_sites mstp,

721: -- any record in msc_trading_partners for Supplier and Customer Sites.
722:
723: select mcil.company_id company_id,
724: mstp.LOCATION company_site_name
725: from msc_st_trading_partner_sites mstp,
726: msc_company_id_lid mcil
727: where
728: -- Make sure that the Trading partner is defined as Company
729: mstp.sr_tp_id = mcil.sr_company_id

Line 743: from msc_st_trading_partner_sites mstp,

739:
740: -- Add sites from msc_trading_partner_sites for Suppliers.
741: SELECT mcil.company_id company_id,
742: mstp.tp_site_code company_site_name
743: from msc_st_trading_partner_sites mstp,
744: msc_company_id_lid mcil
745: where
746: -- Make sure that the Trading partner is defined as Company
747: mstp.sr_tp_id = mcil.sr_company_id

Line 864: from msc_st_trading_partner_sites mtps,

860: mtps.sr_tp_id sr_company_id,
861: mtps.sr_tp_site_id sr_company_site_id,
862: mtps.partner_type,
863: mcs.company_site_id
864: from msc_st_trading_partner_sites mtps,
865: msc_company_id_lid mcil,
866: msc_company_sites mcs
867: where mtps.sr_instance_id = mcil.sr_instance_id
868: and mtps.sr_instance_id = v_sr_instance_id

Line 1413: - Customer / Supplier non planning Sites from msc_st_trading_partner_sites

1409: - Planning Sites from msc_st_trading_partners into msc_company_sites
1410:
1411: - Non Planning Sites from msc_st_trading_partners into msc_company_sites
1412:
1413: - Customer / Supplier non planning Sites from msc_st_trading_partner_sites
1414: into msc_company_sites
1415: */
1416: PROCEDURE COLLECT_COMPANY_SITES IS
1417:

Line 1449: FROM MSC_ST_TRADING_PARTNER_SITES mstps,

1445: mstps.city,
1446: mstps.county,
1447: mstps.province,
1448: mstps.postal_code
1449: FROM MSC_ST_TRADING_PARTNER_SITES mstps,
1450: msc_company_site_id_lid mcsil
1451: WHERE mcsil.SR_COMPANY_ID = nvl(mstps.sr_tp_id, -1)
1452: AND mcsil.SR_COMPANY_SITE_ID= mstps.SR_TP_SITE_ID
1453: AND mcsil.SR_INSTANCE_ID= mstps.SR_INSTANCE_ID

Line 1462: -- for planning Organization. This information is stored in msc_st_trading_partner_sites

1458: mcsil.COMPANY_SITE_ID;
1459:
1460: --=======================================================================================
1461: -- Following cursor will be used to collect location and address information
1462: -- for planning Organization. This information is stored in msc_st_trading_partner_sites
1463: -- table.
1464: --=======================================================================================
1465: CURSOR collOrgSiteAttrib IS
1466: SELECT

Line 1481: from msc_st_trading_partner_sites mtps,

1477: mtps.city,
1478: mtps.county,
1479: mtps.province,
1480: mtps.postal_code
1481: from msc_st_trading_partner_sites mtps,
1482: msc_company_site_id_lid mcsil
1483: where nvl(mtps.company_id, -1) = mcsil.sr_company_id
1484: and mtps.sr_instance_id = mcsil.sr_instance_id
1485: and mtps.sr_instance_id = v_sr_instance_id