View: FND_TERRITORIES_VL

Product:	FND - Application Object Library
Description:	View of FND_TERRITORIES and FND_TERRITORIES_TL
Implementation/DBA Data:	APPS.FND_TERRITORIES_VL

View Text

SELECT B.ROWID ROW_ID
, B.EU_CODE
, B.TERRITORY_CODE
, B.LAST_UPDATE_DATE
, B.LAST_UPDATED_BY
, B.CREATION_DATE
, B.CREATED_BY
, B.ISO_NUMERIC_CODE
, B.ALTERNATE_TERRITORY_CODE
, B.LAST_UPDATE_LOGIN
, B.NLS_TERRITORY
, B.ADDRESS_STYLE
, B.ADDRESS_VALIDATION
, B.BANK_INFO_STYLE
, B.BANK_INFO_VALIDATION
, B.OBSOLETE_FLAG
, T.TERRITORY_SHORT_NAME
, T.DESCRIPTION
, B.ISO_TERRITORY_CODE
FROM FND_TERRITORIES_TL T
, FND_TERRITORIES B
WHERE B.TERRITORY_CODE = T.TERRITORY_CODE
AND T.LANGUAGE = USERENV('LANG')

Columns