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 2592: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_TRADING_PARTNER_SITES', MSC_CL_COLLECTION.v_instance_id, NULL,

2588: -- Organization Site
2589:
2590: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh) THEN
2591:
2592: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_TRADING_PARTNER_SITES', MSC_CL_COLLECTION.v_instance_id, NULL,
2593: 'AND PARTNER_TYPE=3');
2594:
2595: END IF;
2596:

Line 2603: UPDATE MSC_TRADING_PARTNER_SITES

2599: BEGIN
2600:
2601: IF MSC_CL_COLLECTION.v_is_incremental_refresh THEN
2602:
2603: UPDATE MSC_TRADING_PARTNER_SITES
2604: SET
2605: PARTNER_ADDRESS= c_rec.PARTNER_ADDRESS,
2606: TP_SITE_CODE= c_rec.TP_SITE_CODE,
2607: LOCATION= c_rec.LOCATION,

Line 2623: INSERT INTO MSC_Trading_Partner_Sites

2619: END IF;
2620:
2621: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh) OR SQL%NOTFOUND THEN
2622:
2623: INSERT INTO MSC_Trading_Partner_Sites
2624: ( PARTNER_ID,
2625: PARTNER_SITE_ID,
2626: PARTNER_ADDRESS,
2627: LONGITUDE,

Line 2643: MSC_Trading_Partner_Sites_S.NEXTVAL,

2639: CREATION_DATE,
2640: CREATED_BY)
2641: VALUES
2642: ( c_rec.PARTNER_ID,
2643: MSC_Trading_Partner_Sites_S.NEXTVAL,
2644: c_rec.PARTNER_ADDRESS,
2645: c_rec.LONGITUDE,
2646: c_rec.LATITUDE,
2647: 3,

Line 3811: from MSC_TRADING_PARTNER_SITES mtps

3807: SELECT distinct mtil.TP_ID, msts.tp_site_code
3808: FROM MSC_ST_TRADING_PARTNER_SITES msts,
3809: MSC_TP_ID_LID mtil
3810: WHERE NOT EXISTS ( select 1
3811: from MSC_TRADING_PARTNER_SITES mtps
3812: where mtps.TP_Site_Code= msts.TP_Site_Code
3813: and mtps.Partner_ID= mtil.tp_id)
3814: AND msts.SR_Instance_ID= mtil.SR_INSTANCE_ID
3815: AND msts.SR_TP_ID= mtil.SR_TP_ID

Line 3835: from MSC_TRADING_PARTNER_SITES mtps

3831: msts.Location
3832: FROM MSC_ST_TRADING_PARTNER_SITES msts,
3833: MSC_TP_ID_LID mtil
3834: WHERE NOT EXISTS ( select 1
3835: from MSC_TRADING_PARTNER_SITES mtps
3836: where NVL(mtps.Operating_Unit_Name, ' ')=
3837: NVL(msts.Operating_Unit_Name, ' ')
3838: and mtps.TP_Site_Code= msts.TP_Site_Code
3839: and mtps.Location= msts.Location

Line 3861: MSC_TRADING_PARTNER_SITES mtp

3857: msts.SR_INSTANCE_ID,
3858: mtp.PARTNER_SITE_ID
3859: FROM MSC_ST_TRADING_PARTNER_SITES msts,
3860: MSC_TP_ID_LID mtil,
3861: MSC_TRADING_PARTNER_SITES mtp
3862: WHERE NOT EXISTS( select 1
3863: from MSC_TP_SITE_ID_LID mtsil
3864: where msts.SR_TP_SITE_ID= mtsil.SR_TP_SITE_ID
3865: and msts.SR_INSTANCE_ID= mtsil.SR_INSTANCE_ID

Line 3893: MSC_TRADING_PARTNER_SITES mtp

3889: msts.SR_INSTANCE_ID,
3890: mtp.PARTNER_SITE_ID
3891: FROM MSC_ST_TRADING_PARTNER_SITES msts,
3892: MSC_TP_ID_LID mtil,
3893: MSC_TRADING_PARTNER_SITES mtp
3894: WHERE NOT EXISTS( select 1
3895: from MSC_TP_SITE_ID_LID mtsil
3896: where msts.SR_TP_SITE_ID= mtsil.SR_TP_SITE_ID
3897: and msts.SR_INSTANCE_ID= mtsil.SR_INSTANCE_ID

Line 4181: UPDATE MSC_TRADING_PARTNER_SITES

4177: WHERE SR_TP_ID = c_rec.SR_TP_ID
4178: AND SR_INSTANCE_ID = c_rec.SR_INSTANCE_ID
4179: AND PARTNER_TYPE = c_rec.PARTNER_TYPE;
4180:
4181: UPDATE MSC_TRADING_PARTNER_SITES
4182: SET PARTNER_ID = lv_new_partner_id,
4183: LAST_UPDATE_DATE = v_current_date,
4184: LAST_UPDATED_BY = v_current_user
4185: WHERE PARTNER_ID = lv_old_partner_id

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

4456:
4457: COMMIT;
4458:
4459:
4460: -- ==== Populate msc_trading_partner_sites with new Supplier Sites ====
4461:
4462: FOR c_rec IN c6 LOOP
4463:
4464: BEGIN

Line 4466: INSERT INTO MSC_TRADING_PARTNER_SITES

4462: FOR c_rec IN c6 LOOP
4463:
4464: BEGIN
4465:
4466: INSERT INTO MSC_TRADING_PARTNER_SITES
4467: ( TP_SITE_CODE,
4468: PARTNER_ID,
4469: PARTNER_SITE_ID,
4470: SR_TP_SITE_ID,

Line 4481: MSC_Trading_Partner_Sites_S.NEXTVAL,

4477: CREATED_BY)
4478: VALUES
4479: ( c_rec.TP_Site_Code,
4480: c_rec.TP_ID,
4481: MSC_Trading_Partner_Sites_S.NEXTVAL,
4482: MSC_Trading_Partner_Sites_S.NEXTVAL,
4483: 1,
4484: MSC_CL_COLLECTION.v_instance_id,
4485: MSC_CL_COLLECTION.v_last_collection_id,

Line 4482: MSC_Trading_Partner_Sites_S.NEXTVAL,

4478: VALUES
4479: ( c_rec.TP_Site_Code,
4480: c_rec.TP_ID,
4481: MSC_Trading_Partner_Sites_S.NEXTVAL,
4482: MSC_Trading_Partner_Sites_S.NEXTVAL,
4483: 1,
4484: MSC_CL_COLLECTION.v_instance_id,
4485: MSC_CL_COLLECTION.v_last_collection_id,
4486: MSC_CL_COLLECTION.v_current_date,

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

4498:
4499: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
4500: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
4501: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'GENERATE_TRADING_PARTNER_KEYS');
4502: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_TRADING_PARTNER_SITES');
4503: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
4504:
4505: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
4506: FND_MESSAGE.SET_TOKEN('COLUMN', 'TP_ID');

Line 4638: MSC_TRADING_PARTNER_SITES mtp

4634: msts.operating_unit,
4635: mtp.PARTNER_SITE_ID
4636: FROM MSC_ST_TRADING_PARTNER_SITES msts,
4637: MSC_TP_ID_LID mtil,
4638: MSC_TRADING_PARTNER_SITES mtp
4639: WHERE NOT EXISTS( select 1
4640: from MSC_TP_SITE_ID_LID mtsil
4641: where msts.SR_TP_SITE_ID= mtsil.SR_TP_SITE_ID
4642: and msts.SR_INSTANCE_ID= mtsil.SR_INSTANCE_ID

Line 4671: INSERT INTO MSC_TRADING_PARTNER_SITES

4667: FOR c_rec IN c7 LOOP
4668:
4669: BEGIN
4670:
4671: INSERT INTO MSC_TRADING_PARTNER_SITES
4672: ( TP_SITE_CODE,
4673: LOCATION,
4674: OPERATING_UNIT_NAME,
4675: PARTNER_ID,

Line 4690: MSC_Trading_Partner_Sites_S.NEXTVAL,

4686: ( c_rec.TP_Site_Code,
4687: c_rec.Location,
4688: c_rec.OPERATING_UNIT_NAME,
4689: c_rec.TP_ID,
4690: MSC_Trading_Partner_Sites_S.NEXTVAL,
4691: MSC_Trading_Partner_Sites_S.NEXTVAL,
4692: 2,
4693: MSC_CL_COLLECTION.v_instance_id,
4694: MSC_CL_COLLECTION.v_last_collection_id,

Line 4691: MSC_Trading_Partner_Sites_S.NEXTVAL,

4687: c_rec.Location,
4688: c_rec.OPERATING_UNIT_NAME,
4689: c_rec.TP_ID,
4690: MSC_Trading_Partner_Sites_S.NEXTVAL,
4691: MSC_Trading_Partner_Sites_S.NEXTVAL,
4692: 2,
4693: MSC_CL_COLLECTION.v_instance_id,
4694: MSC_CL_COLLECTION.v_last_collection_id,
4695: MSC_CL_COLLECTION.v_current_date,

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

4707:
4708: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
4709: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
4710: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'GENERATE_TRADING_PARTNER_KEYS');
4711: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_TRADING_PARTNER_SITES');
4712: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
4713:
4714: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
4715: FND_MESSAGE.SET_TOKEN('COLUMN', 'PARTNER_TYPE');

Line 4859: MSC_TRADING_PARTNER_SITES mtp

4855: mtp.PARTNER_SITE_ID,
4856: msts.SR_TP_ID
4857: FROM MSC_ST_TRADING_PARTNER_SITES msts,
4858: MSC_TP_ID_LID mtil,
4859: MSC_TRADING_PARTNER_SITES mtp
4860: WHERE NOT EXISTS( select 1
4861: from MSC_TP_SITE_ID_LID mtsil
4862: where msts.SR_TP_SITE_ID= mtsil.SR_TP_SITE_ID
4863: and msts.SR_INSTANCE_ID= mtsil.SR_INSTANCE_ID

Line 4989: UPDATE MSC_Trading_Partner_Sites mtps

4985:
4986: FOR c_rec IN c2 LOOP
4987:
4988: BEGIN
4989: UPDATE MSC_Trading_Partner_Sites mtps
4990: SET mtps.PARTNER_ADDRESS= c_rec.PARTNER_ADDRESS,
4991: mtps.LONGITUDE= NVL( c_rec.LONGITUDE, mtps.LONGITUDE),
4992: mtps.LATITUDE= NVL( c_rec.LATITUDE, mtps.LATITUDE),
4993: mtps.SR_TP_SITE_ID= c_rec.SR_TP_SITE_ID,

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

5014:
5015: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
5016: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
5017: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'GENERATE_TRADING_PARTNER_KEYS');
5018: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_TRADING_PARTNER_SITES');
5019: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
5020:
5021: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
5022: FND_MESSAGE.SET_TOKEN('COLUMN', 'PARTNER_TYPE');

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

5040:
5041: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
5042: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
5043: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'GENERATE_TRADING_PARTNER_KEYS');
5044: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_TRADING_PARTNER_SITES');
5045: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
5046:
5047: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
5048: FND_MESSAGE.SET_TOKEN('COLUMN', 'PARTNER_TYPE');