View: HXC_APPR_REJECTION_COMMENTS_V

Product:	HXC - Time and Labor Engine
Description:
Implementation/DBA Data:	APPS.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