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_TP_SITE_ID_LID

Line 336: MSC_TP_SITE_ID_LID tsil,

332: msca.PARTNER_TYPE,
333: msca.ASSOCIATION_LEVEL,
334: msca.SHIP_METHOD_CODE
335: FROM MSC_TP_ID_LID til,
336: MSC_TP_SITE_ID_LID tsil,
337: MSC_ST_CALENDAR_ASSIGNMENTS msca,
338: MSC_TP_ID_LID mtil
339: WHERE til.SR_INSTANCE_ID(+)= msca.SR_INSTANCE_ID
340: AND til.SR_TP_ID(+)= msca.PARTNER_ID

Line 2104: MSC_TP_SITE_ID_LID tsilc,

2100: mst.LEGAL_ENTITY_NAME,
2101: mst.OPERATING_UNIT_NAME
2102: FROM MSC_TP_ID_LID tilc,
2103: MSC_TP_ID_LID tils,
2104: MSC_TP_SITE_ID_LID tsilc,
2105: MSC_TP_SITE_ID_LID tsils,
2106: MSC_ST_TRADING_PARTNERS mst,
2107: MSC_COMPANIES MC
2108: WHERE mst.PARTNER_TYPE= 3

Line 2105: MSC_TP_SITE_ID_LID tsils,

2101: mst.OPERATING_UNIT_NAME
2102: FROM MSC_TP_ID_LID tilc,
2103: MSC_TP_ID_LID tils,
2104: MSC_TP_SITE_ID_LID tsilc,
2105: MSC_TP_SITE_ID_LID tsils,
2106: MSC_ST_TRADING_PARTNERS mst,
2107: MSC_COMPANIES MC
2108: WHERE mst.PARTNER_TYPE= 3
2109: /* SCE Change starts */

Line 2157: MSC_TP_SITE_ID_LID tsil,

2153: tsil.TP_SITE_ID PARTNER_SITE_ID,
2154: msta.organization_id,
2155: msta.SR_INSTANCE_ID
2156: FROM MSC_TP_ID_LID til,
2157: MSC_TP_SITE_ID_LID tsil,
2158: MSC_ST_LOCATION_ASSOCIATIONS msta
2159: WHERE til.SR_INSTANCE_ID= msta.SR_INSTANCE_ID
2160: AND til.SR_TP_ID= msta.SR_TP_ID
2161: AND til.PARTNER_TYPE= msta.PARTNER_TYPE

Line 2186: MSC_TP_SITE_ID_LID tsil,

2182: pc.FAX,
2183: pc.ENABLED_FLAG,
2184: pc.DELETED_FLAG
2185: FROM MSC_TP_ID_LID til,
2186: MSC_TP_SITE_ID_LID tsil,
2187: MSC_ST_PARTNER_CONTACTS pc
2188: WHERE pc.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
2189: AND pc.DELETED_FLAG in (1, 2)
2190: AND til.sr_tp_id(+)= pc.partner_id

Line 3737: FROM MSC_TP_SITE_ID_LID mtsil,

3733: msts.LATITUDE,
3734: msts.SR_TP_SITE_ID,
3735: msts.SR_INSTANCE_ID,
3736: msts.SHIPPING_CONTROL
3737: FROM MSC_TP_SITE_ID_LID mtsil,
3738: MSC_ST_TRADING_PARTNER_SITES msts
3739: WHERE mtsil.SR_TP_SITE_ID= msts.SR_TP_SITE_ID
3740: AND mtsil.SR_INSTANCE_ID= msts.SR_INSTANCE_ID
3741: AND msts.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id

Line 3863: from MSC_TP_SITE_ID_LID mtsil

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
3866: and mtsil.Partner_Type= 1
3867: and nvl(msts.company_id, -1) = mtsil.sr_company_id)

Line 3880: --====== Cursor for populating msc_tp_site_id_lid ====

3876: AND mtp.partner_type = mtil.partner_type
3877: AND mtil.Partner_Type= msts.partner_type
3878: AND msts.Partner_Type= 1;
3879:
3880: --====== Cursor for populating msc_tp_site_id_lid ====
3881:
3882: Cursor c10 IS
3883: SELECT distinct
3884: /* SCE Change starts*/

Line 3895: from MSC_TP_SITE_ID_LID mtsil

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
3898: and mtsil.Partner_Type= 2
3899: and nvl(msts.company_id, -1) = mtsil.sr_company_id)

Line 4007: where table_name ='MSC_TP_SITE_ID_LID';

