XLA_ANALYTICAL_HDRS

Details

Schema: FUSION
Object owner: XLA
Object type: VIEW

Columns

Name
ROW_ID SUPPORTING_REFERENCE_ID AMB_CONTEXT_CODE ANALYTICAL_CRITERION_CODE ANALYTICAL_CRITERION_TYPE_CODE APPLICATION_ID BALANCING_FLAG DISPLAY_ORDER YEAR_END_CARRY_FORWARD_CODE ENABLED_FLAG UPDATED_FLAG VERSION_NUM NAME DESCRIPTION CREATION_DATE CREATED_BY LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER UPDATED_IN_ESSBASE SUPP_REF_ORDER

Name

ROW_ID

SUPPORTING_REFERENCE_ID

AMB_CONTEXT_CODE

ANALYTICAL_CRITERION_CODE

ANALYTICAL_CRITERION_TYPE_CODE

APPLICATION_ID

BALANCING_FLAG

DISPLAY_ORDER

YEAR_END_CARRY_FORWARD_CODE

ENABLED_FLAG

UPDATED_FLAG

VERSION_NUM

NAME

DESCRIPTION

CREATION_DATE

CREATED_BY

LAST_UPDATE_DATE

LAST_UPDATED_BY

LAST_UPDATE_LOGIN

OBJECT_VERSION_NUMBER

UPDATED_IN_ESSBASE

SUPP_REF_ORDER

Query

SQL_Statement
SELECT b.ROWID row_id, b.SUPPORTING_REFERENCE_ID, b.AMB_CONTEXT_CODE, b.ANALYTICAL_CRITERION_CODE, b.ANALYTICAL_CRITERION_TYPE_CODE, b.APPLICATION_ID, b.BALANCING_FLAG, b.DISPLAY_ORDER, b.YEAR_END_CARRY_FORWARD_CODE, b.ENABLED_FLAG, b.UPDATED_FLAG, b.VERSION_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, b.UPDATED_IN_ESSBASE, b.SUPP_REF_ORDER FROM XLA_ANALYTICAL_HDRS_TL t, XLA_ANALYTICAL_HDRS_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 t.LANGUAGE = USERENV('LANG')

SQL_Statement

SELECT

b.ROWID row_id,

b.SUPPORTING_REFERENCE_ID,

b.AMB_CONTEXT_CODE,

b.ANALYTICAL_CRITERION_CODE,

b.ANALYTICAL_CRITERION_TYPE_CODE,

b.APPLICATION_ID,

b.BALANCING_FLAG,

b.DISPLAY_ORDER,

b.YEAR_END_CARRY_FORWARD_CODE,

b.ENABLED_FLAG,

b.UPDATED_FLAG,

b.VERSION_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,

b.UPDATED_IN_ESSBASE,

b.SUPP_REF_ORDER

FROM

XLA_ANALYTICAL_HDRS_TL t,

XLA_ANALYTICAL_HDRS_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 t.LANGUAGE = USERENV('LANG')