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 2110: MSC_TP_SITE_ID_LID tsilc,

2106: mst.OPERATING_UNIT_NAME,
2107: mst.subcontracting_source_org
2108: FROM MSC_TP_ID_LID tilc,
2109: MSC_TP_ID_LID tils,
2110: MSC_TP_SITE_ID_LID tsilc,
2111: MSC_TP_SITE_ID_LID tsils,
2112: MSC_ST_TRADING_PARTNERS mst,
2113: MSC_COMPANIES MC
2114: WHERE mst.PARTNER_TYPE= 3

Line 2111: MSC_TP_SITE_ID_LID tsils,

2107: mst.subcontracting_source_org
2108: FROM MSC_TP_ID_LID tilc,
2109: MSC_TP_ID_LID tils,
2110: MSC_TP_SITE_ID_LID tsilc,
2111: MSC_TP_SITE_ID_LID tsils,
2112: MSC_ST_TRADING_PARTNERS mst,
2113: MSC_COMPANIES MC
2114: WHERE mst.PARTNER_TYPE= 3
2115: /* SCE Change starts */

Line 2163: MSC_TP_SITE_ID_LID tsil,

2159: tsil.TP_SITE_ID PARTNER_SITE_ID,
2160: msta.organization_id,
2161: msta.SR_INSTANCE_ID
2162: FROM MSC_TP_ID_LID til,
2163: MSC_TP_SITE_ID_LID tsil,
2164: MSC_ST_LOCATION_ASSOCIATIONS msta
2165: WHERE til.SR_INSTANCE_ID= msta.SR_INSTANCE_ID
2166: AND til.SR_TP_ID= msta.SR_TP_ID
2167: AND til.PARTNER_TYPE= msta.PARTNER_TYPE

Line 2192: MSC_TP_SITE_ID_LID tsil,

2188: pc.FAX,
2189: pc.ENABLED_FLAG,
2190: pc.DELETED_FLAG
2191: FROM MSC_TP_ID_LID til,
2192: MSC_TP_SITE_ID_LID tsil,
2193: MSC_ST_PARTNER_CONTACTS pc
2194: WHERE pc.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
2195: AND pc.DELETED_FLAG in (1, 2)
2196: AND til.sr_tp_id(+)= pc.partner_id

Line 3747: FROM MSC_TP_SITE_ID_LID mtsil,

3743: msts.LATITUDE,
3744: msts.SR_TP_SITE_ID,
3745: msts.SR_INSTANCE_ID,
3746: msts.SHIPPING_CONTROL
3747: FROM MSC_TP_SITE_ID_LID mtsil,
3748: MSC_ST_TRADING_PARTNER_SITES msts
3749: WHERE mtsil.SR_TP_SITE_ID= msts.SR_TP_SITE_ID
3750: AND mtsil.SR_INSTANCE_ID= msts.SR_INSTANCE_ID
3751: AND msts.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id

Line 3873: from MSC_TP_SITE_ID_LID mtsil

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

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

3886: AND mtp.partner_type = mtil.partner_type
3887: AND mtil.Partner_Type= msts.partner_type
3888: AND msts.Partner_Type= 1;
3889:
3890: --====== Cursor for populating msc_tp_site_id_lid ====
3891:
3892: Cursor c10 IS
3893: SELECT distinct
3894: /* SCE Change starts*/

Line 3905: from MSC_TP_SITE_ID_LID mtsil

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

Line 4017: where table_name ='MSC_TP_SITE_ID_LID';

4013: begin
4014: select num_rows,decode (stale_stats,'NO', MSC_UTIL.SYS_NO, MSC_UTIL.SYS_YES )
4015: into lv_tp_site_id_count, lv_tp_site_stat_stale
4016: from dba_TAB_STATISTICS
4017: where table_name ='MSC_TP_SITE_ID_LID';
4018: exception when no_data_found then
4019: lv_tp_site_stat_stale := MSC_UTIL.SYS_YES ;
4020: end;
4021:

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

4024:
4025: IF lv_control_flag = 2 THEN
4026: IF lv_msc_tp_coll_window = 0 THEN
4027: DELETE MSC_TP_ID_LID WHERE SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id;
4028: DELETE MSC_TP_SITE_ID_LID WHERE SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id;
4029: DELETE MSC_TP_ID_LID WHERE SR_INSTANCE_ID= -1;
4030: DELETE MSC_TP_SITE_ID_LID WHERE SR_INSTANCE_ID= -1;
4031: END IF;
4032:

Line 4030: DELETE MSC_TP_SITE_ID_LID WHERE SR_INSTANCE_ID= -1;

4026: IF lv_msc_tp_coll_window = 0 THEN
4027: DELETE MSC_TP_ID_LID WHERE SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id;
4028: DELETE MSC_TP_SITE_ID_LID WHERE SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id;
4029: DELETE MSC_TP_ID_LID WHERE SR_INSTANCE_ID= -1;
4030: DELETE MSC_TP_SITE_ID_LID WHERE SR_INSTANCE_ID= -1;
4031: END IF;
4032:
4033: ELSE
4034: IF lv_msc_tp_coll_window = 0 THEN

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

