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 348: msc_company_sites mcs --bug 5097405

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

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

370:
371: CLOSE updCompanyNameRecords;
372:
373:
374: LOG_MESSAGE('No. of msc_company_sites name change records = '||a_company_site_id.COUNT);
375: -- update msc_company_sites table
376: -- Perform this step only if some data is fetched
377: IF a_company_site_id.COUNT > 0 THEN
378: FOR i IN 1..a_company_site_id.COUNT LOOP

Line 375: -- update msc_company_sites table

371: CLOSE updCompanyNameRecords;
372:
373:
374: LOG_MESSAGE('No. of msc_company_sites name change records = '||a_company_site_id.COUNT);
375: -- update msc_company_sites table
376: -- Perform this step only if some data is fetched
377: IF a_company_site_id.COUNT > 0 THEN
378: FOR i IN 1..a_company_site_id.COUNT LOOP
379: BEGIN

Line 380: UPDATE msc_company_sites

376: -- Perform this step only if some data is fetched
377: IF a_company_site_id.COUNT > 0 THEN
378: FOR i IN 1..a_company_site_id.COUNT LOOP
379: BEGIN
380: UPDATE msc_company_sites
381: SET company_site_name=a_company_site_name(i)
382: WHERE company_site_id = a_company_site_id(i)
383: AND company_id = a_company_id(i);
384: EXCEPTION

Line 675: from msc_company_sites mcs;

671: and mstp.partner_type = G_SUPPLIER
672: MINUS
673: select mcs.company_id company_id,
674: mcs.company_site_name company_site_name
675: from msc_company_sites mcs;
676:
677: -- Variables to hold company_id and company_site_name
678: a_company_id number_arr;
679: a_company_site_name companySites;

Line 693: /* Populate msc_company_sites with new records.

689:
690: close newCompSites;
691:
692:
693: /* Populate msc_company_sites with new records.
694: Do this step only if some data is fetched */
695:
696:
697: if a_company_id.COUNT > 0 THEN

Line 700: INSERT INTO msc_company_sites

696:
697: if a_company_id.COUNT > 0 THEN
698: BEGIN
699: FORALL i IN 1..a_company_id.COUNT
700: INSERT INTO msc_company_sites
701: ( company_site_id,
702: company_id,
703: company_site_name,
704: creation_date,

Line 710: ( msc_company_sites_s.nextval,

706: last_update_date,
707: last_updated_by
708: )
709: values
710: ( msc_company_sites_s.nextval,
711: a_company_id(i),
712: a_company_site_name(i),
713: sysdate,
714: -1,

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

721:
722: LOG_MESSAGE('========================================');
723: FND_MESSAGE.SET_NAME('MSC', 'MSC_X_COMP_SITES_ERR');
724: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'CREATE_NEW_COMPANY_SITES');
725: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_COMPANY_SITES');
726: LOG_MESSAGE(FND_MESSAGE.GET);
727:
728: LOG_MESSAGE(SQLERRM);
729: ROLLBACK;

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

729: ROLLBACK;
730: END;
731: COMMIT;
732: --Bug 5155944: Analysing the table to improve performance
733: msc_analyse_tables_pk.analyse_table( 'MSC_COMPANY_SITES');
734: END IF;
735:
736: END CREATE_NEW_COMPANY_SITES;
737:

Line 759: msc_company_sites mcs

755: mst.partner_type partner_type,
756: mcs.company_site_id
757: from msc_st_trading_partners mst,
758: msc_company_id_lid mcil,
759: msc_company_sites mcs
760: where nvl(mst.company_id, -1) = mcil.sr_company_id
761: and mst.sr_instance_id = mcil.sr_instance_id
762: and mst.partner_type = mcil.partner_type
763: and mst.sr_instance_id = v_sr_instance_id

Line 783: msc_company_sites mcs

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

Line 1326: - Planning Sites from msc_st_trading_partners into msc_company_sites

1322: -- ==== COLLECT_COMPANY_SITES ====
1323: /*
1324: This procedure collects following information
1325:
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

Line 1328: - Non Planning Sites from msc_st_trading_partners into msc_company_sites

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

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

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

1450: BEGIN
1451: LOG_MESSAGE('Inside collect_company_sites');
1452:
1453: --==================================================================================
1454: -- Following SQL will update planning_enabled flag in msc_company_sites. This will
1455: -- also take care of situation where previous non planning site has become planning
1456: -- organization.
1457: --==================================================================================
1458: OPEN collCompanySites;

Line 1468: UPDATE MSC_COMPANY_SITES

1464:
1465: IF a_company_site_id.COUNT > 0 THEN
1466: BEGIN
1467: FORALL i IN 1..a_company_site_id.COUNT
1468: UPDATE MSC_COMPANY_SITES
1469: SET PLANNING_ENABLED = a_PLANNING_ENABLED_FLAG(i)
1470: WHERE COMPANY_SITE_ID = a_COMPANY_SITE_ID(i);
1471: EXCEPTION WHEN OTHERS THEN
1472: LOG_MESSAGE('Error while collecting Planning/ Non Planning Company Sites');

Line 1505: UPDATE MSC_COMPANY_SITES

1501:
1502: IF a_COMPANY_SITE_ID.COUNT > 0 THEN
1503: BEGIN
1504: FORALL i IN 1..a_COMPANY_SITE_ID.COUNT
1505: UPDATE MSC_COMPANY_SITES
1506: set LOCATION = a_LOCATION(i),
1507: LONGITUDE = a_LONGITUDE(i),
1508: LATITUDE = a_LATITUDE(i),
1509: ADDRESS1 = a_ADDRESS1(i),

Line 1559: UPDATE MSC_COMPANY_SITES

1555:
1556: IF a_COMPANY_SITE_ID.COUNT > 0 THEN
1557: BEGIN
1558: FORALL i IN 1..a_COMPANY_SITE_ID.COUNT
1559: UPDATE MSC_COMPANY_SITES
1560: set LOCATION = a_LOCATION(i),
1561: LONGITUDE = a_LONGITUDE(i),
1562: LATITUDE = a_LATITUDE(i),
1563: ADDRESS1 = a_ADDRESS1(i),

Line 1630: from msc_company_sites mcs,

1626: -- ==== Cursor for 'Organization' Maps
1627: cursor newOrgMap is
1628: select DISTINCT mtp.partner_id,
1629: mcs.company_site_id
1630: from msc_company_sites mcs,
1631: msc_company_site_id_lid mcsil,
1632: msc_trading_partners mtp
1633: where mcs.company_site_id = mcsil.company_site_id
1634: -- Process for the current instance only

Line 1666: from msc_company_sites mcs,

1662: -- ==== Cursor for TP Sites Maps.
1663: cursor newTpSIteMap is
1664: select DISTINCT mtsil.tp_site_id,
1665: mcs.company_site_id
1666: from msc_company_sites mcs,
1667: msc_company_site_id_lid mcsil,
1668: msc_tp_site_id_lid mtsil
1669: where mcs.company_site_id = mcsil.company_site_id
1670: and mcsil.sr_instance_id = p_instance_id