[Home] [Help]
View: HXC_APPR_REJECTION_COMMENTS_V
View Text
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
Columns
Name |
RESOURCE_ID |
START_TIME |
STOP_TIME |
COMMENT_TEXT |
TIMECARD_ID |
TIMECARD_OVN |