DBA Data[Home] [Help]

VIEW: APPS.SSP_STOPPAGES_V

Source

View Text - Preformatted

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
View Text - HTML Formatted

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