VIEW: APPS.BIM_DIMV_GEOGRAPHY

Source

View Text - Preformatted

SELECT geo.LOCATION_HIERARCHY_CODE LOCATION_HIERARCHY_CODE ,geo.LAST_UPDATE_DATE LAST_UPDATE_DATE ,geo.country country ,nvl(geo.country,'-999') country_code ,geo.state state ,nvl(geo.state,'-999') state_code ,geo.city city ,nvl(geo.city, '-999') city_code ,geo.postal_code postal_code ,nvl(geo.postal_code, '-999') postal_code_value From BIM_GEOGRAPHY geo UNION ALL SELECT '-999' , TO_DATE(NULL) , MEANING , '-999' , MEANING , '-999' , MEANING , '-999' , MEANING , '-999' FROM FND_LOOKUPS WHERE LOOKUP_TYPE = 'BIM_VALUE_TYPE' AND LOOKUP_CODE = '-999'

View Text - HTML Formatted

SELECT GEO.LOCATION_HIERARCHY_CODE LOCATION_HIERARCHY_CODE
, GEO.LAST_UPDATE_DATE LAST_UPDATE_DATE
, GEO.COUNTRY COUNTRY
, NVL(GEO.COUNTRY
, '-999') COUNTRY_CODE
, GEO.STATE STATE
, NVL(GEO.STATE
, '-999') STATE_CODE
, GEO.CITY CITY
, NVL(GEO.CITY
, '-999') CITY_CODE
, GEO.POSTAL_CODE POSTAL_CODE
, NVL(GEO.POSTAL_CODE
, '-999') POSTAL_CODE_VALUE
FROM BIM_GEOGRAPHY GEO UNION ALL SELECT '-999'
, TO_DATE(NULL)
, MEANING
, '-999'
, MEANING
, '-999'
, MEANING
, '-999'
, MEANING
, '-999'
FROM FND_LOOKUPS
WHERE LOOKUP_TYPE = 'BIM_VALUE_TYPE'
AND LOOKUP_CODE = '-999'