FND Design Data [Home] [Help]

View: XLA_ACCT_ATTRIBUTES_VL

Product: XLA - Subledger Accounting
Description:
Implementation/DBA Data: ViewAPPS.XLA_ACCT_ATTRIBUTES_VL
View Text

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
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')

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