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: CZ_IMAGELOOKUPS_V

Product:	CZ - Configurator
Description:
Implementation/DBA Data:	APPS.CZ_IMAGELOOKUPS_V

View Text

SELECT LKV.LIST_NAME
, LKV.DATA_VALUE AS IMAGE_CODE
, LKV.VALUE_SEQ
, LKV.DATA_TYPE_ID
, LKV.NULL_VALUE_FLAG
, LKT.VALUE_LABEL AS IMAGE_ALT_TEXT
, LKT.VALUE_DESCRIPTION AS IMAGE_PATH
, LKT.VALUE_NOTES
, LKT.LANGUAGE
, LKT.SOURCE_LANG
, LKT.CREATION_DATE
, LKT.LAST_UPDATE_DATE
, LKT.CREATED_BY
, LKT.LAST_UPDATED_BY
, LKT.LAST_UPDATE_LOGIN
, LKV.NUMERIC_ID_VALUE
FROM CZ_LOOKUP_VALUES LKV
, CZ_LOOKUP_VALUES_TL LKT
WHERE LKV.DATA_TYPE_ID = 14
AND LKV.LIST_NAME = LKT.LIST_NAME
AND LKV.DATA_VALUE = LKT.DATA_VALUE
AND LKT.LANGUAGE = USERENV('LANG')

Columns

Name
LIST_NAME
IMAGE_CODE
VALUE_SEQ
DATA_TYPE_ID
NULL_VALUE_FLAG
IMAGE_ALT_TEXT
IMAGE_PATH
VALUE_NOTES
LANGUAGE
SOURCE_LANG
CREATION_DATE
LAST_UPDATE_DATE
CREATED_BY
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
NUMERIC_ID_VALUE