VIEW: APPS.CZ_SRC_DEVL_PROJECTS_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'