VIEW: APPS.HXC_APPR_REJECTION_COMMENTS_V

Source

View Text - Preformatted

SELECT ps.resource_id, ps.start_time, ps.stop_time, tb.comment_text, ts.timecard_id, ts.timecard_ovn from hxc_app_period_summary ps ,hxc_time_building_blocks tb ,hxc_tc_ap_links lnk ,hxc_timecard_summary ts WHERE ps.application_period_id = tb.time_building_block_id and ps.application_period_ovn = tb.object_version_number and ps.approval_status = 'REJECTED' and ps.notification_status = 'FINISHED' and lnk.application_period_id = ps.application_period_id and lnk.timecard_id = ts.timecard_id

View Text - HTML Formatted

SELECT PS.RESOURCE_ID
, PS.START_TIME
, PS.STOP_TIME
, TB.COMMENT_TEXT
, TS.TIMECARD_ID
, TS.TIMECARD_OVN
FROM HXC_APP_PERIOD_SUMMARY PS
, HXC_TIME_BUILDING_BLOCKS TB
, HXC_TC_AP_LINKS LNK
, HXC_TIMECARD_SUMMARY TS
WHERE PS.APPLICATION_PERIOD_ID = TB.TIME_BUILDING_BLOCK_ID
AND PS.APPLICATION_PERIOD_OVN = TB.OBJECT_VERSION_NUMBER
AND PS.APPROVAL_STATUS = 'REJECTED'
AND PS.NOTIFICATION_STATUS = 'FINISHED'
AND LNK.APPLICATION_PERIOD_ID = PS.APPLICATION_PERIOD_ID
AND LNK.TIMECARD_ID = TS.TIMECARD_ID