1. Tables and Views for Financials
  2. XLA_ACCT_ATTRIBUTES_VL

XLA_ACCT_ATTRIBUTES_VL

Details

  • Schema: FUSION

  • Object owner: XLA

  • Object type: VIEW

Columns

Name

ROW_ID

ACCOUNTING_ATTRIBUTE_CODE

ASSIGNMENT_REQUIRED_CODE

ASSIGNMENT_GROUP_CODE

ASSIGNMENT_LEVEL_CODE

DATATYPE_CODE

JOURNAL_ENTRY_LEVEL_CODE

ASSIGNMENT_EXTENSIBLE_FLAG

INHERITED_FLAG

NAME

CREATED_BY

LAST_UPDATE_DATE

LAST_UPDATED_BY

LAST_UPDATE_LOGIN

CREATION_DATE

OBJECT_VERSION_NUMBER

ACCOUNTING_ATTRIBUTE_ID

DISPLAY_MODE_CODE

Query

SQL_Statement

SELECT

b.ROWID ROW_ID,

b.ACCOUNTING_ATTRIBUTE_CODE,

b.ASSIGNMENT_REQUIRED_CODE,

b.ASSIGNMENT_GROUP_CODE,

b.ASSIGNMENT_LEVEL_CODE,

b.DATATYPE_CODE,

b.JOURNAL_ENTRY_LEVEL_CODE,

b.ASSIGNMENT_EXTENSIBLE_FLAG,

b.INHERITED_FLAG,

t.NAME,

b.CREATED_BY,

b.LAST_UPDATE_DATE,

b.LAST_UPDATED_BY,

b.LAST_UPDATE_LOGIN,

b.CREATION_DATE,

b.OBJECT_VERSION_NUMBER,

b.ACCOUNTING_ATTRIBUTE_ID,

b.DISPLAY_MODE_CODE

FROM

XLA_ACCT_ATTRIBUTES_TL t,

XLA_ACCT_ATTRIBUTES_B b

WHERE

b.ACCOUNTING_ATTRIBUTE_CODE = t.ACCOUNTING_ATTRIBUTE_CODE AND t.LANGUAGE = USERENV('LANG')