VIEW: AR.RA_BATCHES_ALL#

Source

View Text - Preformatted

select BATCH_ID BATCH_ID, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, NAME NAME, BATCH_DATE BATCH_DATE, GL_DATE GL_DATE, STATUS STATUS, TYPE TYPE, BATCH_SOURCE_ID BATCH_SOURCE_ID, CONTROL_COUNT CONTROL_COUNT, CONTROL_AMOUNT CONTROL_AMOUNT, COMMENTS COMMENTS, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, CURRENCY_CODE CURRENCY_CODE, EXCHANGE_RATE_TYPE EXCHANGE_RATE_TYPE, EXCHANGE_DATE EXCHANGE_DATE, EXCHANGE_RATE EXCHANGE_RATE, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, SET_OF_BOOKS_ID SET_OF_BOOKS_ID, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, ORG_ID ORG_ID, PURGED_CHILDREN_FLAG PURGED_CHILDREN_FLAG, ISSUE_DATE ISSUE_DATE, MATURITY_DATE MATURITY_DATE, SPECIAL_INSTRUCTIONS SPECIAL_INSTRUCTIONS, BATCH_PROCESS_STATUS BATCH_PROCESS_STATUS, SELECTION_CRITERIA_ID SELECTION_CRITERIA_ID from "AR"."RA_BATCHES_ALL"

View Text - HTML Formatted

SELECT BATCH_ID BATCH_ID
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, NAME NAME
, BATCH_DATE BATCH_DATE
, GL_DATE GL_DATE
, STATUS STATUS
, TYPE TYPE
, BATCH_SOURCE_ID BATCH_SOURCE_ID
, CONTROL_COUNT CONTROL_COUNT
, CONTROL_AMOUNT CONTROL_AMOUNT
, COMMENTS COMMENTS
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, CURRENCY_CODE CURRENCY_CODE
, EXCHANGE_RATE_TYPE EXCHANGE_RATE_TYPE
, EXCHANGE_DATE EXCHANGE_DATE
, EXCHANGE_RATE EXCHANGE_RATE
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, ORG_ID ORG_ID
, PURGED_CHILDREN_FLAG PURGED_CHILDREN_FLAG
, ISSUE_DATE ISSUE_DATE
, MATURITY_DATE MATURITY_DATE
, SPECIAL_INSTRUCTIONS SPECIAL_INSTRUCTIONS
, BATCH_PROCESS_STATUS BATCH_PROCESS_STATUS
, SELECTION_CRITERIA_ID SELECTION_CRITERIA_ID
FROM "AR"."RA_BATCHES_ALL"