4032:
4033: ELSE
4034: IF lv_msc_tp_coll_window = 0 THEN
4035: MSC_CL_COLLECTION.TRUNCATE_MSC_TABLE( 'MSC_TP_ID_LID');
4036: MSC_CL_COLLECTION.TRUNCATE_MSC_TABLE( 'MSC_TP_SITE_ID_LID');
4037: END IF;
4038:
4039: END IF;
4040: lv_tp_stat_stale := MSC_UTIL.SYS_YES ;

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

4072:
4073: IF lv_msc_tp_coll_window = 0 THEN
4074: IF lv_control_flag = 2 THEN
4075: DELETE MSC_TP_ID_LID WHERE SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id and partner_type in (1,2);
4076: DELETE MSC_TP_SITE_ID_LID WHERE SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id;
4077: DELETE MSC_TP_ID_LID WHERE SR_INSTANCE_ID= -1 and partner_type in (1,2);
4078: DELETE MSC_TP_SITE_ID_LID WHERE SR_INSTANCE_ID= -1;
4079: ELSE
4080: MSC_CL_COLLECTION.TRUNCATE_MSC_TABLE( 'MSC_TP_ID_LID');

Line 4078: DELETE MSC_TP_SITE_ID_LID WHERE SR_INSTANCE_ID= -1;

4074: IF lv_control_flag = 2 THEN
4075: DELETE MSC_TP_ID_LID WHERE SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id and partner_type in (1,2);
4076: DELETE MSC_TP_SITE_ID_LID WHERE SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id;
4077: DELETE MSC_TP_ID_LID WHERE SR_INSTANCE_ID= -1 and partner_type in (1,2);
4078: DELETE MSC_TP_SITE_ID_LID WHERE SR_INSTANCE_ID= -1;
4079: ELSE
4080: MSC_CL_COLLECTION.TRUNCATE_MSC_TABLE( 'MSC_TP_ID_LID');
4081: MSC_CL_COLLECTION.TRUNCATE_MSC_TABLE( 'MSC_TP_SITE_ID_LID');
4082: END IF;

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

4077: DELETE MSC_TP_ID_LID WHERE SR_INSTANCE_ID= -1 and partner_type in (1,2);
4078: DELETE MSC_TP_SITE_ID_LID WHERE SR_INSTANCE_ID= -1;
4079: ELSE
4080: MSC_CL_COLLECTION.TRUNCATE_MSC_TABLE( 'MSC_TP_ID_LID');
4081: MSC_CL_COLLECTION.TRUNCATE_MSC_TABLE( 'MSC_TP_SITE_ID_LID');
4082: END IF;
4083: END IF;
4084: lv_tp_stat_stale := MSC_UTIL.SYS_YES ;
4085: lv_tp_site_stat_stale := MSC_UTIL.SYS_YES ;

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

4105: -- We do not delete data if the profile "MSC_COLLECTION_WINDOW_FOR_TP_CHANGES" is set to not null.
4106: IF lv_msc_tp_coll_window = 0 THEN
4107: IF lv_control_flag = 2 THEN
4108: DELETE MSC_TP_ID_LID WHERE SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id and partner_type in (1,2);
4109: DELETE MSC_TP_SITE_ID_LID WHERE SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id;
4110: DELETE MSC_TP_ID_LID WHERE SR_INSTANCE_ID= -1 and partner_type in (1,2);
4111: DELETE MSC_TP_SITE_ID_LID WHERE SR_INSTANCE_ID= -1;
4112: ELSE
4113: MSC_CL_COLLECTION.TRUNCATE_MSC_TABLE( 'MSC_TP_ID_LID');

Line 4111: DELETE MSC_TP_SITE_ID_LID WHERE SR_INSTANCE_ID= -1;

4107: IF lv_control_flag = 2 THEN
4108: DELETE MSC_TP_ID_LID WHERE SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id and partner_type in (1,2);
4109: DELETE MSC_TP_SITE_ID_LID WHERE SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id;
4110: DELETE MSC_TP_ID_LID WHERE SR_INSTANCE_ID= -1 and partner_type in (1,2);
4111: DELETE MSC_TP_SITE_ID_LID WHERE SR_INSTANCE_ID= -1;
4112: ELSE
4113: MSC_CL_COLLECTION.TRUNCATE_MSC_TABLE( 'MSC_TP_ID_LID');
4114: MSC_CL_COLLECTION.TRUNCATE_MSC_TABLE( 'MSC_TP_SITE_ID_LID');
4115: END IF;

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

4110: DELETE MSC_TP_ID_LID WHERE SR_INSTANCE_ID= -1 and partner_type in (1,2);
4111: DELETE MSC_TP_SITE_ID_LID WHERE SR_INSTANCE_ID= -1;
4112: ELSE
4113: MSC_CL_COLLECTION.TRUNCATE_MSC_TABLE( 'MSC_TP_ID_LID');
4114: MSC_CL_COLLECTION.TRUNCATE_MSC_TABLE( 'MSC_TP_SITE_ID_LID');
4115: END IF;
4116: lv_tp_stat_stale := MSC_UTIL.SYS_YES ;
4117: lv_tp_site_stat_stale := MSC_UTIL.SYS_YES ;
4118: END IF;

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

