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_IM_ITEMS_V

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

View Text

SELECT CZITEMMASTERSEO.ITEM_ID
, CZITEMMASTERSEO.ITEM_TYPE_ID
, CZITEMMASTERSEO.DESC_TEXT
, CZITEMMASTERSEO.REF_PART_NBR
, CZITEMMASTERSEO.QUOTEABLE_FLAG
, CZITEMMASTERSEO.LEAD_TIME
, CZITEMMASTERSEO.ITEM_STATUS
, CZITEMMASTERSEO.PRIMARY_UOM_CODE
, CZITEMMASTERSEO.ORIG_SYS_REF
, CZITEMMASTERSEO.CREATION_DATE
, CZITEMMASTERSEO.LAST_UPDATE_DATE
, CZITEMMASTERSEO.DELETED_FLAG
, CZITEMMASTERSEO.CREATED_BY
, CZITEMMASTERSEO.LAST_UPDATED_BY
, CZITEMMASTERSEO.LAST_UPDATE_LOGIN
, CZITEMMASTERSEO.DECIMAL_QTY_FLAG
, CZITEMMASTERSEO.NOTES
, CZITEMMASTERSEO.SRC_APPLICATION_ID
, CZ_RPOBJECTTYPES_LKV.VALUE_DESCRIPTION AS ALT_TEXT
, CZ_RPOBJECTTYPES_LKV.VALUE_DESCRIPTION AS OBJECT_TYPE_DESC
, CZ_UI_PATHED_IMAGES_V.IMAGE_FILE
, CZ_UI_PATHED_IMAGES_V.FULL_IMAGE_PATH
FROM CZ_ITEM_MASTERS CZITEMMASTERSEO
, CZ_UI_PATHED_IMAGES_V
, CZ_RPOBJECTTYPES_LKV
WHERE CZITEMMASTERSEO.DELETED_FLAG = '0'
AND ( CZ_RPOBJECTTYPES_LKV.DATA_VALUE = 'ITM'
AND CZ_RPOBJECTTYPES_LKV.DATA_VALUE IS NOT NULL)
AND ( CZ_UI_PATHED_IMAGES_V.ENTITY_CODE = CZ_RPOBJECTTYPES_LKV.NUMERIC_ID_VALUE
AND CZ_RPOBJECTTYPES_LKV.NUMERIC_ID_VALUE IS NOT NULL)
AND CZ_UI_PATHED_IMAGES_V.IMAGE_USAGE_CODE = 30
AND CZ_UI_PATHED_IMAGES_V.UI_DEF_ID = 0

Columns

Name
ITEM_ID
ITEM_TYPE_ID
DESC_TEXT
REF_PART_NBR
QUOTEABLE_FLAG
LEAD_TIME
ITEM_STATUS
PRIMARY_UOM_CODE
ORIG_SYS_REF
CREATION_DATE
LAST_UPDATE_DATE
DELETED_FLAG
CREATED_BY
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
DECIMAL_QTY_FLAG
NOTES
SRC_APPLICATION_ID
ALT_TEXT
OBJECT_TYPE_DESC
IMAGE_FILE
FULL_IMAGE_PATH