[Home] [Help]
View: AST_LS_SAVED_QUERIES_V
View Text
SELECT QUERY.QUERY_ID
, QUERY.PROFILE_ID
, PROFILE.PROFILE_NAME
, QUERY.APPLICATION_ID
, QUERY.QUERY_NAME
, QUERY.QUERY_TYPE
, QUERY.QUERY_DESCRIPTION
, QUERY.QUERY_DATA_SOURCE
, QUERY.CREATED_BY
, QUERY.LAST_UPDATE_DATE
, QUERY.LAST_UPDATED_BY
, QUERY.LAST_UPDATE_LOGIN
FROM JTF_PERZ_QUERY QUERY
, JTF_PERZ_PROFILE PROFILE
WHERE QUERY.PROFILE_ID = PROFILE.PROFILE_ID
Columns
Name |
QUERY_ID |
PROFILE_ID |
PROFILE_NAME |
APPLICATION_ID |
QUERY_NAME |
QUERY_TYPE |
QUERY_DESCRIPTION |
QUERY_DATA_SOURCE |
CREATED_BY |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_LOGIN |