VIEW: APPS.CZ_RP_PRJ_DIRECTORY_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'