[Home] [Help]
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
Name |
OBJECT_TYPE |
OBJECT_ID |
ENCLOSING_FOLDER |
NAME |
SYNOPSIS |
DESCRIPTION |
DELETED_FLAG |
CREATED_BY |
CREATION_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |