Loading of States for Colombia
Hi
We are trying to use LOV for state field for vendor sites for colombia country,
Created Value set for DFF field (Address) STATE using value set HZ_CO_STATES based on table HZ_GEOGRAPHIES
and where clause
WHERE GEOGRAPHY_TYPE = 'STATE'
AND COUNTRY_CODE = 'CO'
AND SYSDATE >= START_DATE
AND SYSDATE <= NVL(END_DATE, SYSDATE)
ORDER BY GEOGRAPHY_CODE
For now only 3 values are available (DISTRITO CAPITAL, NO_STATE_VALUE, SANTA FE) We need to add more states to this list would like to know is there a way to add
states to geographies is there anyway to add states for colombia.