[Home] [Help]
View: ICX_POR_ITEM_SOURCES_FORM_V
View Text
SELECT IPIS.ROWID ROW_ID
, IPIS.ITEM_SOURCE_ID ITEM_SOURCE_ID
, NVL(IPIS.TYPE
, 'EXTERNAL') TYPE
, IPIS.URL URL
, IPIS.IMAGE_URL IMAGE_URL
, IPIST.ITEM_SOURCE_NAME ITEM_SOURCE_NAME
, IPIST.DESCRIPTION DESCRIPTION
, IPIS.LAST_UPDATE_DATE LAST_UPDATE_DATE
, IPIS.LAST_UPDATED_BY LAST_UPDATED_BY
, IPIS.CREATION_DATE CREATION_DATE
, IPIS.CREATED_BY CREATED_BY
, IPIS.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, IPIST.CTX_KEYWORDS CTX_KEYWORDS
, IPIS.DISPLAY_ALWAYS DISPLAY_ALWAYS
FROM ICX_POR_ITEM_SOURCES IPIS
, ICX_POR_ITEM_SOURCES_TL IPIST
WHERE IPIS.ITEM_SOURCE_ID = IPIST.ITEM_SOURCE_ID
AND IPIST.LANGUAGE = USERENV('LANG')
Columns
Name |
ROW_ID |
ITEM_SOURCE_ID |
TYPE |
URL |
IMAGE_URL |
ITEM_SOURCE_NAME |
DESCRIPTION |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
CREATION_DATE |
CREATED_BY |
LAST_UPDATE_LOGIN |
CTX_KEYWORDS |
DISPLAY_ALWAYS |