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.

VIEW: APPS.CZ_IM_ITEMS_V

Source

View Text - Preformatted


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

View Text - HTML Formatted

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