View: CZ_RP_PRJ_DIRECTORY_V

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

View Text

SELECT CZ_RP_ENTRIES.OBJECT_TYPE
, CZ_RP_ENTRIES.OBJECT_ID
, CZ_RP_ENTRIES.ENCLOSING_FOLDER
, CZ_DEVL_PROJECTS.NAME
, CZ_DEVL_PROJECTS.NAME||DECODE(CZ_XFR_PROJECT_BILLS.ORGANIZATION_ID
, NULL
, ''
, ' IMPORTED
FROM ORG '||TO_CHAR(CZ_XFR_PROJECT_BILLS.ORGANIZATION_ID)||'
, TOP ITEM ' ||TO_CHAR(CZ_XFR_PROJECT_BILLS.TOP_ITEM_ID) || ')' ) || '
, STRUCTURE LAST MODIFIED ' ||TO_CHAR(CZ_DEVL_PROJECTS.LAST_STRUCT_UPDATE)||'. '||SUBSTR(CZ_DEVL_PROJECTS.DESC_TEXT
, 1
, 150) AS SYNOPSIS
, CZ_DEVL_PROJECTS.DESC_TEXT AS DESCRIPTION
, CZ_DEVL_PROJECTS.DELETED_FLAG
, CZ_DEVL_PROJECTS.CREATED_BY
, CZ_DEVL_PROJECTS.CREATION_DATE
, CZ_DEVL_PROJECTS.LAST_UPDATED_BY
, CZ_DEVL_PROJECTS.LAST_UPDATE_DATE
FROM CZ_DEVL_PROJECTS
, CZ_RP_ENTRIES
, CZ_PS_NODES
, CZ_XFR_PROJECT_BILLS
WHERE CZ_DEVL_PROJECTS.DEVL_PROJECT_ID = CZ_RP_ENTRIES.OBJECT_ID
AND CZ_DEVL_PROJECTS.DEVL_PROJECT_ID = CZ_PS_NODES.DEVL_PROJECT_ID
AND CZ_PS_NODES.PS_NODE_ID = CZ_XFR_PROJECT_BILLS.MODEL_PS_NODE_ID
AND CZ_RP_ENTRIES.OBJECT_TYPE='PRJ'

Columns