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 467: from msc_st_trading_partners mst,

463: decode(mst.partner_type, G_SUPPLIER, G_CUSTOMER,
464: G_CUSTOMER, G_SUPPLIER,
465: mst.partner_type) partner_type,
466: mc.company_id company_id
467: from msc_st_trading_partners mst,
468: msc_companies mc
469: where nvl(mst.company_name, v_my_company) = mc.company_name
470: and mst.sr_instance_id = v_sr_instance_id
471: MINUS

Line 546: from msc_st_trading_partners mst,

542: CURSOR newCompRelCursor IS
543: select mc1.company_id subject_id,
544: mc2.company_id object_id,
545: mst.partner_type relationship_type
546: from msc_st_trading_partners mst,
547: msc_companies mc1,
548: msc_companies mc2
549: where nvl(mst.company_name, v_my_company) = mc2.company_name
550: and nvl(mst.partner_name, v_my_company) = mc1.company_name

Line 628: from msc_st_trading_partners mst,

624: -- Get the Planning and non planning Sites
625: CURSOR newCompSites IS
626: Select mc.company_id company_id,
627: mst.organization_code company_site_name
628: from msc_st_trading_partners mst,
629: msc_companies mc
630: where nvl(mst.company_name, v_my_company) = mc.company_name
631: and mst.sr_instance_id = v_sr_instance_id
632: and mst.partner_type = 3

Line 757: from msc_st_trading_partners mst,

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

Line 831: from msc_st_trading_partners

827: nvl(company_id, -1) sr_tp_id,
828: partner_name company_name,
829: decode(partner_type,G_SUPPLIER, G_CUSTOMER, G_CUSTOMER, G_SUPPLIER) partner_type,
830: nvl(company_name, p_my_company) partner_name
831: from msc_st_trading_partners
832: where sr_instance_id = p_instance_id
833: and partner_type in (G_SUPPLIER, G_CUSTOMER)
834: MINUS
835: select

Line 842: from msc_st_trading_partners

838: sr_tp_id,
839: nvl(company_name, p_my_company) company_name,
840: partner_type,
841: partner_name
842: from msc_st_trading_partners
843: where sr_instance_id = p_instance_id
844: and partner_type in (G_SUPPLIER, G_CUSTOMER);
845:
846: a_sr_tp_id number_arr;

Line 933: from msc_st_trading_partners mstp

929: IF (G_MSC_CONFIGURATION = G_CONF_APS) THEN
930: BEGIN
931: select count(*)
932: into c_non_my_company
933: from msc_st_trading_partners mstp
934: where nvl(mstp.company_name, p_my_company) <> p_my_company
935: and mstp.sr_instance_id = p_instance_id;
936:
937: IF (c_non_my_company > 0) THEN

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

938:
939: LOG_MESSAGE('========================================');
940: FND_MESSAGE.SET_NAME('MSC', 'MSC_X_MULTICOMP_DATA_ERR');
941: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'CLEANSE_DATA_FOR_SCE');
942: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ST_TRADING_PARTNERS');
943: LOG_MESSAGE(FND_MESSAGE.GET);
944:
945:
946: RETURN FALSE;

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

951: LOG_MESSAGE('========================================');
952:
953: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
954: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'CLEANSE_DATA_FOR_SCE');
955: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ST_TRADING_PARTNERS');
956: LOG_MESSAGE(FND_MESSAGE.GET);
957:
958:
959: FND_MESSAGE.SET_NAME('MSC', 'MSC_X_MULTICOMP_SQL_ERR');

Line 1152: INSERT INTO MSC_ST_TRADING_PARTNERS

1148: IF a_sr_instance_id.COUNT > 0 THEN
1149: BEGIN
1150:
1151: FORALL i IN 1..a_sr_instance_id.COUNT
1152: INSERT INTO MSC_ST_TRADING_PARTNERS
1153: ( SR_INSTANCE_ID,
1154: COMPANY_ID,
1155: COMPANY_NAME,
1156: SR_TP_ID,

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

1331: into msc_company_sites
1332: */
1333: PROCEDURE COLLECT_COMPANY_SITES IS
1334:
1335: -- Planning / Non Planning Sites from msc_st_trading_partners
1336: CURSOR collCompanySites IS
1337: SELECT
1338: mcsil.COMPANY_SITE_ID,
1339: nvl(mtp.PLANNING_ENABLED_FLAG, 'Y')

Line 1340: from msc_st_trading_partners mtp,

1336: CURSOR collCompanySites IS
1337: SELECT
1338: mcsil.COMPANY_SITE_ID,
1339: nvl(mtp.PLANNING_ENABLED_FLAG, 'Y')
1340: from msc_st_trading_partners mtp,
1341: msc_company_site_id_lid mcsil
1342: where nvl(mtp.company_id, -1) = mcsil.sr_company_id
1343: and mtp.sr_instance_id = mcsil.sr_instance_id
1344: and mtp.sr_instance_id = v_sr_instance_id