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 2102: FROM MSC_TP_ID_LID tilc,

2098: mst.CHART_OF_ACCOUNTS_ID,
2099: mst.BUSINESS_GROUP_NAME,
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,

Line 2103: MSC_TP_ID_LID tils,

2099: mst.BUSINESS_GROUP_NAME,
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

Line 2156: FROM MSC_TP_ID_LID til,

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

Line 2185: FROM MSC_TP_ID_LID til,

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

Line 3710: FROM MSC_TP_ID_LID mtil,

3706: mst.PROJECT_REFERENCE_ENABLED,
3707: mst.PROJECT_CONTROL_LEVEL,
3708: mst.CUSTOMER_CLASS_CODE,
3709: mst.CUSTOMER_TYPE
3710: FROM MSC_TP_ID_LID mtil,
3711: MSC_ST_TRADING_PARTNERS mst
3712: WHERE mtil.SR_TP_ID= mst.SR_TP_ID
3713: AND mtil.SR_INSTANCE_ID= mst.SR_INSTANCE_ID
3714: AND mst.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id

Line 3809: MSC_TP_ID_LID mtil

3805:
3806: Cursor c6 IS
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)

Line 3833: MSC_TP_ID_LID mtil

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

Line 3860: MSC_TP_ID_LID mtil,

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

Line 3892: MSC_TP_ID_LID mtil,

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

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

3912: AND mtp.partner_type = mtil.partner_type
3913: AND mtil.Partner_Type= msts.partner_type
3914: AND msts.Partner_Type= 2;
3915:
3916: -- ============ Cursor for populating msc_tp_id_lid ==================== --
3917: CURSOR c12 IS
3918: SELECT distinct
3919: /* SCE Change starts */
3920: nvl(mst.company_id, -1) SR_COMPANY_ID,

Line 3932: from MSC_TP_ID_LID mtil

3928: /* SCE Change starts */
3929: msc_companies mc
3930: /* SCE Change ends */
3931: WHERE NOT EXISTS( select 1
3932: from MSC_TP_ID_LID mtil
3933: where mst.SR_TP_ID= mtil.SR_TP_ID
3934: and mst.SR_INSTANCE_ID= mtil.SR_INSTANCE_ID
3935: and mst.Partner_Type= mtil.Partner_Type
3936: -- SCE Change

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

3948: -- AND nvl( mst.company_id, -1) = -1; -- commented for aerox
3949: /* SCE Change ends */
3950:
3951:
3952: -- ============ Cursor for UPDATE MSC_TP_ID_LID SRP Changes ==================== --
3953: CURSOR c13 IS
3954: Select resource_type, sr_instance_id , partner_type,sr_tp_id
3955: From msc_st_trading_partners
3956: Where sr_instance_id = MSC_CL_COLLECTION.v_instance_id

Line 3998: where table_name = 'MSC_TP_ID_LID';

3994: begin
3995: select num_rows,decode (stale_stats,'NO', MSC_UTIL.SYS_NO, MSC_UTIL.SYS_YES )
3996: into lv_tp_id_count, lv_tp_stat_stale
3997: from dba_TAB_STATISTICS
3998: where table_name = 'MSC_TP_ID_LID';
3999: exception when no_data_found then
4000: lv_tp_stat_stale := MSC_UTIL.SYS_YES ;
4001: end;
4002:

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

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

Line 4019: DELETE MSC_TP_ID_LID WHERE SR_INSTANCE_ID= -1;

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

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

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

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

4033:
4034: /*************** PREPLACE CHANGE START *****************/
4035:
4036:
4037: --In case of continuous and targetted collections, delete carrier records from MSC_TP_ID_LID
4038: --when sourcing SRS launch parameter is Yes --and delete supplier and customer records
4039: --from MSC_TP_ID_LID when either Supplier or Customer SRS launch parameter is Yes.
4040:
4041: IF (MSC_CL_COLLECTION.v_is_partial_refresh OR MSC_CL_COLLECTION.V_IS_CONT_REFRESH) THEN

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

4035:
4036:
4037: --In case of continuous and targetted collections, delete carrier records from MSC_TP_ID_LID
4038: --when sourcing SRS launch parameter is Yes --and delete supplier and customer records
4039: --from MSC_TP_ID_LID when either Supplier or Customer SRS launch parameter is Yes.
4040:
4041: IF (MSC_CL_COLLECTION.v_is_partial_refresh OR MSC_CL_COLLECTION.V_IS_CONT_REFRESH) THEN
4042: IF (MSC_CL_COLLECTION.v_coll_prec.sourcing_rule_flag=MSC_UTIL.SYS_YES) THEN
4043: DELETE MSC_TP_ID_LID WHERE SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id and partner_type=4;

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

4039: --from MSC_TP_ID_LID when either Supplier or Customer SRS launch parameter is Yes.
4040:
4041: IF (MSC_CL_COLLECTION.v_is_partial_refresh OR MSC_CL_COLLECTION.V_IS_CONT_REFRESH) THEN
4042: IF (MSC_CL_COLLECTION.v_coll_prec.sourcing_rule_flag=MSC_UTIL.SYS_YES) THEN
4043: DELETE MSC_TP_ID_LID WHERE SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id and partner_type=4;
4044: DELETE MSC_TP_ID_LID WHERE SR_INSTANCE_ID= -1 and partner_type=4;
4045: lv_tp_stat_stale := MSC_UTIL.SYS_YES ;
4046: END IF;
4047: END IF;

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

4040:
4041: IF (MSC_CL_COLLECTION.v_is_partial_refresh OR MSC_CL_COLLECTION.V_IS_CONT_REFRESH) THEN
4042: IF (MSC_CL_COLLECTION.v_coll_prec.sourcing_rule_flag=MSC_UTIL.SYS_YES) THEN
4043: DELETE MSC_TP_ID_LID WHERE SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id and partner_type=4;
4044: DELETE MSC_TP_ID_LID WHERE SR_INSTANCE_ID= -1 and partner_type=4;
4045: lv_tp_stat_stale := MSC_UTIL.SYS_YES ;
4046: END IF;
4047: END IF;
4048:

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

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

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

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

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

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

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

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

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

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

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

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

Line 4189: UPDATE MSC_TP_ID_LID

4185: WHERE PARTNER_ID = lv_old_partner_id
4186: AND SR_INSTANCE_ID = c_rec.SR_INSTANCE_ID
4187: AND PARTNER_TYPE = c_rec.PARTNER_TYPE;
4188:
4189: UPDATE MSC_TP_ID_LID
4190: SET TP_ID = lv_new_partner_id
4191: WHERE SR_TP_ID = c_rec.SR_TP_ID
4192: AND SR_INSTANCE_ID = c_rec.SR_INSTANCE_ID
4193: AND PARTNER_TYPE = c_rec.PARTNER_TYPE;

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

4297:
4298: COMMIT;
4299:
4300: lv_ins_records := 0;
4301: -- ==== populate msc_tp_id_lid with newly created Suppliers / Customers ====
4302: IF MSC_CL_COLLECTION.v_apps_ver < MSC_UTIL.G_APPS115 AND MSC_CL_COLLECTION.v_apps_ver <> -1 THEN
4303:
4304: /* For 107 and 110 the vendor_id and vendor
4305: site id can be duplicate, therefore we use

Line 4313: INSERT INTO MSC_TP_ID_LID

4309: FOR c_rec IN c12 LOOP
4310:
4311: BEGIN
4312:
4313: INSERT INTO MSC_TP_ID_LID
4314: ( /* SCE Change starts */
4315: SR_COMPANY_ID,
4316: /* SCE change ends */
4317: SR_TP_ID,

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

4333:
4334: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
4335: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
4336: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'GENERATE_TRADING_PARTNER_KEYS');
4337: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_TP_ID_LID');
4338: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
4339:
4340: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
4341: FND_MESSAGE.SET_TOKEN('COLUMN', 'SR_TP_ID');

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

