[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 |
APPS.AST_LS_LIST_HEADERS_V