[Home] [Help]
View: SSP_STOPPAGES_V
Product: | SSP - SSP |
Description: | Base view for stoppages block in SSPWSENT module. |
Implementation/DBA Data: |
APPS.SSP_STOPPAGES_V
|
View Text
SELECT WRE.REASON
, STP.STOPPAGE_ID
, STP.OBJECT_VERSION_NUMBER
, STP.ABSENCE_ATTENDANCE_ID
, STP.MATERNITY_ID
, STP.REASON_ID
, STP.USER_ENTERED
, STP.OVERRIDE_STOPPAGE
, STP.EMPLOYEE_NOTIFIED
, STP.WITHHOLD_FROM
, STP.WITHHOLD_TO
, STP.CREATED_BY
, STP.CREATION_DATE
, STP.LAST_UPDATE_DATE
, STP.LAST_UPDATED_BY
, STP.LAST_UPDATE_LOGIN
, STP.ROWID
FROM SSP_STOPPAGES STP
, SSP_WITHHOLDING_REASONS WRE
WHERE WRE.REASON_ID=STP.REASON_ID
Columns
Name |
REASON |
STOPPAGE_ID |
OBJECT_VERSION_NUMBER |
ABSENCE_ATTENDANCE_ID |
MATERNITY_ID |
REASON_ID |
USER_ENTERED |
OVERRIDE_STOPPAGE |
EMPLOYEE_NOTIFIED |
WITHHOLD_FROM |
WITHHOLD_TO |
CREATED_BY |
CREATION_DATE |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_LOGIN |
ROW_ID |