FND_TERRITORIES_VL

Details

• Schema: REFDATA

• Object owner: FND

• Object type: VIEW

Columns

Name
ROW_ID EU_CODE TERRITORY_CODE ISO_NUMERIC_CODE ALTERNATE_TERRITORY_CODE NLS_TERRITORY ADDRESS_STYLE ADDRESS_VALIDATION BANK_INFO_STYLE BANK_INFO_VALIDATION OBSOLETE_FLAG ENABLED_FLAG TERRITORY_SHORT_NAME DESCRIPTION ISO_TERRITORY_CODE CURRENCY_CODE CREATION_DATE CREATED_BY LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN

Query

SQL_Statement

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