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_ID_LID

Line 335: FROM MSC_TP_ID_LID til,

331: mtil.TP_ID CARRIER_PARTNER_ID,
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

Line 338: MSC_TP_ID_LID mtil

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
341: AND til.PARTNER_TYPE(+)= msca.PARTNER_TYPE
342: AND tsil.SR_INSTANCE_ID(+)= msca.SR_INSTANCE_ID

Line 2108: FROM MSC_TP_ID_LID tilc,

2104: mst.BUSINESS_GROUP_NAME,
2105: mst.LEGAL_ENTITY_NAME,
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,

Line 2109: MSC_TP_ID_LID tils,

2105: mst.LEGAL_ENTITY_NAME,
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

Line 2162: FROM MSC_TP_ID_LID til,

2158: til.TP_ID PARTNER_ID,
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

Line 2191: FROM MSC_TP_ID_LID til,

2187: pc.EMAIL,
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)

Line 3720: FROM MSC_TP_ID_LID mtil,

3716: mst.PROJECT_REFERENCE_ENABLED,
3717: mst.PROJECT_CONTROL_LEVEL,
3718: mst.CUSTOMER_CLASS_CODE,
3719: mst.CUSTOMER_TYPE
3720: FROM MSC_TP_ID_LID mtil,
3721: MSC_ST_TRADING_PARTNERS mst
3722: WHERE mtil.SR_TP_ID= mst.SR_TP_ID
3723: AND mtil.SR_INSTANCE_ID= mst.SR_INSTANCE_ID
3724: AND mst.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id

Line 3819: MSC_TP_ID_LID mtil

3815:
3816: Cursor c6 IS
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)

Line 3843: MSC_TP_ID_LID mtil

3839: msts.Operating_Unit_Name,
3840: msts.TP_Site_Code,
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, ' ')

Line 3870: MSC_TP_ID_LID mtil,

3866: msts.SR_TP_SITE_ID,
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

Line 3902: MSC_TP_ID_LID mtil,

3898: msts.SR_TP_SITE_ID,
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

Line 3926: -- ============ Cursor for populating msc_tp_id_lid ==================== --

3922: AND mtp.partner_type = mtil.partner_type
3923: AND mtil.Partner_Type= msts.partner_type
3924: AND msts.Partner_Type= 2;
3925:
3926: -- ============ Cursor for populating msc_tp_id_lid ==================== --
3927: CURSOR c12 IS
3928: SELECT distinct
3929: /* SCE Change starts */
3930: nvl(mst.company_id, -1) SR_COMPANY_ID,

Line 3942: from MSC_TP_ID_LID mtil

