eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MSC_CL_SCE_COLLECTION dependencies on MSC_COMPANY_SITES

Line 431: msc_company_sites mcs --bug 5097405

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
434: AND mtps.partner_type = mcsl.partner_type
435: AND mtps.sr_tp_site_id = mcsl.sr_company_site_id

Line 457: LOG_MESSAGE('No. of msc_company_sites name change records = '||a_company_site_id.COUNT);

453:
454: CLOSE updCompanyNameRecords;
455:
456:
457: LOG_MESSAGE('No. of msc_company_sites name change records = '||a_company_site_id.COUNT);
458: -- update msc_company_sites table
459: -- Perform this step only if some data is fetched
460: IF a_company_site_id.COUNT > 0 THEN
461: FOR i IN 1..a_company_site_id.COUNT LOOP

Line 458: -- update msc_company_sites table

454: CLOSE updCompanyNameRecords;
455:
456:
457: LOG_MESSAGE('No. of msc_company_sites name change records = '||a_company_site_id.COUNT);
458: -- update msc_company_sites table
459: -- Perform this step only if some data is fetched
460: IF a_company_site_id.COUNT > 0 THEN
461: FOR i IN 1..a_company_site_id.COUNT LOOP
462: BEGIN

Line 463: UPDATE msc_company_sites

459: -- Perform this step only if some data is fetched
460: IF a_company_site_id.COUNT > 0 THEN
461: FOR i IN 1..a_company_site_id.COUNT LOOP
462: BEGIN
463: UPDATE msc_company_sites
464: SET company_site_name=a_company_site_name(i)
465: WHERE company_site_id = a_company_site_id(i)
466: AND company_id = a_company_id(i);
467: EXCEPTION

Line 758: from msc_company_sites mcs;

754: and mstp.partner_type = G_SUPPLIER
755: MINUS
756: select mcs.company_id company_id,
757: mcs.company_site_name company_site_name
758: from msc_company_sites mcs;
759:
760: -- Variables to hold company_id and company_site_name
761: a_company_id number_arr;
762: a_company_site_name companySites;

Line 776: /* Populate msc_company_sites with new records.

772:
773: close newCompSites;
774:
775:
776: /* Populate msc_company_sites with new records.
777: Do this step only if some data is fetched */
778:
779:
780: if a_company_id.COUNT > 0 THEN

Line 783: INSERT INTO msc_company_sites

