VIEW: APPS.CZ_PRODUCTKEY_LOOKUP_V

Source

View Text - Preformatted

SELECT DISTINCT product_key FROM cz_model_publications WHERE deleted_flag = '0' AND object_type = 'PRJ' AND source_target_flag = 'T' AND export_status = 'OK' AND product_key IS NOT NULL

View Text - HTML Formatted

SELECT DISTINCT PRODUCT_KEY
FROM CZ_MODEL_PUBLICATIONS
WHERE DELETED_FLAG = '0'
AND OBJECT_TYPE = 'PRJ'
AND SOURCE_TARGET_FLAG = 'T'
AND EXPORT_STATUS = 'OK'
AND PRODUCT_KEY IS NOT NULL