DBA Data[Home] [Help] [Dependency Information]

VIEW: XLA.XLA_GL_TRANSFER_BATCHES_ALL#

Object Details
Object Name: XLA_GL_TRANSFER_BATCHES_ALL#
Object Type: VIEW
Owner: XLA
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
GL_TRANSFER_RUN_ID NUMBER (15) Yes
REQUEST_ID NUMBER (15)
APPLICATION_ID NUMBER (15)
USER_ID NUMBER (15)
SELECTION_TYPE NUMBER

SET_OF_BOOKS_ID NUMBER (15)
BATCH_NAME VARCHAR2 (30)
SOURCE_ID NUMBER (15)
SOURCE_TABLE VARCHAR2 (30)
TRANSFER_FROM_DATE DATE

TRANSFER_TO_DATE DATE

AE_CATEGORY VARCHAR2 (30)
GL_TRANSFER_MODE VARCHAR2 (1)
SUBMIT_JOURNAL_IMPORT VARCHAR2 (1)
SUMMARY_JOURNAL_ENTRY VARCHAR2 (1)
PROCESS_DAYS NUMBER

GL_TRANSFER_DATE DATE

GLLEZL_REQUEST_ID NUMBER (15)
INTERFACE_RUN_ID NUMBER (15)
GROUP_ID NUMBER (15)
ORG_ID NUMBER (15)
LEGAL_ENTITY_ID NUMBER (15)
COST_TYPE_ID NUMBER (15)
COST_GROUP_ID NUMBER (15)
TRANSFER_STATUS VARCHAR2 (1)
PACKET_ID NUMBER (15)
Query Text

Cut, paste (and edit) the following text to query this object:


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

Dependencies

[top of page]

XLA.XLA_GL_TRANSFER_BATCHES_ALL# references the following:

SchemaXLA
TableXLA_GL_TRANSFER_BATCHES_ALL
XLA.XLA_GL_TRANSFER_BATCHES_ALL# is referenced by following:

SchemaAPPS
SynonymXLA_GL_TRANSFER_BATCHES_ALL