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.

VIEW: APPS.PAY_RUN_TYPE_USAGES_V

Source

View Text - Preformatted


SELECT rtu.run_type_usage_id , rtu.parent_run_type_id ,rtu.child_run_type_id ,rtu.effective_start_date ,rtu.effective_end_date ,rtu.sequence ,rtu.object_version_number ,rtu.business_group_id ,rtu.legislation_code ,tl_p.run_type_name ,tl_p.shortname ,prt_p.run_method ,tl_c.run_type_name ,tl_c.shortname ,prt_c.run_method ,hl.meaning from pay_run_type_usages_f rtu ,pay_run_types_f prt_p ,pay_run_types_f prt_c ,pay_run_types_f_tl tl_p ,pay_run_types_f_tl tl_c ,fnd_sessions fs ,hr_lookups hl where rtu.parent_run_type_id = prt_p.run_type_id and prt_p.run_type_id = tl_p.run_type_id and tl_p.language = userenv('LANG') and rtu.child_run_type_id = prt_c.run_type_id and prt_c.run_type_id = tl_c.run_type_id and tl_c.language = userenv('LANG') and hl.lookup_type = 'RUN_METHOD' and hl.lookup_code = prt_c.run_method and fs.session_id = userenv('sessionid') and fs.effective_date between rtu.effective_start_date and rtu.effective_end_date and fs.effective_date between prt_p.effective_start_date and prt_p.effective_end_date and fs.effective_date between prt_c.effective_start_date and prt_c.effective_end_date

View Text - HTML Formatted

SELECT RTU.RUN_TYPE_USAGE_ID
, RTU.PARENT_RUN_TYPE_ID
, RTU.CHILD_RUN_TYPE_ID
, RTU.EFFECTIVE_START_DATE
, RTU.EFFECTIVE_END_DATE
, RTU.SEQUENCE
, RTU.OBJECT_VERSION_NUMBER
, RTU.BUSINESS_GROUP_ID
, RTU.LEGISLATION_CODE
, TL_P.RUN_TYPE_NAME
, TL_P.SHORTNAME
, PRT_P.RUN_METHOD
, TL_C.RUN_TYPE_NAME
, TL_C.SHORTNAME
, PRT_C.RUN_METHOD
, HL.MEANING
FROM PAY_RUN_TYPE_USAGES_F RTU
, PAY_RUN_TYPES_F PRT_P
, PAY_RUN_TYPES_F PRT_C
, PAY_RUN_TYPES_F_TL TL_P
, PAY_RUN_TYPES_F_TL TL_C
, FND_SESSIONS FS
, HR_LOOKUPS HL
WHERE RTU.PARENT_RUN_TYPE_ID = PRT_P.RUN_TYPE_ID
AND PRT_P.RUN_TYPE_ID = TL_P.RUN_TYPE_ID
AND TL_P.LANGUAGE = USERENV('LANG')
AND RTU.CHILD_RUN_TYPE_ID = PRT_C.RUN_TYPE_ID
AND PRT_C.RUN_TYPE_ID = TL_C.RUN_TYPE_ID
AND TL_C.LANGUAGE = USERENV('LANG')
AND HL.LOOKUP_TYPE = 'RUN_METHOD'
AND HL.LOOKUP_CODE = PRT_C.RUN_METHOD
AND FS.SESSION_ID = USERENV('SESSIONID')
AND FS.EFFECTIVE_DATE BETWEEN RTU.EFFECTIVE_START_DATE
AND RTU.EFFECTIVE_END_DATE
AND FS.EFFECTIVE_DATE BETWEEN PRT_P.EFFECTIVE_START_DATE
AND PRT_P.EFFECTIVE_END_DATE
AND FS.EFFECTIVE_DATE BETWEEN PRT_C.EFFECTIVE_START_DATE
AND PRT_C.EFFECTIVE_END_DATE