VIEW: XLA.XLA_GL_TRANSFER_BATCHES_ALL#

Source

View Text - Preformatted

select GL_TRANSFER_RUN_ID GL_TRANSFER_RUN_ID, REQUEST_ID REQUEST_ID, APPLICATION_ID APPLICATION_ID, USER_ID USER_ID, SELECTION_TYPE SELECTION_TYPE, SET_OF_BOOKS_ID SET_OF_BOOKS_ID, BATCH_NAME BATCH_NAME, SOURCE_ID SOURCE_ID, SOURCE_TABLE SOURCE_TABLE, TRANSFER_FROM_DATE TRANSFER_FROM_DATE, TRANSFER_TO_DATE TRANSFER_TO_DATE, AE_CATEGORY AE_CATEGORY, GL_TRANSFER_MODE GL_TRANSFER_MODE, SUBMIT_JOURNAL_IMPORT SUBMIT_JOURNAL_IMPORT, SUMMARY_JOURNAL_ENTRY SUMMARY_JOURNAL_ENTRY, PROCESS_DAYS PROCESS_DAYS, GL_TRANSFER_DATE GL_TRANSFER_DATE, GLLEZL_REQUEST_ID GLLEZL_REQUEST_ID, INTERFACE_RUN_ID INTERFACE_RUN_ID, GROUP_ID GROUP_ID, ORG_ID ORG_ID, LEGAL_ENTITY_ID LEGAL_ENTITY_ID, COST_TYPE_ID COST_TYPE_ID, COST_GROUP_ID COST_GROUP_ID, TRANSFER_STATUS TRANSFER_STATUS, PACKET_ID PACKET_ID from "XLA"."XLA_GL_TRANSFER_BATCHES_ALL"

View Text - HTML Formatted

SELECT GL_TRANSFER_RUN_ID GL_TRANSFER_RUN_ID
, REQUEST_ID REQUEST_ID
, APPLICATION_ID APPLICATION_ID
, USER_ID USER_ID
, SELECTION_TYPE SELECTION_TYPE
, SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, BATCH_NAME BATCH_NAME
, SOURCE_ID SOURCE_ID
, SOURCE_TABLE SOURCE_TABLE
, TRANSFER_FROM_DATE TRANSFER_FROM_DATE
, TRANSFER_TO_DATE TRANSFER_TO_DATE
, AE_CATEGORY AE_CATEGORY
, GL_TRANSFER_MODE GL_TRANSFER_MODE
, SUBMIT_JOURNAL_IMPORT SUBMIT_JOURNAL_IMPORT
, SUMMARY_JOURNAL_ENTRY SUMMARY_JOURNAL_ENTRY
, PROCESS_DAYS PROCESS_DAYS
, GL_TRANSFER_DATE GL_TRANSFER_DATE
, GLLEZL_REQUEST_ID GLLEZL_REQUEST_ID
, INTERFACE_RUN_ID INTERFACE_RUN_ID
, GROUP_ID GROUP_ID
, ORG_ID ORG_ID
, LEGAL_ENTITY_ID LEGAL_ENTITY_ID
, COST_TYPE_ID COST_TYPE_ID
, COST_GROUP_ID COST_GROUP_ID
, TRANSFER_STATUS TRANSFER_STATUS
, PACKET_ID PACKET_ID
FROM "XLA"."XLA_GL_TRANSFER_BATCHES_ALL"