779:
780: if a_company_id.COUNT > 0 THEN
781: BEGIN
782: FORALL i IN 1..a_company_id.COUNT
783: INSERT INTO msc_company_sites
784: ( company_site_id,
785: company_id,
786: company_site_name,
787: creation_date,

Line 793: ( msc_company_sites_s.nextval,

789: last_update_date,
790: last_updated_by
791: )
792: values
793: ( msc_company_sites_s.nextval,
794: a_company_id(i),
795: a_company_site_name(i),
796: sysdate,
797: -1,

Line 808: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_COMPANY_SITES');

804:
805: LOG_MESSAGE('========================================');
806: FND_MESSAGE.SET_NAME('MSC', 'MSC_X_COMP_SITES_ERR');
807: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'CREATE_NEW_COMPANY_SITES');
808: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_COMPANY_SITES');
809: LOG_MESSAGE(FND_MESSAGE.GET);
810:
811: LOG_MESSAGE(SQLERRM);
812: ROLLBACK;

Line 816: msc_analyse_tables_pk.analyse_table( 'MSC_COMPANY_SITES');

812: ROLLBACK;
813: END;
814: COMMIT;
815: --Bug 5155944: Analysing the table to improve performance
816: msc_analyse_tables_pk.analyse_table( 'MSC_COMPANY_SITES');
817: END IF;
818:
819: END CREATE_NEW_COMPANY_SITES;
820:

Line 842: msc_company_sites mcs

838: mst.partner_type partner_type,
839: mcs.company_site_id
840: from msc_st_trading_partners mst,
841: msc_company_id_lid mcil,
842: msc_company_sites mcs
843: where nvl(mst.company_id, -1) = mcil.sr_company_id
844: and mst.sr_instance_id = mcil.sr_instance_id
845: and mst.partner_type = mcil.partner_type
846: and mst.sr_instance_id = v_sr_instance_id

Line 866: msc_company_sites mcs

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
869: and mtps.sr_tp_id = mcil.sr_company_id
870: and mtps.partner_type = mcil.partner_type

Line 1409: - Planning Sites from msc_st_trading_partners into msc_company_sites

1405: -- ==== COLLECT_COMPANY_SITES ====
1406: /*
1407: This procedure collects following information
1408:
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

Line 1411: - Non Planning Sites from msc_st_trading_partners into msc_company_sites

1407: This procedure collects following information
1408:
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: */

Line 1414: 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:
1418: -- Planning / Non Planning Sites from msc_st_trading_partners

Line 1537: -- Following SQL will update planning_enabled flag in msc_company_sites. This will

1533: BEGIN
1534: LOG_MESSAGE('Inside collect_company_sites');
1535:
1536: --==================================================================================
1537: -- Following SQL will update planning_enabled flag in msc_company_sites. This will
1538: -- also take care of situation where previous non planning site has become planning
1539: -- organization.
1540: --==================================================================================
1541: OPEN collCompanySites;

Line 1551: UPDATE MSC_COMPANY_SITES

1547:
1548: IF a_company_site_id.COUNT > 0 THEN
1549: BEGIN
1550: FORALL i IN 1..a_company_site_id.COUNT
1551: UPDATE MSC_COMPANY_SITES
1552: SET PLANNING_ENABLED = a_PLANNING_ENABLED_FLAG(i)
1553: WHERE COMPANY_SITE_ID = a_COMPANY_SITE_ID(i);
1554: EXCEPTION WHEN OTHERS THEN
1555: LOG_MESSAGE('Error while collecting Planning/ Non Planning Company Sites');

Line 1588: UPDATE MSC_COMPANY_SITES

1584:
1585: IF a_COMPANY_SITE_ID.COUNT > 0 THEN
1586: BEGIN
1587: FORALL i IN 1..a_COMPANY_SITE_ID.COUNT
1588: UPDATE MSC_COMPANY_SITES
1589: set LOCATION = a_LOCATION(i),
1590: LONGITUDE = a_LONGITUDE(i),
1591: LATITUDE = a_LATITUDE(i),
1592: ADDRESS1 = a_ADDRESS1(i),

Line 1642: UPDATE MSC_COMPANY_SITES

1638:
1639: IF a_COMPANY_SITE_ID.COUNT > 0 THEN
1640: BEGIN
1641: FORALL i IN 1..a_COMPANY_SITE_ID.COUNT
1642: UPDATE MSC_COMPANY_SITES
1643: set LOCATION = a_LOCATION(i),
1644: LONGITUDE = a_LONGITUDE(i),
1645: LATITUDE = a_LATITUDE(i),
1646: ADDRESS1 = a_ADDRESS1(i),

Line 1713: from msc_company_sites mcs,

1709: -- ==== Cursor for 'Organization' Maps
1710: cursor newOrgMap is
1711: select DISTINCT mtp.partner_id,
1712: mcs.company_site_id
1713: from msc_company_sites mcs,
1714: msc_company_site_id_lid mcsil,
1715: msc_trading_partners mtp
1716: where mcs.company_site_id = mcsil.company_site_id
1717: -- Process for the current instance only

Line 1749: from msc_company_sites mcs,

1745: -- ==== Cursor for TP Sites Maps.
1746: cursor newTpSIteMap is
1747: select DISTINCT mtsil.tp_site_id,
1748: mcs.company_site_id
1749: from msc_company_sites mcs,
1750: msc_company_site_id_lid mcsil,
1751: msc_tp_site_id_lid mtsil
1752: where mcs.company_site_id = mcsil.company_site_id
1753: and mcsil.sr_instance_id = p_instance_id