4003: begin
4004: select num_rows,decode (stale_stats,'NO', MSC_UTIL.SYS_NO, MSC_UTIL.SYS_YES )
4005: into lv_tp_site_id_count, lv_tp_site_stat_stale
4006: from dba_TAB_STATISTICS
4007: where table_name ='MSC_TP_SITE_ID_LID';
4008: exception when no_data_found then
4009: lv_tp_site_stat_stale := MSC_UTIL.SYS_YES ;
4010: end;
4011:

Line 4018: DELETE MSC_TP_SITE_ID_LID WHERE SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id;

4014:
4015: IF lv_control_flag = 2 THEN
4016: IF lv_msc_tp_coll_window = 0 THEN
4017: DELETE MSC_TP_ID_LID WHERE SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id;
4018: DELETE MSC_TP_SITE_ID_LID WHERE SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id;
4019: DELETE MSC_TP_ID_LID WHERE SR_INSTANCE_ID= -1;
4020: DELETE MSC_TP_SITE_ID_LID WHERE SR_INSTANCE_ID= -1;
4021: END IF;
4022:

Line 4020: DELETE MSC_TP_SITE_ID_LID WHERE SR_INSTANCE_ID= -1;

4016: IF lv_msc_tp_coll_window = 0 THEN
4017: DELETE MSC_TP_ID_LID WHERE SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id;
4018: DELETE MSC_TP_SITE_ID_LID WHERE SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id;
4019: DELETE MSC_TP_ID_LID WHERE SR_INSTANCE_ID= -1;
4020: DELETE MSC_TP_SITE_ID_LID WHERE SR_INSTANCE_ID= -1;
4021: END IF;
4022:
4023: ELSE
4024: IF lv_msc_tp_coll_window = 0 THEN

Line 4026: MSC_CL_COLLECTION.TRUNCATE_MSC_TABLE( 'MSC_TP_SITE_ID_LID');

4022:
4023: ELSE
4024: IF lv_msc_tp_coll_window = 0 THEN
4025: MSC_CL_COLLECTION.TRUNCATE_MSC_TABLE( 'MSC_TP_ID_LID');
4026: MSC_CL_COLLECTION.TRUNCATE_MSC_TABLE( 'MSC_TP_SITE_ID_LID');
4027: END IF;
4028:
4029: END IF;
4030: lv_tp_stat_stale := MSC_UTIL.SYS_YES ;

Line 4066: DELETE MSC_TP_SITE_ID_LID WHERE SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id;

4062:
4063: IF lv_msc_tp_coll_window = 0 THEN
4064: IF lv_control_flag = 2 THEN
4065: DELETE MSC_TP_ID_LID WHERE SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id and partner_type in (1,2);
4066: DELETE MSC_TP_SITE_ID_LID WHERE SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id;
4067: DELETE MSC_TP_ID_LID WHERE SR_INSTANCE_ID= -1 and partner_type in (1,2);
4068: DELETE MSC_TP_SITE_ID_LID WHERE SR_INSTANCE_ID= -1;
4069: ELSE
4070: MSC_CL_COLLECTION.TRUNCATE_MSC_TABLE( 'MSC_TP_ID_LID');

Line 4068: DELETE MSC_TP_SITE_ID_LID WHERE SR_INSTANCE_ID= -1;

4064: IF lv_control_flag = 2 THEN
4065: DELETE MSC_TP_ID_LID WHERE SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id and partner_type in (1,2);
4066: DELETE MSC_TP_SITE_ID_LID WHERE SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id;
4067: DELETE MSC_TP_ID_LID WHERE SR_INSTANCE_ID= -1 and partner_type in (1,2);
4068: DELETE MSC_TP_SITE_ID_LID WHERE SR_INSTANCE_ID= -1;
4069: ELSE
4070: MSC_CL_COLLECTION.TRUNCATE_MSC_TABLE( 'MSC_TP_ID_LID');
4071: MSC_CL_COLLECTION.TRUNCATE_MSC_TABLE( 'MSC_TP_SITE_ID_LID');
4072: END IF;

Line 4071: MSC_CL_COLLECTION.TRUNCATE_MSC_TABLE( 'MSC_TP_SITE_ID_LID');

