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_AHL_ODS_LOAD dependencies on MSC_ST_VISITS

Line 22: FROM MSC_ST_VISITS msv

18: msv.VISIT_PRIORITY,
19: msv.VISIT_STATUS,
20: msv.VISIT_NUMBER,
21: msv.SR_INSTANCE_ID
22: FROM MSC_ST_VISITS msv
23: WHERE msv.deleted_flag = MSC_UTIL.SYS_NO
24: AND msv.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id;
25:
26: CURSOR c_del IS

Line 30: FROM MSC_ST_VISITS msv

26: CURSOR c_del IS
27: SELECT msv.VISIT_ID,
28: msv.ORGANIZATION_ID,
29: msv.SR_INSTANCE_ID
30: FROM MSC_ST_VISITS msv
31: WHERE msv.deleted_flag = MSC_UTIL.SYS_YES
32: AND msv.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id;
33:
34: BEGIN

Line 96: ||' FROM MSC_ST_VISITS msv '

92: ||':v_current_date,'
93: ||':v_current_user,'
94: ||':v_current_date,'
95: ||':v_current_user'
96: ||' FROM MSC_ST_VISITS msv '
97: ||'WHERE msv.deleted_flag = '||MSC_UTIL.SYS_NO
98: ||' AND msv.SR_INSTANCE_ID= '
99: ||MSC_CL_COLLECTION.v_instance_id;
100: