APPS.MSC_CL_SCE_COLLECTION dependencies on MSC_ST_TRADING_PARTNER_SITES

Line 346: FROM msc_st_Trading_partner_sites mtps,

342: -- Cursor for changed company site names
343: CURSOR updCompanyNameRecords IS
344: SELECT mcs.company_id, mcs.company_site_id,
345: decode(mtps.partner_type,G_SUPPLIER, mtps.tp_site_code, G_CUSTOMER, mtps.LOCATION)
346: FROM msc_st_Trading_partner_sites mtps,
347: msc_company_site_id_lid mcsl,
348: msc_company_sites mcs --bug 5097405
349: WHERE mtps.sr_instance_id = mcsl.sr_instance_id
350: AND mtps.sr_instance_id = v_sr_instance_id

Line 636: -- Add Sites from msc_st_trading_partner_sites for CUSTOMERS

632: and mst.partner_type = 3
633:
634: UNION
635:
636: -- Add Sites from msc_st_trading_partner_sites for CUSTOMERS
637: -- This step is required because for Oracle ERP data there won't be
638: -- any record in msc_trading_partners for Supplier and Customer Sites.
639:
640: select mcil.company_id company_id,

Line 642: from msc_st_trading_partner_sites mstp,

638: -- any record in msc_trading_partners for Supplier and Customer Sites.
639:
640: select mcil.company_id company_id,
641: mstp.LOCATION company_site_name
642: from msc_st_trading_partner_sites mstp,
643: msc_company_id_lid mcil
644: where
645: -- Make sure that the Trading partner is defined as Company
646: mstp.sr_tp_id = mcil.sr_company_id

Line 660: from msc_st_trading_partner_sites mstp,

656:
657: -- Add sites from msc_trading_partner_sites for Suppliers.
658: SELECT mcil.company_id company_id,
659: mstp.tp_site_code company_site_name
660: from msc_st_trading_partner_sites mstp,
661: msc_company_id_lid mcil
662: where
663: -- Make sure that the Trading partner is defined as Company
664: mstp.sr_tp_id = mcil.sr_company_id

Line 781: from msc_st_trading_partner_sites mtps,

777: mtps.sr_tp_id sr_company_id,
778: mtps.sr_tp_site_id sr_company_site_id,
779: mtps.partner_type,
780: mcs.company_site_id
781: from msc_st_trading_partner_sites mtps,
782: msc_company_id_lid mcil,
783: msc_company_sites mcs
784: where mtps.sr_instance_id = mcil.sr_instance_id
785: and mtps.sr_instance_id = v_sr_instance_id

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

1326: - Planning Sites from msc_st_trading_partners into msc_company_sites
1327:
1328: - Non Planning Sites from msc_st_trading_partners into msc_company_sites
1329:
1330: - Customer / Supplier non planning Sites from msc_st_trading_partner_sites
1331: into msc_company_sites
1332: */
1333: PROCEDURE COLLECT_COMPANY_SITES IS
1334:

Line 1366: FROM MSC_ST_TRADING_PARTNER_SITES mstps,

1362: mstps.city,
1363: mstps.county,
1364: mstps.province,
1365: mstps.postal_code
1366: FROM MSC_ST_TRADING_PARTNER_SITES mstps,
1367: msc_company_site_id_lid mcsil
1368: WHERE mcsil.SR_COMPANY_ID = nvl(mstps.sr_tp_id, -1)
1369: AND mcsil.SR_COMPANY_SITE_ID= mstps.SR_TP_SITE_ID
1370: AND mcsil.SR_INSTANCE_ID= mstps.SR_INSTANCE_ID

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

1375: mcsil.COMPANY_SITE_ID;
1376:
1377: --=======================================================================================
1378: -- Following cursor will be used to collect location and address information
1379: -- for planning Organization. This information is stored in msc_st_trading_partner_sites
1380: -- table.
1381: --=======================================================================================
1382: CURSOR collOrgSiteAttrib IS
1383: SELECT

Line 1398: from msc_st_trading_partner_sites mtps,

1394: mtps.city,
1395: mtps.county,
1396: mtps.province,
1397: mtps.postal_code
1398: from msc_st_trading_partner_sites mtps,
1399: msc_company_site_id_lid mcsil
1400: where nvl(mtps.company_id, -1) = mcsil.sr_company_id
1401: and mtps.sr_instance_id = mcsil.sr_instance_id
1402: and mtps.sr_instance_id = v_sr_instance_id