4364:
4365: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
4366: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
4367: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'GENERATE_TRADING_PARTNER_KEYS');
4368: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_TP_ID_LID');
4369: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
4370:
4371: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
4372: FND_MESSAGE.SET_TOKEN('COLUMN', 'SR_TP_ID');

Line 4398: INSERT /+ APPEND / INTO MSC_TP_ID_LID

4394: END LOOP;
4395:
4396: ELSE
4397:
4398: INSERT /*+ APPEND */ INTO MSC_TP_ID_LID
4399: ( SR_COMPANY_ID,
4400: SR_TP_ID,
4401: SR_INSTANCE_ID,
4402: Partner_Type,

Line 4418: from MSC_TP_ID_LID mtil

4414: FROM MSC_ST_TRADING_PARTNERS mst,
4415: MSC_TRADING_PARTNERS mtp,
4416: MSC_COMPANIES mc
4417: WHERE NOT EXISTS( select 1
4418: from MSC_TP_ID_LID mtil
4419: where mst.SR_TP_ID= mtil.SR_TP_ID
4420: and mst.SR_INSTANCE_ID= mtil.SR_INSTANCE_ID
4421: and nvl( mst.company_id, -1) = nvl(mtil.sr_company_id, -1)
4422: and nvl( mst.company_id, -1) = -1

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

4433:
4434: COMMIT;
4435: /* Bug7679044 */
4436: IF lv_tp_stat_stale = MSC_UTIL.SYS_YES OR lv_ins_records > lv_tp_id_count * 0.2 THEN
4437: msc_analyse_tables_pk.analyse_table( 'MSC_TP_ID_LID');
4438: lv_tp_stat_stale := MSC_UTIL.SYS_NO;
4439: lv_tp_id_count := lv_tp_id_count + lv_ins_records;
4440: END IF;
4441:

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

4438: lv_tp_stat_stale := MSC_UTIL.SYS_NO;
4439: lv_tp_id_count := lv_tp_id_count + lv_ins_records;
4440: END IF;
4441:
4442: -- ==== Update msc_tp_id_lid with resource_type ==== SRP Changes
4443: FOR c_rec IN c13 LOOP
4444: BEGIN
4445:
4446: UPDATE MSC_TP_ID_LID

Line 4446: UPDATE MSC_TP_ID_LID

4442: -- ==== Update msc_tp_id_lid with resource_type ==== SRP Changes
4443: FOR c_rec IN c13 LOOP
4444: BEGIN
4445:
4446: UPDATE MSC_TP_ID_LID
4447: set
4448: resource_type = c_rec.resource_type
4449: WHERE sr_tp_id= c_rec.sr_tp_id And
4450: partner_type=2 And

Line 4637: MSC_TP_ID_LID mtil,

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

Line 4858: MSC_TP_ID_LID mtil,

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

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

5067: COMMIT;
5068:
5069: /* analyse the key mapping tables */
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;