[Home] [Help]
View: XNP_GEO_AREAS_VL
Product: | XNP - Number Portability |
Description: | Multilingual view to table XNP_GEO_AREAS_B |
Implementation/DBA Data: |
APPS.XNP_GEO_AREAS_VL
|
View Text
SELECT B.ROWID ROW_ID
, B.GEO_AREA_ID
, B.GEO_AREA_TYPE_CODE
, B.CODE
, B.ACTIVE_FLAG
, B.CREATED_BY
, B.CREATION_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_DATE
, B.LAST_UPDATE_LOGIN
, T.DISPLAY_NAME
, T.DESCRIPTION
FROM XNP_GEO_AREAS_TL T
, XNP_GEO_AREAS_B B
WHERE B.GEO_AREA_ID = T.GEO_AREA_ID
AND T.LANGUAGE = USERENV('LANG')
Columns
Name |
ROW_ID |
GEO_AREA_ID |
GEO_AREA_TYPE_CODE |
CODE |
ACTIVE_FLAG |
CREATED_BY |
CREATION_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |
LAST_UPDATE_LOGIN |
DISPLAY_NAME |
DESCRIPTION |