[Home] [Help]
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
Name |
ROW_ID |
EU_CODE |
TERRITORY_CODE |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
CREATION_DATE |
CREATED_BY |
ISO_NUMERIC_CODE |
ALTERNATE_TERRITORY_CODE |
LAST_UPDATE_LOGIN |
NLS_TERRITORY |
ADDRESS_STYLE |
ADDRESS_VALIDATION |
BANK_INFO_STYLE |
BANK_INFO_VALIDATION |
OBSOLETE_FLAG |
TERRITORY_SHORT_NAME |
DESCRIPTION |
ISO_TERRITORY_CODE |