3938: /* SCE Change starts */
3939: msc_companies mc
3940: /* SCE Change ends */
3941: WHERE NOT EXISTS( select 1
3942: from MSC_TP_ID_LID mtil
3943: where mst.SR_TP_ID= mtil.SR_TP_ID
3944: and mst.SR_INSTANCE_ID= mtil.SR_INSTANCE_ID
3945: and mst.Partner_Type= mtil.Partner_Type
3946: -- SCE Change

Line 3962: -- ============ Cursor for UPDATE MSC_TP_ID_LID SRP Changes ==================== --

3958: -- AND nvl( mst.company_id, -1) = -1; -- commented for aerox
3959: /* SCE Change ends */
3960:
3961:
3962: -- ============ Cursor for UPDATE MSC_TP_ID_LID SRP Changes ==================== --
3963: CURSOR c13 IS
3964: Select resource_type, sr_instance_id , partner_type,sr_tp_id
3965: From msc_st_trading_partners
3966: Where sr_instance_id = MSC_CL_COLLECTION.v_instance_id

Line 4008: where table_name = 'MSC_TP_ID_LID';

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

Line 4027: DELETE MSC_TP_ID_LID WHERE SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id;

4023: IF MSC_CL_COLLECTION.v_is_complete_refresh THEN
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;

Line 4029: DELETE MSC_TP_ID_LID WHERE SR_INSTANCE_ID= -1;

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:
4033: ELSE

Line 4035: MSC_CL_COLLECTION.TRUNCATE_MSC_TABLE( 'MSC_TP_ID_LID');

4031: END IF;
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;

Line 4047: --In case of continuous and targetted collections, delete carrier records from MSC_TP_ID_LID

4043:
4044: /*************** PREPLACE CHANGE START *****************/
4045:
4046:
4047: --In case of continuous and targetted collections, delete carrier records from MSC_TP_ID_LID
4048: --when sourcing SRS launch parameter is Yes --and delete supplier and customer records
4049: --from MSC_TP_ID_LID when either Supplier or Customer SRS launch parameter is Yes.
4050:
4051: IF (MSC_CL_COLLECTION.v_is_partial_refresh OR MSC_CL_COLLECTION.V_IS_CONT_REFRESH) THEN

Line 4049: --from MSC_TP_ID_LID when either Supplier or Customer SRS launch parameter is Yes.

4045:
4046:
4047: --In case of continuous and targetted collections, delete carrier records from MSC_TP_ID_LID
4048: --when sourcing SRS launch parameter is Yes --and delete supplier and customer records
4049: --from MSC_TP_ID_LID when either Supplier or Customer SRS launch parameter is Yes.
4050:
4051: IF (MSC_CL_COLLECTION.v_is_partial_refresh OR MSC_CL_COLLECTION.V_IS_CONT_REFRESH) THEN
4052: IF (MSC_CL_COLLECTION.v_coll_prec.sourcing_rule_flag=MSC_UTIL.SYS_YES) THEN
4053: DELETE MSC_TP_ID_LID WHERE SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id and partner_type=4;

Line 4053: DELETE MSC_TP_ID_LID WHERE SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id and partner_type=4;

4049: --from MSC_TP_ID_LID when either Supplier or Customer SRS launch parameter is Yes.
4050:
4051: IF (MSC_CL_COLLECTION.v_is_partial_refresh OR MSC_CL_COLLECTION.V_IS_CONT_REFRESH) THEN
4052: IF (MSC_CL_COLLECTION.v_coll_prec.sourcing_rule_flag=MSC_UTIL.SYS_YES) THEN
4053: DELETE MSC_TP_ID_LID WHERE SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id and partner_type=4;
4054: DELETE MSC_TP_ID_LID WHERE SR_INSTANCE_ID= -1 and partner_type=4;
4055: lv_tp_stat_stale := MSC_UTIL.SYS_YES ;
4056: END IF;
4057: END IF;

Line 4054: DELETE MSC_TP_ID_LID WHERE SR_INSTANCE_ID= -1 and partner_type=4;

4050:
4051: IF (MSC_CL_COLLECTION.v_is_partial_refresh OR MSC_CL_COLLECTION.V_IS_CONT_REFRESH) THEN
4052: IF (MSC_CL_COLLECTION.v_coll_prec.sourcing_rule_flag=MSC_UTIL.SYS_YES) THEN
4053: DELETE MSC_TP_ID_LID WHERE SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id and partner_type=4;
4054: DELETE MSC_TP_ID_LID WHERE SR_INSTANCE_ID= -1 and partner_type=4;
4055: lv_tp_stat_stale := MSC_UTIL.SYS_YES ;
4056: END IF;
4057: END IF;
4058:

Line 4075: DELETE MSC_TP_ID_LID WHERE SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id and partner_type in (1,2);

4071: -- We do not delete data if the profile "MSC_COLLECTION_WINDOW_FOR_TP_CHANGES" is set to not null.
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

Line 4077: DELETE MSC_TP_ID_LID WHERE SR_INSTANCE_ID= -1 and partner_type in (1,2);

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');
4081: MSC_CL_COLLECTION.TRUNCATE_MSC_TABLE( 'MSC_TP_SITE_ID_LID');

Line 4080: MSC_CL_COLLECTION.TRUNCATE_MSC_TABLE( 'MSC_TP_ID_LID');

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;
4083: END IF;
4084: lv_tp_stat_stale := MSC_UTIL.SYS_YES ;

Line 4108: DELETE MSC_TP_ID_LID WHERE SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id and partner_type in (1,2);

4104: -- data using the partner_type as a filter.
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

Line 4110: DELETE MSC_TP_ID_LID WHERE SR_INSTANCE_ID= -1 and partner_type in (1,2);

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');
4114: MSC_CL_COLLECTION.TRUNCATE_MSC_TABLE( 'MSC_TP_SITE_ID_LID');

Line 4113: MSC_CL_COLLECTION.TRUNCATE_MSC_TABLE( 'MSC_TP_ID_LID');

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;
4116: lv_tp_stat_stale := MSC_UTIL.SYS_YES ;
4117: lv_tp_site_stat_stale := MSC_UTIL.SYS_YES ;

Line 4199: UPDATE MSC_TP_ID_LID

4195: WHERE PARTNER_ID = lv_old_partner_id
4196: AND SR_INSTANCE_ID = c_rec.SR_INSTANCE_ID
4197: AND PARTNER_TYPE = c_rec.PARTNER_TYPE;
4198:
4199: UPDATE MSC_TP_ID_LID
4200: SET TP_ID = lv_new_partner_id
4201: WHERE SR_TP_ID = c_rec.SR_TP_ID
4202: AND SR_INSTANCE_ID = c_rec.SR_INSTANCE_ID
4203: AND PARTNER_TYPE = c_rec.PARTNER_TYPE;

Line 4311: -- ==== populate msc_tp_id_lid with newly created Suppliers / Customers ====

4307:
4308: COMMIT;
4309:
4310: lv_ins_records := 0;
4311: -- ==== populate msc_tp_id_lid with newly created Suppliers / Customers ====
4312: IF MSC_CL_COLLECTION.v_apps_ver < MSC_UTIL.G_APPS115 AND MSC_CL_COLLECTION.v_apps_ver <> -1 THEN
4313:
4314: /* For 107 and 110 the vendor_id and vendor
4315: site id can be duplicate, therefore we use

Line 4323: INSERT INTO MSC_TP_ID_LID

4319: FOR c_rec IN c12 LOOP
4320:
4321: BEGIN
4322:
4323: INSERT INTO MSC_TP_ID_LID
4324: ( /* SCE Change starts */
4325: SR_COMPANY_ID,
4326: /* SCE change ends */
4327: SR_TP_ID,

Line 4347: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_TP_ID_LID');

4343:
4344: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
4345: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
4346: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'GENERATE_TRADING_PARTNER_KEYS');
4347: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_TP_ID_LID');
4348: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
4349:
4350: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
4351: FND_MESSAGE.SET_TOKEN('COLUMN', 'SR_TP_ID');

