Configured address style format for all the countries

SELECT 

FND.TERRITORY_SHORT_NAME,

B.ATTRIBUTE_CODE,

B.STYLE_FORMAT_CODE, 

L.TERRITORY_CODE

FROM FUSION.HZ_STYLE_FMT_LAYOUTS_B B ,

FUSION.HZ_STYLE_FMT_LOCALES L ,

FND_TERRITORIES_TL FND


WHERE B.STYLE_FORMAT_CODE LIKE 'POSTAL_ADDR%'

AND B.STYLE_FORMAT_CODE=L.STYLE_FORMAT_CODE

AND FND.TERRITORY_CODE = L.TERRITORY_CODE

AND FND.LANGUAGE='US'

ORDER BY STYLE_FORMAT_CODE

Comments