VIEW: APPS.XLA_ACCT_ATTRIBUTES_VL

Source

View Text - Preformatted

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

View Text - HTML Formatted

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