VIEW: APPS.ICX_POR_ITEM_SOURCES_VL

Source

View Text - Preformatted

SELECT IPIS.ROWID, IPIS.ITEM_SOURCE_ID, IPIST.ITEM_SOURCE_NAME, IPIST.DESCRIPTION, IPIS.TYPE, IPIS.URL, IPIS.IMAGE_URL, IPIST.CTX_KEYWORDS, ipis.created_by, ipis.creation_date, ipis.last_updated_by, ipis.last_update_date, ipis.last_update_login, ipis.protocol_supported, ipis.is_hub, ipis.operator_id, nvl(ipis.lock_item_flag,'N'), decode(ipis.user_data_list_id,null,'N','Y'), nvl(ipis.display_always,'N'), ipis.user_name, ipis.password, ipis.sequence_number, ipis.icx_session_servlet_flag FROM ICX_POR_ITEM_SOURCES IPIS, ICX_POR_ITEM_SOURCES_TL IPIST WHERE IPIS.ITEM_SOURCE_ID = IPIST.ITEM_SOURCE_ID AND IPIS.TYPE <> 'LOCAL' AND IPIST.LANGUAGE = USERENV('LANG')

View Text - HTML Formatted

SELECT IPIS.ROWID
, IPIS.ITEM_SOURCE_ID
, IPIST.ITEM_SOURCE_NAME
, IPIST.DESCRIPTION
, IPIS.TYPE
, IPIS.URL
, IPIS.IMAGE_URL
, IPIST.CTX_KEYWORDS
, IPIS.CREATED_BY
, IPIS.CREATION_DATE
, IPIS.LAST_UPDATED_BY
, IPIS.LAST_UPDATE_DATE
, IPIS.LAST_UPDATE_LOGIN
, IPIS.PROTOCOL_SUPPORTED
, IPIS.IS_HUB
, IPIS.OPERATOR_ID
, NVL(IPIS.LOCK_ITEM_FLAG
, 'N')
, DECODE(IPIS.USER_DATA_LIST_ID
, NULL
, 'N'
, 'Y')
, NVL(IPIS.DISPLAY_ALWAYS
, 'N')
, IPIS.USER_NAME
, IPIS.PASSWORD
, IPIS.SEQUENCE_NUMBER
, IPIS.ICX_SESSION_SERVLET_FLAG
FROM ICX_POR_ITEM_SOURCES IPIS
, ICX_POR_ITEM_SOURCES_TL IPIST
WHERE IPIS.ITEM_SOURCE_ID = IPIST.ITEM_SOURCE_ID
AND IPIS.TYPE <> 'LOCAL'
AND IPIST.LANGUAGE = USERENV('LANG')