SELECT A.ACCESS_ID, 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.EU_CODE FROM JTM_FND_TERRITORIES_ACC A, FND_TERRITORIES B WHERE B.TERRITORY_CODE = A.TERRITORY_CODE
SELECT A.ACCESS_ID
, 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.EU_CODE
FROM JTM_FND_TERRITORIES_ACC A
, FND_TERRITORIES B
WHERE B.TERRITORY_CODE = A.TERRITORY_CODE
|
|
|