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

TABLE: XLA.XLA_ACCT_LINE_TYPES_B

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

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
XLA_ACCT_LINE_TYPES_B_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnAPPLICATION_ID
ColumnENTITY_CODE
ColumnEVENT_CLASS_CODE
ColumnAMB_CONTEXT_CODE
ColumnACCOUNTING_LINE_TYPE_CODE
ColumnACCOUNTING_LINE_CODE
Columns
Name Datatype Length Mandatory Comments
APPLICATION_ID NUMBER (15) Yes Internal Id of the application
AMB_CONTEXT_CODE VARCHAR2 (30) Yes Accounting Methods Builder context.
ENTITY_CODE VARCHAR2 (30) Yes Entity code
EVENT_CLASS_CODE VARCHAR2 (30) Yes Event class code
ACCOUNTING_LINE_TYPE_CODE VARCHAR2 (1) Yes Accounting line type code
ACCOUNTING_LINE_CODE VARCHAR2 (30) Yes Accounting line code
TRANSACTION_COA_ID NUMBER (15)
Chart of accounts of the transaction
ACCOUNTING_ENTRY_TYPE_CODE VARCHAR2 (1) Yes Indicates the accounting line type, for example Actual, Encumbrances or budget
NATURAL_SIDE_CODE VARCHAR2 (1) Yes Natural side for the accounting line type
GL_TRANSFER_MODE_CODE VARCHAR2 (1) Yes General Ledger Transfer mode
SWITCH_SIDE_FLAG VARCHAR2 (1)
Flag to indicate whether to switch side when the amount is negative
MERGE_DUPLICATE_CODE VARCHAR2 (1) Yes Code to indicate how duplicate accounting lines must be merged
ENABLED_FLAG VARCHAR2 (1) Yes Internal flag. Enabled accounting line types can be assigned to product rules
ACCOUNTING_CLASS_CODE VARCHAR2 (30) Yes Accounting Class code i.e. Asset, Liability, Revenue, Expense.
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).
ROUNDING_CLASS_CODE VARCHAR2 (30) Yes The accounting class used by the accounting program as the basis for grouping journal lines when performing rounding.
BUSINESS_METHOD_CODE VARCHAR2 (30) Yes Business Flow Method code
BUSINESS_CLASS_CODE VARCHAR2 (30)
Business flow class code
MPA_OPTION_CODE VARCHAR2 (30)
Multiperiod accounting option
ENCUMBRANCE_TYPE_ID NUMBER (15)
GAIN_OR_LOSS_FLAG VARCHAR2 (1)
To identify product calculated gain or loss so that the gain or loss amount provided in transaction objects will not be conterted to reporting currency and non valuation method secondary ledgers
Query Text

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


SELECT APPLICATION_ID
,      AMB_CONTEXT_CODE
,      ENTITY_CODE
,      EVENT_CLASS_CODE
,      ACCOUNTING_LINE_TYPE_CODE
,      ACCOUNTING_LINE_CODE
,      TRANSACTION_COA_ID
,      ACCOUNTING_ENTRY_TYPE_CODE
,      NATURAL_SIDE_CODE
,      GL_TRANSFER_MODE_CODE
,      SWITCH_SIDE_FLAG
,      MERGE_DUPLICATE_CODE
,      ENABLED_FLAG
,      ACCOUNTING_CLASS_CODE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      ROUNDING_CLASS_CODE
,      BUSINESS_METHOD_CODE
,      BUSINESS_CLASS_CODE
,      MPA_OPTION_CODE
,      ENCUMBRANCE_TYPE_ID
,      GAIN_OR_LOSS_FLAG
FROM XLA.XLA_ACCT_LINE_TYPES_B;

Dependencies

[top of page]

XLA.XLA_ACCT_LINE_TYPES_B does not reference any database object

XLA.XLA_ACCT_LINE_TYPES_B is referenced by following:

SchemaAPPS
SynonymXLA_ACCT_LINE_TYPES_B