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_COLLECTION dependencies on MSC_SOURCING_HISTORY

Line 4360: -- So we can safely truncate the msc_sourcing_history table to improve performance

4356: SELECT DECODE(nvl(FND_PROFILE.VALUE('MSC_PURGE_ST_CONTROL'),'N'),'Y',1,2)
4357: INTO lv_delete_flag
4358: FROM DUAL;
4359: -- If the above profile option is set then we are assuming that there is only one source
4360: -- So we can safely truncate the msc_sourcing_history table to improve performance
4361: IF (lv_delete_flag = 2) THEN
4362: DELETE MSC_SOURCING_HISTORY
4363: WHERE SR_INSTANCE_ID = v_instance_id;
4364: ELSE

Line 4362: DELETE MSC_SOURCING_HISTORY

4358: FROM DUAL;
4359: -- If the above profile option is set then we are assuming that there is only one source
4360: -- So we can safely truncate the msc_sourcing_history table to improve performance
4361: IF (lv_delete_flag = 2) THEN
4362: DELETE MSC_SOURCING_HISTORY
4363: WHERE SR_INSTANCE_ID = v_instance_id;
4364: ELSE
4365: TRUNCATE_MSC_TABLE('MSC_SOURCING_HISTORY');
4366: END IF;

Line 4365: TRUNCATE_MSC_TABLE('MSC_SOURCING_HISTORY');

4361: IF (lv_delete_flag = 2) THEN
4362: DELETE MSC_SOURCING_HISTORY
4363: WHERE SR_INSTANCE_ID = v_instance_id;
4364: ELSE
4365: TRUNCATE_MSC_TABLE('MSC_SOURCING_HISTORY');
4366: END IF;
4367:
4368: COMMIT;
4369:

Line 4370: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'Table MSC_SOURCING_HISTORY Deleted');

4366: END IF;
4367:
4368: COMMIT;
4369:
4370: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'Table MSC_SOURCING_HISTORY Deleted');
4371:
4372: END IF;
4373:
4374: IF pRECALC_SH= MSC_UTIL.SYS_YES THEN

Line 6143: DELETE MSC_SOURCING_HISTORY

6139: INTO lv_delete_flag
6140: FROM DUAL;
6141:
6142: IF (lv_delete_flag = 2) THEN
6143: DELETE MSC_SOURCING_HISTORY
6144: WHERE SR_INSTANCE_ID= v_instance_id;
6145: ELSE
6146: TRUNCATE_MSC_TABLE('MSC_SOURCING_HISTORY');
6147: END IF;

Line 6146: TRUNCATE_MSC_TABLE('MSC_SOURCING_HISTORY');

6142: IF (lv_delete_flag = 2) THEN
6143: DELETE MSC_SOURCING_HISTORY
6144: WHERE SR_INSTANCE_ID= v_instance_id;
6145: ELSE
6146: TRUNCATE_MSC_TABLE('MSC_SOURCING_HISTORY');
6147: END IF;
6148:
6149: COMMIT;
6150:

Line 6151: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'Table MSC_SOURCING_HISTORY Deleted');

6147: END IF;
6148:
6149: COMMIT;
6150:
6151: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'Table MSC_SOURCING_HISTORY Deleted');
6152: END IF;
6153:
6154: IF ((pRECALC_SH=MSC_UTIL.SYS_YES) AND (v_coll_prec.source_hist_flag=MSC_UTIL.SYS_YES)) THEN
6155: