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.HXC_APP_PERIOD_TOTAL_TIME_V

Source

View Text - Preformatted


SELECT htb.time_building_block_id time_id , htb.resource_id , htb_day.time_building_block_id day_id , htb_detail.time_building_block_id detail_id , htb.Approval_Status status_code , SUBSTR(HR_GENERAL.DECODE_LOOKUP('HXC_APPROVAL_STATUS', htb.Approval_Status),1,80) status_name , to_date(to_char(htb_day.start_time,'DD-MON-YYYY'),'DD-MON-YYYY') start_date , to_date(to_char(htb_day.stop_time,'DD-MON-YYYY'),'DD-MON-YYYY') stop_date , SUM(NVL(hxc_time_category_utils_pkg.category_detail_hrs( htb_Detail.time_building_block_id, htb_detail.object_version_number),0)) hours_worked , ap.application_period_id FROM hxc_time_building_blocks htb, hxc_time_building_blocks htb_day, hxc_time_building_blocks htb_detail, hxc_ap_detail_links ap WHERE htb_day.time_building_block_id=htb_detail.parent_building_block_id and htb.time_building_block_id=htb_day.parent_building_block_id and htb_detail.scope='DETAIL' and htb_detail.date_to=hr_general.end_of_time and htb_day.scope='DAY' and htb_day.type='RANGE' and htb_day.date_to=hr_general.end_of_time and htb.scope='TIMECARD' and htb.resource_type='PERSON' and htb.type='RANGE' and htb.date_to=hr_general.end_of_time and ap.time_building_block_id = htb_detail.time_building_block_id and ap.time_building_block_ovn = htb_detail.object_version_number Group by htb.time_building_block_id , htb.resource_id , htb_day.time_building_block_id, htb_detail.time_building_block_id, htb.Approval_Status, HR_GENERAL.DECODE_LOOKUP('HXC_APPROVAL_STATUS', htb.Approval_Status), to_date(to_char(htb_day.start_time,'DD-MON-YYYY'),'DD-MON-YYYY'), to_date(to_char(htb_day.stop_time,'DD-MON-YYYY'),'DD-MON-YYYY'), ap.application_period_id

View Text - HTML Formatted

SELECT HTB.TIME_BUILDING_BLOCK_ID TIME_ID
, HTB.RESOURCE_ID
, HTB_DAY.TIME_BUILDING_BLOCK_ID DAY_ID
, HTB_DETAIL.TIME_BUILDING_BLOCK_ID DETAIL_ID
, HTB.APPROVAL_STATUS STATUS_CODE
, SUBSTR(HR_GENERAL.DECODE_LOOKUP('HXC_APPROVAL_STATUS'
, HTB.APPROVAL_STATUS)
, 1
, 80) STATUS_NAME
, TO_DATE(TO_CHAR(HTB_DAY.START_TIME
, 'DD-MON-YYYY')
, 'DD-MON-YYYY') START_DATE
, TO_DATE(TO_CHAR(HTB_DAY.STOP_TIME
, 'DD-MON-YYYY')
, 'DD-MON-YYYY') STOP_DATE
, SUM(NVL(HXC_TIME_CATEGORY_UTILS_PKG.CATEGORY_DETAIL_HRS( HTB_DETAIL.TIME_BUILDING_BLOCK_ID
, HTB_DETAIL.OBJECT_VERSION_NUMBER)
, 0)) HOURS_WORKED
, AP.APPLICATION_PERIOD_ID
FROM HXC_TIME_BUILDING_BLOCKS HTB
, HXC_TIME_BUILDING_BLOCKS HTB_DAY
, HXC_TIME_BUILDING_BLOCKS HTB_DETAIL
, HXC_AP_DETAIL_LINKS AP
WHERE HTB_DAY.TIME_BUILDING_BLOCK_ID=HTB_DETAIL.PARENT_BUILDING_BLOCK_ID
AND HTB.TIME_BUILDING_BLOCK_ID=HTB_DAY.PARENT_BUILDING_BLOCK_ID
AND HTB_DETAIL.SCOPE='DETAIL'
AND HTB_DETAIL.DATE_TO=HR_GENERAL.END_OF_TIME
AND HTB_DAY.SCOPE='DAY'
AND HTB_DAY.TYPE='RANGE'
AND HTB_DAY.DATE_TO=HR_GENERAL.END_OF_TIME
AND HTB.SCOPE='TIMECARD'
AND HTB.RESOURCE_TYPE='PERSON'
AND HTB.TYPE='RANGE'
AND HTB.DATE_TO=HR_GENERAL.END_OF_TIME
AND AP.TIME_BUILDING_BLOCK_ID = HTB_DETAIL.TIME_BUILDING_BLOCK_ID
AND AP.TIME_BUILDING_BLOCK_OVN = HTB_DETAIL.OBJECT_VERSION_NUMBER GROUP BY HTB.TIME_BUILDING_BLOCK_ID
, HTB.RESOURCE_ID
, HTB_DAY.TIME_BUILDING_BLOCK_ID
, HTB_DETAIL.TIME_BUILDING_BLOCK_ID
, HTB.APPROVAL_STATUS
, HR_GENERAL.DECODE_LOOKUP('HXC_APPROVAL_STATUS'
, HTB.APPROVAL_STATUS)
, TO_DATE(TO_CHAR(HTB_DAY.START_TIME
, 'DD-MON-YYYY')
, 'DD-MON-YYYY')
, TO_DATE(TO_CHAR(HTB_DAY.STOP_TIME
, 'DD-MON-YYYY')
, 'DD-MON-YYYY')
, AP.APPLICATION_PERIOD_ID