eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: ICX_POR_ITEM_SOURCES_VL

Product:	ICX - Oracle iProcurement
Description:
Implementation/DBA Data:	APPS.ICX_POR_ITEM_SOURCES_VL

View Text

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')

Columns

Name
ROW_ID
ITEM_SOURCE_ID
ITEM_SOURCE_NAME
DESCRIPTION
TYPE
URL
IMAGE_URL
CTX_KEYWORDS
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
PROTOCOL_SUPPORTED
IS_HUB
OPERATOR_ID
LOCK_ITEM_FLAG
USER_DATA_FLAG
DISPLAY_ALWAYS
USER_NAME
PASSWORD
SEQUENCE_NUMBER
ICX_SESSION_SERVLET_FLAG