4067: DELETE MSC_TP_ID_LID WHERE SR_INSTANCE_ID= -1 and partner_type in (1,2);
4068: DELETE MSC_TP_SITE_ID_LID WHERE SR_INSTANCE_ID= -1;
4069: ELSE
4070: MSC_CL_COLLECTION.TRUNCATE_MSC_TABLE( 'MSC_TP_ID_LID');
4071: MSC_CL_COLLECTION.TRUNCATE_MSC_TABLE( 'MSC_TP_SITE_ID_LID');
4072: END IF;
4073: END IF;
4074: lv_tp_stat_stale := MSC_UTIL.SYS_YES ;
4075: lv_tp_site_stat_stale := MSC_UTIL.SYS_YES ;

Line 4099: DELETE MSC_TP_SITE_ID_LID WHERE SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id;

4095: -- We do not delete data if the profile "MSC_COLLECTION_WINDOW_FOR_TP_CHANGES" is set to not null.
4096: IF lv_msc_tp_coll_window = 0 THEN
4097: IF lv_control_flag = 2 THEN
4098: DELETE MSC_TP_ID_LID WHERE SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id and partner_type in (1,2);
4099: DELETE MSC_TP_SITE_ID_LID WHERE SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id;
4100: DELETE MSC_TP_ID_LID WHERE SR_INSTANCE_ID= -1 and partner_type in (1,2);
4101: DELETE MSC_TP_SITE_ID_LID WHERE SR_INSTANCE_ID= -1;
4102: ELSE
4103: MSC_CL_COLLECTION.TRUNCATE_MSC_TABLE( 'MSC_TP_ID_LID');

Line 4101: DELETE MSC_TP_SITE_ID_LID WHERE SR_INSTANCE_ID= -1;

4097: IF lv_control_flag = 2 THEN
4098: DELETE MSC_TP_ID_LID WHERE SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id and partner_type in (1,2);
4099: DELETE MSC_TP_SITE_ID_LID WHERE SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id;
4100: DELETE MSC_TP_ID_LID WHERE SR_INSTANCE_ID= -1 and partner_type in (1,2);
4101: DELETE MSC_TP_SITE_ID_LID WHERE SR_INSTANCE_ID= -1;
4102: ELSE
4103: MSC_CL_COLLECTION.TRUNCATE_MSC_TABLE( 'MSC_TP_ID_LID');
4104: MSC_CL_COLLECTION.TRUNCATE_MSC_TABLE( 'MSC_TP_SITE_ID_LID');
4105: END IF;

Line 4104: MSC_CL_COLLECTION.TRUNCATE_MSC_TABLE( 'MSC_TP_SITE_ID_LID');

4100: DELETE MSC_TP_ID_LID WHERE SR_INSTANCE_ID= -1 and partner_type in (1,2);
4101: DELETE MSC_TP_SITE_ID_LID WHERE SR_INSTANCE_ID= -1;
4102: ELSE
4103: MSC_CL_COLLECTION.TRUNCATE_MSC_TABLE( 'MSC_TP_ID_LID');
4104: MSC_CL_COLLECTION.TRUNCATE_MSC_TABLE( 'MSC_TP_SITE_ID_LID');
4105: END IF;
4106: lv_tp_stat_stale := MSC_UTIL.SYS_YES ;
4107: lv_tp_site_stat_stale := MSC_UTIL.SYS_YES ;
4108: END IF;

Line 4527: -- ==== Populate msc_tp_site_id_lid with new Supplier Sites ====

4523: END LOOP;
4524:
4525: COMMIT;
4526: lv_ins_records := 0;
4527: -- ==== Populate msc_tp_site_id_lid with new Supplier Sites ====
4528: IF MSC_CL_COLLECTION.v_apps_ver < MSC_UTIL.G_APPS115 THEN
4529:
4530: /* For 107 and 110 the vendor_id and vendor
4531: site id can be duplicate, therefore we use

Line 4539: INSERT INTO MSC_TP_SITE_ID_LID

4535: FOR c_rec IN c9 LOOP
4536:
4537: BEGIN
4538:
4539: INSERT INTO MSC_TP_SITE_ID_LID
4540: ( /* SCE Change starts */
4541: SR_COMPANY_ID,
4542: /* SCE Change ends */
4543: SR_TP_SITE_ID,

Line 4563: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_TP_SITE_ID_LID');

4559:
4560: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
4561: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
4562: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'GENERATE_TRADING_PARTNER_KEYS');
4563: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_TP_SITE_ID_LID');
4564: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
4565:
4566: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
4567: FND_MESSAGE.SET_TOKEN('COLUMN', 'PARTNER_TYPE');

Line 4590: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_TP_SITE_ID_LID');

