View: CZ_SRC_DEVL_PROJECTS_V

Product:	CZ - Configurator
Description:
Implementation/DBA Data:	APPS.CZ_SRC_DEVL_PROJECTS_V

View Text

SELECT PROJ.DEVL_PROJECT_ID
, PROJ.NAME
, NVL(TXT.TEXT_STR
, PROJ.DESC_TEXT) AS DESC_TEXT
, PROJ.ORIG_SYS_REF
, PROJ.CREATION_DATE
, PROJ.LAST_UPDATE_DATE
, PROJ.CREATED_BY
, PROJ.LAST_UPDATED_BY
, PROJ. MODEL_TYPE
, PROJ. ORGANIZATION_ID
, PROJ. INVENTORY_ITEM_ID
, PROJ. PRODUCT_KEY
FROM CZ_DEVL_PROJECTS PROJ
, CZ_LOCALIZED_TEXTS_VL TXT
, CZ_RP_ENTRIES RP
WHERE PROJ.DELETED_FLAG = '0'
AND PROJ.INTL_TEXT_ID = TXT.INTL_TEXT_ID(+)
AND PROJ.DEVL_PROJECT_ID = RP.OBJECT_ID
AND RP.OBJECT_TYPE='PRJ'
AND RP.DELETED_FLAG='0'

Columns