[Home] [Help]
View: CZ_RP_DIRECTORY_V
Product: | CZ - Configurator |
Description: | Informational view of Repository with summary info for objects of each type |
Implementation/DBA Data: |
APPS.CZ_RP_DIRECTORY_V
|
View Text
SELECT OBJECT_TYPE
, OBJECT_ID
, ENCLOSING_FOLDER
, NAME
, NOTES AS SYNOPSIS
, DESCRIPTION
, DELETED_FLAG
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
FROM CZ_RP_ENTRIES UNION SELECT OBJECT_TYPE
, OBJECT_ID
, ENCLOSING_FOLDER
, NAME
, SYNOPSIS
, DESCRIPTION
, DELETED_FLAG
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
FROM CZ_RP_EFF_DIRECTORY_V UNION SELECT OBJECT_TYPE
, OBJECT_ID
, ENCLOSING_FOLDER
, NAME
, SYNOPSIS
, DESCRIPTION
, DELETED_FLAG
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
FROM CZ_RP_PRJ_DIRECTORY_V UNION SELECT OBJECT_TYPE
, OBJECT_ID
, ENCLOSING_FOLDER
, NAME
, SYNOPSIS
, DESCRIPTION
, DELETED_FLAG
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
FROM CZ_RP_USG_DIRECTORY_V
Columns
Name |
OBJECT_TYPE |
OBJECT_ID |
ENCLOSING_FOLDER |
NAME |
SYNOPSIS |
DESCRIPTION |
DELETED_FLAG |
CREATED_BY |
CREATION_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |