View: CZ_RP_USG_DIRECTORY_V

Product:	CZ - Configurator
Description:	Information view of Usages in Repository
Implementation/DBA Data:	APPS.CZ_RP_USG_DIRECTORY_V

View Text

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'

Columns