XLA_ACCTG_METHODS_VL

Details

• Schema: FUSION

• Object owner: XLA

• Object type: VIEW

Columns

Name
ROW_ID ACCOUNTING_METHOD_TYPE_CODE ACCOUNTING_METHOD_CODE NAME DESCRIPTION TRANSACTION_COA_ID ACCOUNTING_COA_ID ENABLED_FLAG CREATION_DATE CREATED_BY LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER

Query

SQL_Statement

SELECT b.rowid row_id ,b.accounting_method_type_code ,b.accounting_method_code ,t.name ,t.description ,b.transaction_coa_id ,b.accounting_coa_id ,b.enabled_flag ,b.creation_date ,b.created_by ,b.last_update_date ,b.last_updated_by ,b.last_update_login ,b.object_version_number FROM xla_acctg_methods_b b ,xla_acctg_methods_tl t WHERE b.accounting_method_code = t.accounting_method_code AND b.accounting_method_type_code = t.accounting_method_type_code AND t.language = USERENV('LANG')