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_ST_TRADING_PARTNERS

Line 7: from msc_st_trading_partners mst

3:
4:
5: CURSOR newCompCursor(p_sr_instance_id NUMBER) IS
6: SELECT mst.company_name
7: from msc_st_trading_partners mst
8: where sr_instance_id = p_sr_instance_id
9: and company_name is not null
10: MINUS
11: SELECT mc.company_name

Line 368: FROM msc_st_trading_partners mtps,

364:
365: -- Cursor for changed company names
366: CURSOR updateCompanyNames IS
367: SELECT mc.company_id, mtps.company_name
368: FROM msc_st_trading_partners mtps,
369: msc_company_id_lid mcil,
370: msc_companies mc
371: WHERE mtps.sr_instance_id = v_sr_instance_id
372: AND mcil.sr_instance_id = mtps.sr_instance_id

Line 550: from msc_st_trading_partners mst,

546: decode(mst.partner_type, G_SUPPLIER, G_CUSTOMER,
547: G_CUSTOMER, G_SUPPLIER,
548: mst.partner_type) partner_type,
549: mc.company_id company_id
550: from msc_st_trading_partners mst,
551: msc_companies mc
552: where nvl(mst.company_name, v_my_company) = mc.company_name
553: and mst.sr_instance_id = v_sr_instance_id
554: MINUS

Line 629: from msc_st_trading_partners mst,

625: CURSOR newCompRelCursor IS
626: select mc1.company_id subject_id,
627: mc2.company_id object_id,
628: mst.partner_type relationship_type
629: from msc_st_trading_partners mst,
630: msc_companies mc1,
631: msc_companies mc2
632: where nvl(mst.company_name, v_my_company) = mc2.company_name
633: and nvl(mst.partner_name, v_my_company) = mc1.company_name

Line 711: from msc_st_trading_partners mst,

707: -- Get the Planning and non planning Sites
708: CURSOR newCompSites IS
709: Select mc.company_id company_id,
710: mst.organization_code company_site_name
711: from msc_st_trading_partners mst,
712: msc_companies mc
713: where nvl(mst.company_name, v_my_company) = mc.company_name
714: and mst.sr_instance_id = v_sr_instance_id
715: and mst.partner_type = 3

Line 840: from msc_st_trading_partners mst,

836: nvl(mst.company_id, -1) sr_company_id,
837: mst.sr_tp_id sr_company_site_id,
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

Line 914: from msc_st_trading_partners

910: nvl(company_id, -1) sr_tp_id,
911: partner_name company_name,
912: decode(partner_type,G_SUPPLIER, G_CUSTOMER, G_CUSTOMER, G_SUPPLIER) partner_type,
913: nvl(company_name, p_my_company) partner_name
914: from msc_st_trading_partners
915: where sr_instance_id = p_instance_id
916: and partner_type in (G_SUPPLIER, G_CUSTOMER)
917: MINUS
918: select

Line 925: from msc_st_trading_partners

921: sr_tp_id,
922: nvl(company_name, p_my_company) company_name,
923: partner_type,
924: partner_name
925: from msc_st_trading_partners
926: where sr_instance_id = p_instance_id
927: and partner_type in (G_SUPPLIER, G_CUSTOMER);
928:
929: a_sr_tp_id number_arr;

Line 1016: from msc_st_trading_partners mstp

1012: IF (G_MSC_CONFIGURATION = G_CONF_APS) THEN
1013: BEGIN
1014: select count(*)
1015: into c_non_my_company
1016: from msc_st_trading_partners mstp
1017: where nvl(mstp.company_name, p_my_company) <> p_my_company
1018: and mstp.sr_instance_id = p_instance_id;
1019:
1020: IF (c_non_my_company > 0) THEN

Line 1025: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ST_TRADING_PARTNERS');

1021:
1022: LOG_MESSAGE('========================================');
1023: FND_MESSAGE.SET_NAME('MSC', 'MSC_X_MULTICOMP_DATA_ERR');
1024: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'CLEANSE_DATA_FOR_SCE');
1025: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ST_TRADING_PARTNERS');
1026: LOG_MESSAGE(FND_MESSAGE.GET);
1027:
1028:
1029: RETURN FALSE;

Line 1038: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ST_TRADING_PARTNERS');

1034: LOG_MESSAGE('========================================');
1035:
1036: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1037: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'CLEANSE_DATA_FOR_SCE');
1038: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ST_TRADING_PARTNERS');
1039: LOG_MESSAGE(FND_MESSAGE.GET);
1040:
1041:
1042: FND_MESSAGE.SET_NAME('MSC', 'MSC_X_MULTICOMP_SQL_ERR');

Line 1235: INSERT INTO MSC_ST_TRADING_PARTNERS

1231: IF a_sr_instance_id.COUNT > 0 THEN
1232: BEGIN
1233:
1234: FORALL i IN 1..a_sr_instance_id.COUNT
1235: INSERT INTO MSC_ST_TRADING_PARTNERS
1236: ( SR_INSTANCE_ID,
1237: COMPANY_ID,
1238: COMPANY_NAME,
1239: SR_TP_ID,

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

1414: into msc_company_sites
1415: */
1416: PROCEDURE COLLECT_COMPANY_SITES IS
1417:
1418: -- Planning / Non Planning Sites from msc_st_trading_partners
1419: CURSOR collCompanySites IS
1420: SELECT
1421: mcsil.COMPANY_SITE_ID,
1422: nvl(mtp.PLANNING_ENABLED_FLAG, 'Y')

Line 1423: from msc_st_trading_partners mtp,

1419: CURSOR collCompanySites IS
1420: SELECT
1421: mcsil.COMPANY_SITE_ID,
1422: nvl(mtp.PLANNING_ENABLED_FLAG, 'Y')
1423: from msc_st_trading_partners mtp,
1424: msc_company_site_id_lid mcsil
1425: where nvl(mtp.company_id, -1) = mcsil.sr_company_id
1426: and mtp.sr_instance_id = mcsil.sr_instance_id
1427: and mtp.sr_instance_id = v_sr_instance_id