XLA_ANALYTICAL_DTLS

Details

Schema: FUSION
Object owner: XLA
Object type: VIEW

Columns

Name
ROW_ID AMB_CONTEXT_CODE ANALYTICAL_CRITERION_TYPE_CODE ANALYTICAL_DETAIL_CODE ANALYTICAL_CRITERION_CODE GROUPING_ORDER DATA_TYPE_CODE VIEW_COLUMN_NUM NAME DESCRIPTION CREATION_DATE CREATED_BY LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER

Name

ROW_ID

AMB_CONTEXT_CODE

ANALYTICAL_CRITERION_TYPE_CODE

ANALYTICAL_DETAIL_CODE

ANALYTICAL_CRITERION_CODE

GROUPING_ORDER

DATA_TYPE_CODE

VIEW_COLUMN_NUM

NAME

DESCRIPTION

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.AMB_CONTEXT_CODE ,b.ANALYTICAL_CRITERION_TYPE_CODE ,b.ANALYTICAL_DETAIL_CODE ,b.ANALYTICAL_CRITERION_CODE, b.GROUPING_ORDER ,b.DATA_TYPE_CODE ,b.VIEW_COLUMN_NUM ,t.name ,t.description,b.CREATION_DATE ,b.CREATED_BY ,b.LAST_UPDATE_DATE ,b.LAST_UPDATED_BY ,b.LAST_UPDATE_LOGIN ,b.OBJECT_VERSION_NUMBER FROM xla_analytical_dtls_tl t ,xla_analytical_dtls_b b WHERE b.analytical_criterion_code = t.analytical_criterion_code AND b.analytical_criterion_type_code = t.analytical_criterion_type_code AND b.amb_context_code = t.amb_context_code AND b.analytical_detail_code = t.analytical_detail_code AND t.language = USERENV('LANG')

SQL_Statement

SELECT b.rowid row_id ,b.AMB_CONTEXT_CODE ,b.ANALYTICAL_CRITERION_TYPE_CODE ,b.ANALYTICAL_DETAIL_CODE ,b.ANALYTICAL_CRITERION_CODE, b.GROUPING_ORDER ,b.DATA_TYPE_CODE ,b.VIEW_COLUMN_NUM ,t.name ,t.description,b.CREATION_DATE ,b.CREATED_BY ,b.LAST_UPDATE_DATE ,b.LAST_UPDATED_BY ,b.LAST_UPDATE_LOGIN ,b.OBJECT_VERSION_NUMBER FROM xla_analytical_dtls_tl t ,xla_analytical_dtls_b b WHERE b.analytical_criterion_code = t.analytical_criterion_code AND b.analytical_criterion_type_code = t.analytical_criterion_type_code AND b.amb_context_code = t.amb_context_code AND b.analytical_detail_code = t.analytical_detail_code AND t.language = USERENV('LANG')