4586:
4587: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
4588: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
4589: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'GENERATE_TRADING_PARTNER_KEYS');
4590: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_TP_SITE_ID_LID');
4591: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
4592:
4593: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
4594: FND_MESSAGE.SET_TOKEN('COLUMN', 'PARTNER_TYPE');

Line 4620: INSERT /+ APPEND / INTO MSC_TP_SITE_ID_LID

4616: END LOOP;
4617:
4618: ELSE
4619:
4620: INSERT /*+ APPEND */ INTO MSC_TP_SITE_ID_LID
4621: ( SR_COMPANY_ID,
4622: SR_TP_SITE_ID,
4623: SR_INSTANCE_ID,
4624: Partner_Type,

Line 4640: from MSC_TP_SITE_ID_LID mtsil

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
4643: and mtsil.Partner_Type= 1
4644: and nvl(msts.company_id, -1) = mtsil.sr_company_id)

Line 4660: msc_analyse_tables_pk.analyse_table( 'MSC_TP_SITE_ID_LID');

4656:
4657: COMMIT;
4658: /* Bug7679044 */
4659: IF lv_tp_site_stat_stale = MSC_UTIL.SYS_YES OR lv_ins_records > lv_tp_site_id_count * 0.2 THEN
4660: msc_analyse_tables_pk.analyse_table( 'MSC_TP_SITE_ID_LID');
4661: lv_tp_site_stat_stale := MSC_UTIL.SYS_NO;
4662: lv_tp_site_id_count := lv_tp_site_id_count + lv_ins_records;
4663: END IF;
4664:

Line 4759: INSERT INTO MSC_TP_SITE_ID_LID

4755: FOR c_rec IN c10 LOOP
4756:
4757: BEGIN
4758:
4759: INSERT INTO MSC_TP_SITE_ID_LID
4760: ( /* SCE Change starts*/
4761: SR_COMPANY_ID,
4762: /* SCE Change ends*/
4763: SR_TP_SITE_ID,

Line 4784: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_TP_SITE_ID_LID');

4780:
4781: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
4782: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
4783: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'GENERATE_TRADING_PARTNER_KEYS');
4784: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_TP_SITE_ID_LID');
4785: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
4786:
4787: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
4788: FND_MESSAGE.SET_TOKEN('COLUMN', 'PARTNER_TYPE');

Line 4811: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_TP_SITE_ID_LID');

4807:
4808: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
4809: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
4810: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'GENERATE_TRADING_PARTNER_KEYS');
4811: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_TP_SITE_ID_LID');
4812: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
4813:
4814: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
4815: FND_MESSAGE.SET_TOKEN('COLUMN', 'PARTNER_TYPE');

Line 4841: INSERT /+ APPEND / INTO MSC_TP_SITE_ID_LID

4837: END LOOP;
4838:
4839: ELSE
4840:
4841: INSERT /*+ APPEND */ INTO MSC_TP_SITE_ID_LID
4842: ( SR_COMPANY_ID,
4843: SR_TP_SITE_ID,
4844: SR_INSTANCE_ID,
4845: Partner_Type,

Line 4861: from MSC_TP_SITE_ID_LID mtsil

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
4864: and mtsil.Partner_Type= 2
4865: and nvl(msts.company_id, -1) = mtsil.sr_company_id)

Line 4884: msc_analyse_tables_pk.analyse_table( 'MSC_TP_SITE_ID_LID');

4880:
4881: COMMIT;
4882: /* Bug7679044 */
4883: IF lv_tp_site_stat_stale = MSC_UTIL.SYS_YES OR lv_ins_records > lv_tp_site_id_count * 0.2 THEN
4884: msc_analyse_tables_pk.analyse_table( 'MSC_TP_SITE_ID_LID');
4885: lv_tp_site_stat_stale := MSC_UTIL.SYS_NO;
4886: lv_tp_site_id_count := lv_tp_site_id_count + lv_ins_records;
4887: END IF;
4888:

Line 5074: msc_analyse_tables_pk.analyse_table( 'MSC_TP_SITE_ID_LID');

5070: IF lv_tp_stat_stale = MSC_UTIL.SYS_YES THEN
5071: msc_analyse_tables_pk.analyse_table( 'MSC_TP_ID_LID');
5072: END IF;
5073: IF lv_tp_site_stat_stale = MSC_UTIL.SYS_YES THEN
5074: msc_analyse_tables_pk.analyse_table( 'MSC_TP_SITE_ID_LID');
5075: END IF;
5076:
5077: EXCEPTION
5078: