[Home] [Help]
View: 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
Name |
DEVL_PROJECT_ID |
NAME |
DESC_TEXT |
ORIG_SYS_REF |
CREATION_DATE |
LAST_UPDATE_DATE |
CREATED_BY |
LAST_UPDATED_BY |
MODEL_TYPE |
ORGANIZATION_ID |
INVENTORY_ITEM_ID |
PRODUCT_KEY |