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_SETUP_ODS_LOAD dependencies on MSC_TRADING_PARTNER_SITES

Line 2602: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_TRADING_PARTNER_SITES', MSC_CL_COLLECTION.v_instance_id, NULL,

2598: -- Organization Site
2599:
2600: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh) THEN
2601:
2602: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_TRADING_PARTNER_SITES', MSC_CL_COLLECTION.v_instance_id, NULL,
2603: 'AND PARTNER_TYPE=3');
2604:
2605: END IF;
2606:

Line 2613: UPDATE MSC_TRADING_PARTNER_SITES

2609: BEGIN
2610:
2611: IF MSC_CL_COLLECTION.v_is_incremental_refresh THEN
2612:
2613: UPDATE MSC_TRADING_PARTNER_SITES
2614: SET
2615: PARTNER_ADDRESS= c_rec.PARTNER_ADDRESS,
2616: TP_SITE_CODE= c_rec.TP_SITE_CODE,
2617: LOCATION= c_rec.LOCATION,

Line 2633: INSERT INTO MSC_Trading_Partner_Sites

2629: END IF;
2630:
2631: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh) OR SQL%NOTFOUND THEN
2632:
2633: INSERT INTO MSC_Trading_Partner_Sites
2634: ( PARTNER_ID,
2635: PARTNER_SITE_ID,
2636: PARTNER_ADDRESS,
2637: LONGITUDE,

Line 2653: MSC_Trading_Partner_Sites_S.NEXTVAL,

2649: CREATION_DATE,
2650: CREATED_BY)
2651: VALUES
2652: ( c_rec.PARTNER_ID,
2653: MSC_Trading_Partner_Sites_S.NEXTVAL,
2654: c_rec.PARTNER_ADDRESS,
2655: c_rec.LONGITUDE,
2656: c_rec.LATITUDE,
2657: 3,

Line 3821: from MSC_TRADING_PARTNER_SITES mtps

3817: SELECT distinct mtil.TP_ID, msts.tp_site_code
3818: FROM MSC_ST_TRADING_PARTNER_SITES msts,
3819: MSC_TP_ID_LID mtil
3820: WHERE NOT EXISTS ( select 1
3821: from MSC_TRADING_PARTNER_SITES mtps
3822: where mtps.TP_Site_Code= msts.TP_Site_Code
3823: and mtps.Partner_ID= mtil.tp_id)
3824: AND msts.SR_Instance_ID= mtil.SR_INSTANCE_ID
3825: AND msts.SR_TP_ID= mtil.SR_TP_ID

Line 3845: from MSC_TRADING_PARTNER_SITES mtps

3841: msts.Location
3842: FROM MSC_ST_TRADING_PARTNER_SITES msts,
3843: MSC_TP_ID_LID mtil
3844: WHERE NOT EXISTS ( select 1
3845: from MSC_TRADING_PARTNER_SITES mtps
3846: where NVL(mtps.Operating_Unit_Name, ' ')=
3847: NVL(msts.Operating_Unit_Name, ' ')
3848: and mtps.TP_Site_Code= msts.TP_Site_Code
3849: and mtps.Location= msts.Location

Line 3871: MSC_TRADING_PARTNER_SITES mtp

3867: msts.SR_INSTANCE_ID,
3868: mtp.PARTNER_SITE_ID
3869: FROM MSC_ST_TRADING_PARTNER_SITES msts,
3870: MSC_TP_ID_LID mtil,
3871: MSC_TRADING_PARTNER_SITES mtp
3872: WHERE NOT EXISTS( select 1
3873: from MSC_TP_SITE_ID_LID mtsil
3874: where msts.SR_TP_SITE_ID= mtsil.SR_TP_SITE_ID
3875: and msts.SR_INSTANCE_ID= mtsil.SR_INSTANCE_ID

Line 3903: MSC_TRADING_PARTNER_SITES mtp

3899: msts.SR_INSTANCE_ID,
3900: mtp.PARTNER_SITE_ID
3901: FROM MSC_ST_TRADING_PARTNER_SITES msts,
3902: MSC_TP_ID_LID mtil,
3903: MSC_TRADING_PARTNER_SITES mtp
3904: WHERE NOT EXISTS( select 1
3905: from MSC_TP_SITE_ID_LID mtsil
3906: where msts.SR_TP_SITE_ID= mtsil.SR_TP_SITE_ID
3907: and msts.SR_INSTANCE_ID= mtsil.SR_INSTANCE_ID

Line 4191: UPDATE MSC_TRADING_PARTNER_SITES

4187: WHERE SR_TP_ID = c_rec.SR_TP_ID
4188: AND SR_INSTANCE_ID = c_rec.SR_INSTANCE_ID
4189: AND PARTNER_TYPE = c_rec.PARTNER_TYPE;
4190:
4191: UPDATE MSC_TRADING_PARTNER_SITES
4192: SET PARTNER_ID = lv_new_partner_id,
4193: LAST_UPDATE_DATE = v_current_date,
4194: LAST_UPDATED_BY = v_current_user
4195: WHERE PARTNER_ID = lv_old_partner_id

Line 4470: -- ==== Populate msc_trading_partner_sites with new Supplier Sites ====

4466:
4467: COMMIT;
4468:
4469:
4470: -- ==== Populate msc_trading_partner_sites with new Supplier Sites ====
4471:
4472: FOR c_rec IN c6 LOOP
4473:
4474: BEGIN

Line 4476: INSERT INTO MSC_TRADING_PARTNER_SITES

4472: FOR c_rec IN c6 LOOP
4473:
4474: BEGIN
4475:
4476: INSERT INTO MSC_TRADING_PARTNER_SITES
4477: ( TP_SITE_CODE,
4478: PARTNER_ID,
4479: PARTNER_SITE_ID,
4480: SR_TP_SITE_ID,

Line 4491: MSC_Trading_Partner_Sites_S.NEXTVAL,

4487: CREATED_BY)
4488: VALUES
4489: ( c_rec.TP_Site_Code,
4490: c_rec.TP_ID,
4491: MSC_Trading_Partner_Sites_S.NEXTVAL,
4492: MSC_Trading_Partner_Sites_S.NEXTVAL,
4493: 1,
4494: MSC_CL_COLLECTION.v_instance_id,
4495: MSC_CL_COLLECTION.v_last_collection_id,

Line 4492: MSC_Trading_Partner_Sites_S.NEXTVAL,

4488: VALUES
4489: ( c_rec.TP_Site_Code,
4490: c_rec.TP_ID,
4491: MSC_Trading_Partner_Sites_S.NEXTVAL,
4492: MSC_Trading_Partner_Sites_S.NEXTVAL,
4493: 1,
4494: MSC_CL_COLLECTION.v_instance_id,
4495: MSC_CL_COLLECTION.v_last_collection_id,
4496: MSC_CL_COLLECTION.v_current_date,

Line 4512: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_TRADING_PARTNER_SITES');

4508:
4509: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
4510: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
4511: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'GENERATE_TRADING_PARTNER_KEYS');
4512: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_TRADING_PARTNER_SITES');
4513: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
4514:
4515: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
4516: FND_MESSAGE.SET_TOKEN('COLUMN', 'TP_ID');

Line 4648: MSC_TRADING_PARTNER_SITES mtp

4644: msts.operating_unit,
4645: mtp.PARTNER_SITE_ID
4646: FROM MSC_ST_TRADING_PARTNER_SITES msts,
4647: MSC_TP_ID_LID mtil,
4648: MSC_TRADING_PARTNER_SITES mtp
4649: WHERE NOT EXISTS( select 1
4650: from MSC_TP_SITE_ID_LID mtsil
4651: where msts.SR_TP_SITE_ID= mtsil.SR_TP_SITE_ID
4652: and msts.SR_INSTANCE_ID= mtsil.SR_INSTANCE_ID

Line 4681: INSERT INTO MSC_TRADING_PARTNER_SITES

4677: FOR c_rec IN c7 LOOP
4678:
4679: BEGIN
4680:
4681: INSERT INTO MSC_TRADING_PARTNER_SITES
4682: ( TP_SITE_CODE,
4683: LOCATION,
4684: OPERATING_UNIT_NAME,
4685: PARTNER_ID,

Line 4700: MSC_Trading_Partner_Sites_S.NEXTVAL,

4696: ( c_rec.TP_Site_Code,
4697: c_rec.Location,
4698: c_rec.OPERATING_UNIT_NAME,
4699: c_rec.TP_ID,
4700: MSC_Trading_Partner_Sites_S.NEXTVAL,
4701: MSC_Trading_Partner_Sites_S.NEXTVAL,
4702: 2,
4703: MSC_CL_COLLECTION.v_instance_id,
4704: MSC_CL_COLLECTION.v_last_collection_id,

Line 4701: MSC_Trading_Partner_Sites_S.NEXTVAL,

4697: c_rec.Location,
4698: c_rec.OPERATING_UNIT_NAME,
4699: c_rec.TP_ID,
4700: MSC_Trading_Partner_Sites_S.NEXTVAL,
4701: MSC_Trading_Partner_Sites_S.NEXTVAL,
4702: 2,
4703: MSC_CL_COLLECTION.v_instance_id,
4704: MSC_CL_COLLECTION.v_last_collection_id,
4705: MSC_CL_COLLECTION.v_current_date,

Line 4721: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_TRADING_PARTNER_SITES');

4717:
4718: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
4719: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
4720: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'GENERATE_TRADING_PARTNER_KEYS');
4721: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_TRADING_PARTNER_SITES');
4722: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
4723:
4724: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
4725: FND_MESSAGE.SET_TOKEN('COLUMN', 'PARTNER_TYPE');

Line 4869: MSC_TRADING_PARTNER_SITES mtp

4865: mtp.PARTNER_SITE_ID,
4866: msts.SR_TP_ID
4867: FROM MSC_ST_TRADING_PARTNER_SITES msts,
4868: MSC_TP_ID_LID mtil,
4869: MSC_TRADING_PARTNER_SITES mtp
4870: WHERE NOT EXISTS( select 1
4871: from MSC_TP_SITE_ID_LID mtsil
4872: where msts.SR_TP_SITE_ID= mtsil.SR_TP_SITE_ID
4873: and msts.SR_INSTANCE_ID= mtsil.SR_INSTANCE_ID

Line 4999: UPDATE MSC_Trading_Partner_Sites mtps

4995:
4996: FOR c_rec IN c2 LOOP
4997:
4998: BEGIN
4999: UPDATE MSC_Trading_Partner_Sites mtps
5000: SET mtps.PARTNER_ADDRESS= c_rec.PARTNER_ADDRESS,
5001: mtps.LONGITUDE= NVL( c_rec.LONGITUDE, mtps.LONGITUDE),
5002: mtps.LATITUDE= NVL( c_rec.LATITUDE, mtps.LATITUDE),
5003: mtps.SR_TP_SITE_ID= c_rec.SR_TP_SITE_ID,

Line 5028: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_TRADING_PARTNER_SITES');

5024:
5025: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
5026: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
5027: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'GENERATE_TRADING_PARTNER_KEYS');
5028: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_TRADING_PARTNER_SITES');
5029: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
5030:
5031: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
5032: FND_MESSAGE.SET_TOKEN('COLUMN', 'PARTNER_TYPE');

Line 5054: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_TRADING_PARTNER_SITES');

5050:
5051: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
5052: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
5053: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'GENERATE_TRADING_PARTNER_KEYS');
5054: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_TRADING_PARTNER_SITES');
5055: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
5056:
5057: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
5058: FND_MESSAGE.SET_TOKEN('COLUMN', 'PARTNER_TYPE');