[Home] [Help]
View: AST_LS_LIST_HEADERS_V
View Text
SELECT L.LIST_HEADER_ID
, L.LAST_UPDATE_DATE
, L.LAST_UPDATED_BY
, L.CREATION_DATE
, T.LIST_NAME
, L.LIST_TYPE
, L.LIST_SOURCE_TYPE
, T.DESCRIPTION
, L.ENABLED_FLAG
, L.STATUS_CODE
, L.OWNER_USER_ID
, RSC.SOURCE_LAST_NAME ||'
, '|| RSC.SOURCE_FIRST_NAME
, L.NO_OF_ROWS_IN_LIST
FROM AMS_LIST_HEADERS_ALL L
, AMS_LIST_HEADERS_ALL_TL T
, JTF_RS_RESOURCE_EXTNS RSC
WHERE L.LIST_HEADER_ID=T.LIST_HEADER_ID(+)
AND RSC.RESOURCE_ID(+) = L.OWNER_USER_ID
AND T.LANGUAGE=USERENV('LANG')
Columns
Name |
LIST_HEADER_ID |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
CREATION_DATE |
LIST_NAME |
LIST_TYPE |
LIST_SOURCE_TYPE |
DESCRIPTION |
ENABLED_FLAG |
STATUS_CODE |
RESOURCE_ID |
OWNER_NAME |
NO_OF_ROWS_IN_LIST |