ATK_QB_CONTEXTS_VL

Details

• Schema: FUSION

• Object owner: ATK

• Object type: VIEW

Columns

Name

CONTEXT_ID APPLICATION_ID CONTEXT_NAME MULTI_VALUE_FLAG MULTI_RULE_RESULT_FLAG CONTEXT_TYPE_CODE FLEX_FIELD_NAME FLEX_FIELD_APP_ID USE_DEFAULT_FLAG IS_DEFAULT_REQUIRED_FLAG CONTEXT_CATEGORY CREATION_DATE CREATED_BY LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER ORG_ID USER_CONTEXT_NAME CONTEXT_DESC IS_QUERY_USER_NAME_UNIQUE UNIQUE_QRY_USER_NAME_REQ_MSG IS_QRY_CRITERIA_REQ QRY_CRITERIA_REQ_MSG

Query

SQL_Statement

SELECT B.CONTEXT_ID, B.APPLICATION_ID, B.CONTEXT_NAME, B.MULTI_VALUE_FLAG, B.MULTI_RULE_RESULT_FLAG, B.CONTEXT_TYPE_CODE, B.FLEX_FIELD_NAME, B.FLEX_FIELD_APP_ID, B.USE_DEFAULT_FLAG, B.IS_DEFAULT_REQUIRED_FLAG, B.CONTEXT_CATEGORY, B.CREATION_DATE, B.CREATED_BY, B.LAST_UPDATE_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_LOGIN, B.OBJECT_VERSION_NUMBER, B.ORG_ID, T.USER_CONTEXT_NAME, T.CONTEXT_DESC, B.IS_QUERY_USER_NAME_UNIQUE, B.UNIQUE_QRY_USER_NAME_REQ_MSG, B.IS_QRY_CRITERIA_REQ, B.QRY_CRITERIA_REQ_MSG FROM ATK_QB_CONTEXTS_ALL_TL T, ATK_QB_CONTEXTS_ALL_B B WHERE B.CONTEXT_ID = T.CONTEXT_ID AND T.LANGUAGE = USERENV('LANG')