VIEW: APPS.IEX_LS_LIST_HEADERS_V

Source

View Text - Preformatted

SELECT L.LIST_HEADER_ID list_header_id, L.LAST_UPDATE_DATE last_update_date, L.LAST_UPDATED_BY last_updated_by, L.CREATION_DATE creation_date, T.LIST_NAME list_name, L.LIST_TYPE list_type, L.LIST_SOURCE_TYPE list_source_type, T.DESCRIPTION description, L.ENABLED_FLAG enabled_flag, L.STATUS_CODE status_code, L.OWNER_USER_ID resource_id, rsc.SOURCE_LAST_NAME ||', '|| rsc.SOURCE_FIRST_NAME owner_name, L.NO_OF_ROWS_IN_LIST 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')

View Text - HTML Formatted

SELECT L.LIST_HEADER_ID LIST_HEADER_ID
, L.LAST_UPDATE_DATE LAST_UPDATE_DATE
, L.LAST_UPDATED_BY LAST_UPDATED_BY
, L.CREATION_DATE CREATION_DATE
, T.LIST_NAME LIST_NAME
, L.LIST_TYPE LIST_TYPE
, L.LIST_SOURCE_TYPE LIST_SOURCE_TYPE
, T.DESCRIPTION DESCRIPTION
, L.ENABLED_FLAG ENABLED_FLAG
, L.STATUS_CODE STATUS_CODE
, L.OWNER_USER_ID RESOURCE_ID
, RSC.SOURCE_LAST_NAME ||'
, '|| RSC.SOURCE_FIRST_NAME OWNER_NAME
, L.NO_OF_ROWS_IN_LIST 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')