VIEW: APPS.CZ_ITEMMASTER_HGRID_V

Source

View Text - Preformatted

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 )

View Text - HTML Formatted

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 )