VIEW: HR.PAY_BATCH_HEADERS#

Source

View Text - Preformatted

select BATCH_ID BATCH_ID, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, BATCH_NAME BATCH_NAME, BATCH_STATUS BATCH_STATUS, ACTION_IF_EXISTS ACTION_IF_EXISTS, BATCH_REFERENCE BATCH_REFERENCE, BATCH_SOURCE BATCH_SOURCE, COMMENTS COMMENTS, DATE_EFFECTIVE_CHANGES DATE_EFFECTIVE_CHANGES, PURGE_AFTER_TRANSFER PURGE_AFTER_TRANSFER, REJECT_IF_FUTURE_CHANGES REJECT_IF_FUTURE_CHANGES, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, REJECT_IF_RESULTS_EXISTS REJECT_IF_RESULTS_EXISTS, PURGE_AFTER_ROLLBACK PURGE_AFTER_ROLLBACK, REJECT_ENTRY_NOT_REMOVED REJECT_ENTRY_NOT_REMOVED, ROLLBACK_ENTRY_UPDATES ROLLBACK_ENTRY_UPDATES, BATCH_TYPE BATCH_TYPE from "HR"."PAY_BATCH_HEADERS"

View Text - HTML Formatted

SELECT BATCH_ID BATCH_ID
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, BATCH_NAME BATCH_NAME
, BATCH_STATUS BATCH_STATUS
, ACTION_IF_EXISTS ACTION_IF_EXISTS
, BATCH_REFERENCE BATCH_REFERENCE
, BATCH_SOURCE BATCH_SOURCE
, COMMENTS COMMENTS
, DATE_EFFECTIVE_CHANGES DATE_EFFECTIVE_CHANGES
, PURGE_AFTER_TRANSFER PURGE_AFTER_TRANSFER
, REJECT_IF_FUTURE_CHANGES REJECT_IF_FUTURE_CHANGES
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, REJECT_IF_RESULTS_EXISTS REJECT_IF_RESULTS_EXISTS
, PURGE_AFTER_ROLLBACK PURGE_AFTER_ROLLBACK
, REJECT_ENTRY_NOT_REMOVED REJECT_ENTRY_NOT_REMOVED
, ROLLBACK_ENTRY_UPDATES ROLLBACK_ENTRY_UPDATES
, BATCH_TYPE BATCH_TYPE
FROM "HR"."PAY_BATCH_HEADERS"