4533: END LOOP;
4534:
4535: COMMIT;
4536: lv_ins_records := 0;
4537: -- ==== Populate msc_tp_site_id_lid with new Supplier Sites ====
4538: IF MSC_CL_COLLECTION.v_apps_ver < MSC_UTIL.G_APPS115 THEN
4539:
4540: /* For 107 and 110 the vendor_id and vendor
4541: site id can be duplicate, therefore we use

Line 4549: INSERT INTO MSC_TP_SITE_ID_LID

4545: FOR c_rec IN c9 LOOP
4546:
4547: BEGIN
4548:
4549: INSERT INTO MSC_TP_SITE_ID_LID
4550: ( /* SCE Change starts */
4551: SR_COMPANY_ID,
4552: /* SCE Change ends */
4553: SR_TP_SITE_ID,

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

4569:
4570: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
4571: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
4572: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'GENERATE_TRADING_PARTNER_KEYS');
4573: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_TP_SITE_ID_LID');
4574: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
4575:
4576: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
4577: FND_MESSAGE.SET_TOKEN('COLUMN', 'PARTNER_TYPE');

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

4596:
4597: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
4598: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
4599: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'GENERATE_TRADING_PARTNER_KEYS');
4600: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_TP_SITE_ID_LID');
4601: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
4602:
4603: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
4604: FND_MESSAGE.SET_TOKEN('COLUMN', 'PARTNER_TYPE');

Line 4630: INSERT /+ APPEND / INTO MSC_TP_SITE_ID_LID

4626: END LOOP;
4627:
4628: ELSE
4629:
4630: INSERT /*+ APPEND */ INTO MSC_TP_SITE_ID_LID
4631: ( SR_COMPANY_ID,
4632: SR_TP_SITE_ID,
4633: SR_INSTANCE_ID,
4634: Partner_Type,

Line 4650: from MSC_TP_SITE_ID_LID mtsil

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

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

4666:
4667: COMMIT;
4668: /* Bug7679044 */
4669: IF lv_tp_site_stat_stale = MSC_UTIL.SYS_YES OR lv_ins_records > lv_tp_site_id_count * 0.2 THEN
4670: msc_analyse_tables_pk.analyse_table( 'MSC_TP_SITE_ID_LID');
4671: lv_tp_site_stat_stale := MSC_UTIL.SYS_NO;
4672: lv_tp_site_id_count := lv_tp_site_id_count + lv_ins_records;
4673: END IF;
4674:

Line 4769: INSERT INTO MSC_TP_SITE_ID_LID

4765: FOR c_rec IN c10 LOOP
4766:
4767: BEGIN
4768:
4769: INSERT INTO MSC_TP_SITE_ID_LID
4770: ( /* SCE Change starts*/
4771: SR_COMPANY_ID,
4772: /* SCE Change ends*/
4773: SR_TP_SITE_ID,

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

4790:
4791: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
4792: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
4793: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'GENERATE_TRADING_PARTNER_KEYS');
4794: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_TP_SITE_ID_LID');
4795: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
4796:
4797: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
4798: FND_MESSAGE.SET_TOKEN('COLUMN', 'PARTNER_TYPE');

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

4817:
4818: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
4819: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
4820: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'GENERATE_TRADING_PARTNER_KEYS');
4821: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_TP_SITE_ID_LID');
4822: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
4823:
4824: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
4825: FND_MESSAGE.SET_TOKEN('COLUMN', 'PARTNER_TYPE');

Line 4851: INSERT /+ APPEND / INTO MSC_TP_SITE_ID_LID

4847: END LOOP;
4848:
4849: ELSE
4850:
4851: INSERT /*+ APPEND */ INTO MSC_TP_SITE_ID_LID
4852: ( SR_COMPANY_ID,
4853: SR_TP_SITE_ID,
4854: SR_INSTANCE_ID,
4855: Partner_Type,

Line 4871: from MSC_TP_SITE_ID_LID mtsil

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

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

4890:
4891: COMMIT;
4892: /* Bug7679044 */
4893: IF lv_tp_site_stat_stale = MSC_UTIL.SYS_YES OR lv_ins_records > lv_tp_site_id_count * 0.2 THEN
4894: msc_analyse_tables_pk.analyse_table( 'MSC_TP_SITE_ID_LID');
4895: lv_tp_site_stat_stale := MSC_UTIL.SYS_NO;
4896: lv_tp_site_id_count := lv_tp_site_id_count + lv_ins_records;
4897: END IF;
4898:

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

5080: IF lv_tp_stat_stale = MSC_UTIL.SYS_YES THEN
5081: msc_analyse_tables_pk.analyse_table( 'MSC_TP_ID_LID');
5082: END IF;
5083: IF lv_tp_site_stat_stale = MSC_UTIL.SYS_YES THEN
5084: msc_analyse_tables_pk.analyse_table( 'MSC_TP_SITE_ID_LID');
5085: END IF;
5086:
5087: EXCEPTION
5088: