SELECT ACC.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 CSM_FND_TERRITORIES_ACC ACC , FND_TERRITORIES B WHERE B.TERRITORY_CODE = ACC.TERRITORY_CODE
SELECT ACC.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 CSM_FND_TERRITORIES_ACC ACC
, FND_TERRITORIES B
WHERE B.TERRITORY_CODE = ACC.TERRITORY_CODE
|
|
|