View: CZ_ITEMMASTER_HGRID_V

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

View Text

SELECT OBJECT_ID
, OBJECT_TYPE
, PARENT_OBJECT_ID
, PARENT_OBJECT_TYPE
, NAME
, DESC_TEXT
, ORIG_SYS_REF
, DELETED_FLAG
, CREATION_DATE
, LAST_UPDATE_DATE
, CREATED_BY
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, ALT_TEXT
, FULL_IMAGE_PATH
, QUOTEABLE_FLAG
FROM ( SELECT 0 AS OBJECT_ID
, 'NUL' AS OBJECT_TYPE
, TO_NUMBER(NULL) AS PARENT_OBJECT_ID
, TO_CHAR(NULL) AS PARENT_OBJECT_TYPE
, 'ITEM MASTER' AS NAME
, 'ITEM MASTER ROOT NODE' AS DESC_TEXT
, TO_CHAR(NULL) AS ORIG_SYS_REF
, '0' AS DELETED_FLAG
, TO_DATE(NULL) AS CREATION_DATE
, TO_DATE(NULL) AS LAST_UPDATE_DATE
, TO_NUMBER(NULL) AS CREATED_BY
, TO_NUMBER(NULL) AS LAST_UPDATED_BY
, TO_NUMBER(NULL) AS LAST_UPDATE_LOGIN
, CZ_RPOBJECTTYPES_LKV.VALUE_DESCRIPTION AS ALT_TEXT
, CZ_UI_PATHED_IMAGES_V.FULL_IMAGE_PATH
, TO_CHAR(NULL) AS QUOTEABLE_FLAG
FROM CZ_RPOBJECTTYPES_LKV
, CZ_UI_PATHED_IMAGES_V
WHERE CZ_RPOBJECTTYPES_LKV.DATA_VALUE = 'ITY'
AND CZ_UI_PATHED_IMAGES_V.ENTITY_CODE = CZ_RPOBJECTTYPES_LKV.NUMERIC_ID_VALUE
AND CZ_UI_PATHED_IMAGES_V.IMAGE_USAGE_CODE = 30
AND CZ_UI_PATHED_IMAGES_V.UI_DEF_ID = 0 UNION ALL SELECT CZ_ITEM_TYPES.ITEM_TYPE_ID AS OBJECT_ID
, 'ITY' AS OBJECT_TYPE
, 0 AS PARENT_OBJECT_ID
, 'NUL' AS PARENT_OBJECT_TYPE
, CZ_ITEM_TYPES.NAME
, CZ_ITEM_TYPES.DESC_TEXT
, CZ_ITEM_TYPES.ORIG_SYS_REF
, CZ_ITEM_TYPES.DELETED_FLAG
, CZ_ITEM_TYPES.CREATION_DATE
, CZ_ITEM_TYPES.LAST_UPDATE_DATE
, CZ_ITEM_TYPES.CREATED_BY
, CZ_ITEM_TYPES.LAST_UPDATED_BY
, CZ_ITEM_TYPES.LAST_UPDATE_LOGIN
, CZ_RPOBJECTTYPES_LKV.VALUE_DESCRIPTION AS ALT_TEXT
, CZ_UI_PATHED_IMAGES_V.FULL_IMAGE_PATH
, TO_CHAR(NULL) AS QUOTEABLE_FLAG
FROM CZ_ITEM_TYPES
, CZ_RPOBJECTTYPES_LKV
, CZ_UI_PATHED_IMAGES_V
WHERE CZ_ITEM_TYPES.DELETED_FLAG = '0'
AND CZ_RPOBJECTTYPES_LKV.DATA_VALUE = 'ITY'
AND CZ_UI_PATHED_IMAGES_V.ENTITY_CODE = CZ_RPOBJECTTYPES_LKV.NUMERIC_ID_VALUE
AND CZ_UI_PATHED_IMAGES_V.IMAGE_USAGE_CODE = 30
AND CZ_UI_PATHED_IMAGES_V.UI_DEF_ID = 0 UNION ALL SELECT CZ_ITEM_MASTERS.ITEM_ID AS OBJECT_ID
, 'ITM' AS OBJECT_TYPE
, CZ_ITEM_MASTERS.ITEM_TYPE_ID AS PARENT_OBJECT_ID
, 'ITY' AS PARENT_OBJECT_TYPE
, CZ_ITEM_MASTERS.REF_PART_NBR AS NAME
, CZ_ITEM_MASTERS.DESC_TEXT
, CZ_ITEM_MASTERS.ORIG_SYS_REF
, CZ_ITEM_MASTERS.DELETED_FLAG
, CZ_ITEM_MASTERS.CREATION_DATE
, CZ_ITEM_MASTERS.LAST_UPDATE_DATE
, CZ_ITEM_MASTERS.CREATED_BY
, CZ_ITEM_MASTERS.LAST_UPDATED_BY
, CZ_ITEM_MASTERS.LAST_UPDATE_LOGIN
, CZ_RPOBJECTTYPES_LKV.VALUE_DESCRIPTION AS ALT_TEXT
, CZ_UI_PATHED_IMAGES_V.FULL_IMAGE_PATH
, CZ_ITEM_MASTERS.QUOTEABLE_FLAG
FROM CZ_ITEM_MASTERS
, CZ_ITEM_TYPES
, CZ_RPOBJECTTYPES_LKV
, CZ_UI_PATHED_IMAGES_V
WHERE CZ_ITEM_MASTERS.DELETED_FLAG = '0'
AND CZ_ITEM_TYPES.DELETED_FLAG = '0'
AND CZ_ITEM_MASTERS.ITEM_TYPE_ID = CZ_ITEM_TYPES.ITEM_TYPE_ID
AND CZ_RPOBJECTTYPES_LKV.DATA_VALUE = 'ITM'
AND CZ_UI_PATHED_IMAGES_V.ENTITY_CODE = CZ_RPOBJECTTYPES_LKV.NUMERIC_ID_VALUE
AND CZ_UI_PATHED_IMAGES_V.IMAGE_USAGE_CODE = 30
AND CZ_UI_PATHED_IMAGES_V.UI_DEF_ID = 0 )

Columns