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_GET_NAME dependencies on MSC_USER_EXCEPTION_COMPONENTS

Line 2895: from msc_user_exception_components muec,

2891: select decode(exception_column,
2892: 'DATE1',date1,'DATE2',date2,'DATE3',date3,'DATE4',date4,
2893: 'DATE5',date5,'DATE6',date6,'DATE7',date7)
2894: into l_date
2895: from msc_user_exception_components muec,
2896: msc_x_exception_details mxed
2897: where muec.exception_id = mxed.exception_type
2898: and mxed.exception_detail_id = arg_exception_id
2899: and muec.component_type = 1

Line 2918: from msc_user_exception_components muec,

2914:
2915: select decode(muec.exception_column, 'NUMBER1',NUMBER1,'NUMBER2',NUMBER2,
2916: 'NUMBER3',NUMBER3,'NUMBER4',NUMBER4,'NUMBER5',NUMBER5,'NUMBER6',NUMBER6,'NUMBER7',NUMBER7)
2917: into l_temp
2918: from msc_user_exception_components muec,
2919: msc_x_exception_details mxed
2920: where muec.exception_id = mxed.exception_type
2921: and mxed.exception_detail_id = arg_exception_id
2922: and muec.component_type = 1

Line 2944: from msc_user_exception_components muec,

2940: 'USER_ATTRIBUTE3',USER_ATTRIBUTE3,'USER_ATTRIBUTE4',USER_ATTRIBUTE4,
2941: 'USER_ATTRIBUTE5',USER_ATTRIBUTE5,'USER_ATTRIBUTE6',USER_ATTRIBUTE6,
2942: 'USER_ATTRIBUTE7',USER_ATTRIBUTE7)
2943: into l_temp
2944: from msc_user_exception_components muec,
2945: msc_x_exception_details mxed
2946: where muec.exception_id = mxed.exception_type
2947: and mxed.exception_detail_id = arg_exception_id
2948: and muec.component_type = 1

Line 2968: from msc_user_exception_components muec,

2964: select decode(muec.exception_column, 'NUMBER1',NUMBER1,'NUMBER2',NUMBER2,
2965: 'NUMBER3',NUMBER3,'NUMBER4',NUMBER4,'NUMBER5',NUMBER5,
2966: 'NUMBER6',NUMBER6,'NUMBER7',NUMBER7)
2967: into l_temp
2968: from msc_user_exception_components muec,
2969: msc_x_exception_details mxed
2970: where muec.exception_id = mxed.exception_type
2971: and mxed.exception_detail_id = arg_exception_id
2972: and muec.component_type = 1

Line 2991: from msc_user_exception_components muec,

2987:
2988: select decode(muec.exception_column, 'DATE1',date1,'DATE2',date2,'DATE3',date3,
2989: 'DATE4',date4,'DATE5',date5,'DATE6',date6,'DATE7',date7)
2990: into l_temp
2991: from msc_user_exception_components muec,
2992: msc_x_exception_details mxed
2993: where muec.exception_id = mxed.exception_type
2994: and mxed.exception_detail_id = arg_exception_id
2995: and muec.component_type = 1

Line 3014: from msc_user_exception_components muec,

3010:
3011: select decode(muec.exception_column, 'DATE1',date1,'DATE2',date2,'DATE3',date3,
3012: 'DATE4',date4,'DATE5',date5,'DATE6',date6,'DATE7',date7)
3013: into l_temp
3014: from msc_user_exception_components muec,
3015: msc_x_exception_details mxed
3016: where muec.exception_id = mxed.exception_type
3017: and muec.exception_id = arg_exception_id
3018: and mxed.exception_detail_id = arg_exception_id