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