VIEW: APPS.ZPB_BUSINESS_AREAS_VL

Source

View Text - Preformatted

SELECT A.ROWID ROW_ID, A.BUSINESS_AREA_ID, nvl (C.NAME, B.NAME) NAME, (CASE nvl(C.NAME, 'ZYXW4321') WHEN 'ZYXW4321' THEN B.DESCRIPTION ELSE C.DESCRIPTION END) DESCRIPTION, nvl (C.CURRENCY_ENABLED, B.CURRENCY_ENABLED) CURRENCY_ENABLED, A.REFRESH_DATE, A.REFRESHED_BY, A.PUBLISH_DATE, A.PUBLISHED_BY, A.BUSAREA_CREATED_BY, A.LAST_AW_UPDATE, A.STATUS, A.CREATION_DATE, A.CREATED_BY, A.LAST_UPDATE_LOGIN, A.LAST_UPDATE_DATE, A.LAST_UPDATED_BY from ZPB_BUSINESS_AREAS A, ZPB_BUSAREA_VERSIONS B, ZPB_BUSAREA_VERSIONS C WHERE A.BUSINESS_AREA_ID = B.BUSINESS_AREA_ID and B.VERSION_TYPE = 'D' and A.BUSINESS_AREA_ID = C.BUSINESS_AREA_ID(+) and C.VERSION_TYPE(+) = 'P'

View Text - HTML Formatted

SELECT A.ROWID ROW_ID
, A.BUSINESS_AREA_ID
, NVL (C.NAME
, B.NAME) NAME
, (CASE NVL(C.NAME
, 'ZYXW4321') WHEN 'ZYXW4321' THEN B.DESCRIPTION ELSE C.DESCRIPTION END) DESCRIPTION
, NVL (C.CURRENCY_ENABLED
, B.CURRENCY_ENABLED) CURRENCY_ENABLED
, A.REFRESH_DATE
, A.REFRESHED_BY
, A.PUBLISH_DATE
, A.PUBLISHED_BY
, A.BUSAREA_CREATED_BY
, A.LAST_AW_UPDATE
, A.STATUS
, A.CREATION_DATE
, A.CREATED_BY
, A.LAST_UPDATE_LOGIN
, A.LAST_UPDATE_DATE
, A.LAST_UPDATED_BY
FROM ZPB_BUSINESS_AREAS A
, ZPB_BUSAREA_VERSIONS B
, ZPB_BUSAREA_VERSIONS C
WHERE A.BUSINESS_AREA_ID = B.BUSINESS_AREA_ID
AND B.VERSION_TYPE = 'D'
AND A.BUSINESS_AREA_ID = C.BUSINESS_AREA_ID(+)
AND C.VERSION_TYPE(+) = 'P'