ATK_QB_QUERIES_VL
詳細
-
スキーマ: FUSION
-
オブジェクト所有者: ATK
-
オブジェクト・タイプ: VIEW
列
| 名前 |
|---|
|
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 |
問合せ
| 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') |