VIEW: APPS.CZ_ITEM_ITEM_POP_V

Source

View Text - Preformatted

SELECT cz_item_masters.item_type_id as item_type_id, cz_item_masters.item_id as item_id, to_number(NULL) as property_id, cz_item_types.name as item_type_name, cz_item_masters.ref_part_nbr as item_master_name, to_char(NULL) as property_name, cz_item_masters.ref_part_nbr as name, cz_item_masters.desc_text as desc_text, cz_item_masters.quoteable_flag as quoteable_flag , cz_item_masters.primary_uom_code as primary_uom_code from cz_item_masters, cz_item_types WHERE (cz_item_types.item_type_id=cz_item_masters.item_type_id) and nvl (cz_item_masters.deleted_flag, '0') <> '1' and nvl (cz_item_types.deleted_flag, '0') <> '1'

View Text - HTML Formatted

SELECT CZ_ITEM_MASTERS.ITEM_TYPE_ID AS ITEM_TYPE_ID
, CZ_ITEM_MASTERS.ITEM_ID AS ITEM_ID
, TO_NUMBER(NULL) AS PROPERTY_ID
, CZ_ITEM_TYPES.NAME AS ITEM_TYPE_NAME
, CZ_ITEM_MASTERS.REF_PART_NBR AS ITEM_MASTER_NAME
, TO_CHAR(NULL) AS PROPERTY_NAME
, CZ_ITEM_MASTERS.REF_PART_NBR AS NAME
, CZ_ITEM_MASTERS.DESC_TEXT AS DESC_TEXT
, CZ_ITEM_MASTERS.QUOTEABLE_FLAG AS QUOTEABLE_FLAG
, CZ_ITEM_MASTERS.PRIMARY_UOM_CODE AS PRIMARY_UOM_CODE
FROM CZ_ITEM_MASTERS
, CZ_ITEM_TYPES
WHERE (CZ_ITEM_TYPES.ITEM_TYPE_ID=CZ_ITEM_MASTERS.ITEM_TYPE_ID)
AND NVL (CZ_ITEM_MASTERS.DELETED_FLAG
, '0') <> '1'
AND NVL (CZ_ITEM_TYPES.DELETED_FLAG
, '0') <> '1'