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

TABLE: XLA.XLA_TB_DEFN_JE_SOURCES

Object Details
Object Name: XLA_TB_DEFN_JE_SOURCES
Object Type: TABLE
Owner: XLA
FND Design Data: TableXLA.XLA_TB_DEFN_JE_SOURCES
Subobject Name:
Status: VALID


This table stores journal sources associated with the Open Account Balances Listing report definitions.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
XLA_TB_DEFN_JE_SOURCES_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnDEFINITION_CODE
ColumnJE_SOURCE_NAME
Columns
Name Datatype Length Mandatory Comments
DEFINITION_CODE VARCHAR2 (30) Yes Definition code for the Open Account Balances Listing report definition
JE_SOURCE_NAME VARCHAR2 (30) Yes Journal source name
OBJECT_VERSION_NUMBER NUMBER
Yes Object version number
CREATION_DATE DATE
Yes Standard who column - date when this row was created.
CREATED_BY NUMBER (15) Yes Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Yes Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER (15) Yes Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
OWNER_CODE VARCHAR2 (30)
Identifies the owner of the journal source row for the purpose of preventing removal of that row from the definition.
Query Text

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


SELECT DEFINITION_CODE
,      JE_SOURCE_NAME
,      OBJECT_VERSION_NUMBER
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      OWNER_CODE
FROM XLA.XLA_TB_DEFN_JE_SOURCES;

Dependencies

[top of page]

XLA.XLA_TB_DEFN_JE_SOURCES does not reference any database object

XLA.XLA_TB_DEFN_JE_SOURCES is referenced by following:

SchemaXLA
ViewXLA_TB_DEFN_JE_SOURCES#