XLA_TAB_ACCT_TYPES

Details

Schema: FUSION
Object owner: XLA
Object type: VIEW

Columns

Name
ROW_ID APPLICATION_ID ACCOUNT_TYPE_CODE ENABLED_FLAG RULE_ASSIGNMENT_CODE COMPILE_STATUS_CODE OBJECT_NAME_AFFIX CREATION_DATE CREATED_BY LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER NAME DESCRIPTION

Name

ROW_ID

APPLICATION_ID

ACCOUNT_TYPE_CODE

ENABLED_FLAG

RULE_ASSIGNMENT_CODE

COMPILE_STATUS_CODE

OBJECT_NAME_AFFIX

CREATION_DATE

CREATED_BY

LAST_UPDATE_DATE

LAST_UPDATED_BY

LAST_UPDATE_LOGIN

OBJECT_VERSION_NUMBER

NAME

DESCRIPTION

Query

SQL_Statement
SELECT b.rowid row_id ,b.application_id ,b.account_type_code ,b.enabled_flag ,b.rule_assignment_code ,b.compile_status_code ,b.object_name_affix ,b.creation_date ,b.created_by ,b.last_update_date ,b.last_updated_by ,b.last_update_login,b.object_version_number ,t.name ,t.description FROM xla_tab_acct_types_tl t ,xla_tab_acct_types_b b WHERE b.application_id = t.application_id AND b.account_type_code = t.account_type_code AND t.language = USERENV('LANG')

SQL_Statement

SELECT b.rowid row_id ,b.application_id ,b.account_type_code ,b.enabled_flag ,b.rule_assignment_code ,b.compile_status_code ,b.object_name_affix ,b.creation_date ,b.created_by ,b.last_update_date ,b.last_updated_by ,b.last_update_login,b.object_version_number ,t.name ,t.description FROM xla_tab_acct_types_tl t ,xla_tab_acct_types_b b WHERE b.application_id = t.application_id AND b.account_type_code = t.account_type_code AND t.language = USERENV('LANG')