VIEW: APPS.CZ_RP_USG_DIRECTORY_V

Source

View Text - Preformatted

SELECT CZ_RP_ENTRIES.OBJECT_TYPE, CZ_RP_ENTRIES.OBJECT_ID, CZ_RP_ENTRIES.ENCLOSING_FOLDER, CZ_MODEL_USAGES.NAME, CZ_MODEL_USAGES.NAME||',CZ_MODEL_USAGES.MODEL_USAGE_ID '|| to_char(CZ_MODEL_USAGES.MODEL_USAGE_ID)|| decode(CZ_MODEL_USAGES.in_use,'1', ', active', 'not in use')||'. '||substr(CZ_MODEL_USAGES.description, 1, 150) AS SYNOPSIS, CZ_MODEL_USAGES.DESCRIPTION AS DESCRIPTION, DECODE(CZ_MODEL_USAGES.IN_USE,'X','1','0') AS DELETED_FLAG, CZ_MODEL_USAGES.CREATED_BY, CZ_MODEL_USAGES.CREATION_DATE, CZ_MODEL_USAGES.LAST_UPDATED_BY, CZ_MODEL_USAGES.LAST_UPDATE_DATE FROM CZ_MODEL_USAGES_VL CZ_MODEL_USAGES, CZ_RP_ENTRIES WHERE CZ_MODEL_USAGES.MODEL_USAGE_ID = CZ_RP_ENTRIES.OBJECT_ID AND CZ_RP_ENTRIES.OBJECT_TYPE='USG'

View Text - HTML Formatted

SELECT CZ_RP_ENTRIES.OBJECT_TYPE
, CZ_RP_ENTRIES.OBJECT_ID
, CZ_RP_ENTRIES.ENCLOSING_FOLDER
, CZ_MODEL_USAGES.NAME
, CZ_MODEL_USAGES.NAME||'
, CZ_MODEL_USAGES.MODEL_USAGE_ID '|| TO_CHAR(CZ_MODEL_USAGES.MODEL_USAGE_ID)|| DECODE(CZ_MODEL_USAGES.IN_USE
, '1'
, '
, ACTIVE'
, 'NOT IN USE')||'. '||SUBSTR(CZ_MODEL_USAGES.DESCRIPTION
, 1
, 150) AS SYNOPSIS
, CZ_MODEL_USAGES.DESCRIPTION AS DESCRIPTION
, DECODE(CZ_MODEL_USAGES.IN_USE
, 'X'
, '1'
, '0') AS DELETED_FLAG
, CZ_MODEL_USAGES.CREATED_BY
, CZ_MODEL_USAGES.CREATION_DATE
, CZ_MODEL_USAGES.LAST_UPDATED_BY
, CZ_MODEL_USAGES.LAST_UPDATE_DATE
FROM CZ_MODEL_USAGES_VL CZ_MODEL_USAGES
, CZ_RP_ENTRIES
WHERE CZ_MODEL_USAGES.MODEL_USAGE_ID = CZ_RP_ENTRIES.OBJECT_ID
AND CZ_RP_ENTRIES.OBJECT_TYPE='USG'