Line 4378: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_TP_ID_LID');

4374:
4375: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
4376: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
4377: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'GENERATE_TRADING_PARTNER_KEYS');
4378: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_TP_ID_LID');
4379: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
4380:
4381: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
4382: FND_MESSAGE.SET_TOKEN('COLUMN', 'SR_TP_ID');

Line 4408: INSERT /+ APPEND / INTO MSC_TP_ID_LID

4404: END LOOP;
4405:
4406: ELSE
4407:
4408: INSERT /*+ APPEND */ INTO MSC_TP_ID_LID
4409: ( SR_COMPANY_ID,
4410: SR_TP_ID,
4411: SR_INSTANCE_ID,
4412: Partner_Type,

Line 4428: from MSC_TP_ID_LID mtil

4424: FROM MSC_ST_TRADING_PARTNERS mst,
4425: MSC_TRADING_PARTNERS mtp,
4426: MSC_COMPANIES mc
4427: WHERE NOT EXISTS( select 1
4428: from MSC_TP_ID_LID mtil
4429: where mst.SR_TP_ID= mtil.SR_TP_ID
4430: and mst.SR_INSTANCE_ID= mtil.SR_INSTANCE_ID
4431: and nvl( mst.company_id, -1) = nvl(mtil.sr_company_id, -1)
4432: and nvl( mst.company_id, -1) = -1

Line 4447: msc_analyse_tables_pk.analyse_table( 'MSC_TP_ID_LID');

4443:
4444: COMMIT;
4445: /* Bug7679044 */
4446: IF lv_tp_stat_stale = MSC_UTIL.SYS_YES OR lv_ins_records > lv_tp_id_count * 0.2 THEN
4447: msc_analyse_tables_pk.analyse_table( 'MSC_TP_ID_LID');
4448: lv_tp_stat_stale := MSC_UTIL.SYS_NO;
4449: lv_tp_id_count := lv_tp_id_count + lv_ins_records;
4450: END IF;
4451:

Line 4452: -- ==== Update msc_tp_id_lid with resource_type ==== SRP Changes

4448: lv_tp_stat_stale := MSC_UTIL.SYS_NO;
4449: lv_tp_id_count := lv_tp_id_count + lv_ins_records;
4450: END IF;
4451:
4452: -- ==== Update msc_tp_id_lid with resource_type ==== SRP Changes
4453: FOR c_rec IN c13 LOOP
4454: BEGIN
4455:
4456: UPDATE MSC_TP_ID_LID

Line 4456: UPDATE MSC_TP_ID_LID

4452: -- ==== Update msc_tp_id_lid with resource_type ==== SRP Changes
4453: FOR c_rec IN c13 LOOP
4454: BEGIN
4455:
4456: UPDATE MSC_TP_ID_LID
4457: set
4458: resource_type = c_rec.resource_type
4459: WHERE sr_tp_id= c_rec.sr_tp_id And
4460: partner_type=2 And

Line 4647: MSC_TP_ID_LID mtil,

4643: msts.location_id,
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

Line 4868: MSC_TP_ID_LID mtil,

4864: msts.location_id,
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

Line 5081: msc_analyse_tables_pk.analyse_table( 'MSC_TP_ID_LID');

5077: COMMIT;
5078:
5079: /* analyse the key mapping tables */
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;