1. Tables and Views for Common Features
  2. ATK_QB_QUERY_GROUPS_VL

ATK_QB_QUERY_GROUPS_VL

Details

  • Schema: FUSION

  • Object owner: ATK

  • Object type: VIEW

Columns

Name

QUERY_GROUP_ID

CONTEXT_ID

QUERY_GROUP_NAME

CREATION_DATE

CREATED_BY

LAST_UPDATE_DATE

LAST_UPDATED_BY

LAST_UPDATE_LOGIN

OBJECT_VERSION_NUMBER

QUERY_GROUP_USER_NAME

QUERY_GROUP_DESC

MULTI_RULE_RESULT_FLAG

USE_DEFAULT_RESULT_FLAG

IS_DEFAULT_RESULT_REQ_FLAG

USE_CONTEXT_METADATA

Query

SQL_Statement

SELECT

ATK_QB_QUERY_GROUP_B.QUERY_GROUP_ID QUERY_GROUP_ID,

ATK_QB_QUERY_GROUP_B.CONTEXT_ID CONTEXT_ID,

ATK_QB_QUERY_GROUP_B.QUERY_GROUP_NAME QUERY_GROUP_NAME,

ATK_QB_QUERY_GROUP_B.CREATION_DATE CREATION_DATE,

ATK_QB_QUERY_GROUP_B.CREATED_BY CREATED_BY,

ATK_QB_QUERY_GROUP_B.LAST_UPDATE_DATE LAST_UPDATE_DATE,

ATK_QB_QUERY_GROUP_B.LAST_UPDATED_BY LAST_UPDATED_BY,

ATK_QB_QUERY_GROUP_B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN,

ATK_QB_QUERY_GROUP_B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER,

ATK_QB_QUERY_GROUP_TL.QUERY_GROUP_USER_NAME QUERY_GROUP_USER_NAME,

ATK_QB_QUERY_GROUP_TL.QUERY_GROUP_DESC QUERY_GROUP_DESC,

ATK_QB_QUERY_GROUP_B.MULTI_RULE_RESULT_FLAG,

ATK_QB_QUERY_GROUP_B.USE_DEFAULT_RESULT_FLAG,

ATK_QB_QUERY_GROUP_B.IS_DEFAULT_RESULT_REQ_FLAG,

ATK_QB_QUERY_GROUP_B.USE_CONTEXT_METADATA

FROM

ATK_QB_QUERY_GROUP_B,

ATK_QB_QUERY_GROUP_TL

WHERE

ATK_QB_QUERY_GROUP_B.QUERY_GROUP_ID=ATK_QB_QUERY_GROUP_TL.QUERY_GROUP_ID AND ATK_QB_QUERY_GROUP_TL.LANGUAGE=USERENV('LANG')