1. Tables and Views for Procurement
  2. POR_CONTENT_ZONES_ALL_VL

POR_CONTENT_ZONES_ALL_VL

Details

  • Schema: FUSION

  • Object owner: POR

  • Object type: VIEW

Columns

Name

CONTENT_ZONE_ID

PRC_BU_ID

SECURITY_DIMENSION

USAGE

CONTENT_ZONE_NAME

DESCRIPTION

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

OBJECT_VERSION_NUMBER

Query

SQL_Statement

SELECT

POR_CONTENT_ZONES_ALL_B.CONTENT_ZONE_ID CONTENT_ZONE_ID,

POR_CONTENT_ZONES_ALL_B.PRC_BU_ID PRC_BU_ID,

POR_CONTENT_ZONES_ALL_B.SECURITY_DIMENSION SECURITY_DIMENSION,

POR_CONTENT_ZONES_ALL_B.USAGE USAGE,

POR_CONTENT_ZONES_ALL_TL.CONTENT_ZONE_NAME CONTENT_ZONE_NAME,

POR_CONTENT_ZONES_ALL_TL.DESCRIPTION DESCRIPTION,

POR_CONTENT_ZONES_ALL_B.CREATED_BY CREATED_BY,

POR_CONTENT_ZONES_ALL_B.CREATION_DATE CREATION_DATE,

POR_CONTENT_ZONES_ALL_B.LAST_UPDATED_BY LAST_UPDATED_BY,

POR_CONTENT_ZONES_ALL_B.LAST_UPDATE_DATE LAST_UPDATE_DATE,

POR_CONTENT_ZONES_ALL_B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN,

POR_CONTENT_ZONES_ALL_B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER

FROM

POR_CONTENT_ZONES_ALL_B, POR_CONTENT_ZONES_ALL_TL

WHERE

POR_CONTENT_ZONES_ALL_TL.CONTENT_ZONE_ID = POR_CONTENT_ZONES_ALL_B.CONTENT_ZONE_ID AND POR_CONTENT_ZONES_ALL_TL.LANGUAGE = USERENV('LANG')