1. Tables and Views for Common Features
  2. ATK_QB_QUERIES_VL

ATK_QB_QUERIES_VL

Details

  • Schema: FUSION

  • Object owner: ATK

  • Object type: VIEW

Columns

Name

QUERY_ID

QUERY_GROUP_ID

QUERY_NAME

ENABLED_FLAG

SEQUENCE_NUM

SELECT_STATEMENT

CREATION_DATE

CREATED_BY

LAST_UPDATE_DATE

LAST_UPDATED_BY

LAST_UPDATE_LOGIN

OBJECT_VERSION_NUMBER

QUERY_USER_NAME

QUERY_DESC

Query

SQL_Statement

SELECT

ATK_QB_QUERIES_B.QUERY_ID QUERY_ID,

ATK_QB_QUERIES_B.QUERY_GROUP_ID QUERY_GROUP_ID,

ATK_QB_QUERIES_B.QUERY_NAME QUERY_NAME,

ATK_QB_QUERIES_B.ENABLED_FLAG ENABLED_FLAG,

ATK_QB_QUERIES_B.SEQUENCE_NUM SEQUENCE_NUM,

ATK_QB_QUERIES_B.SELECT_STATEMENT SELECT_STATEMENT,

ATK_QB_QUERIES_B.CREATION_DATE CREATION_DATE,

ATK_QB_QUERIES_B.CREATED_BY CREATED_BY,

ATK_QB_QUERIES_B.LAST_UPDATE_DATE LAST_UPDATE_DATE,

ATK_QB_QUERIES_B.LAST_UPDATED_BY LAST_UPDATED_BY,

ATK_QB_QUERIES_B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN,

ATK_QB_QUERIES_B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER,

ATK_QB_QUERIES_TL.QUERY_USER_NAME QUERY_USER_NAME,

ATK_QB_QUERIES_TL.QUERY_DESC QUERY_DESC

FROM

ATK_QB_QUERIES_B,

ATK_QB_QUERIES_TL

WHERE

ATK_QB_QUERIES_B.QUERY_ID=ATK_QB_QUERIES_TL.QUERY_ID AND ATK_QB_QUERIES_TL.LANGUAGE=USERENV('LANG')