VIEW: APPS.RRS_LOCATIONS_V

Source

View Text - Preformatted

SELECT LOCATION_ID, LOCATION_ID as EXISTING_LOC_ID, LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN, REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, WH_UPDATE_DATE, ATTRIBUTE_CATEGORY, ATTRIBUTE1, ATTRIBUTE2, ATTRIBUTE3, ATTRIBUTE4, ATTRIBUTE5, ATTRIBUTE6, ATTRIBUTE7, ATTRIBUTE8, ATTRIBUTE9, ATTRIBUTE10, ATTRIBUTE11, ATTRIBUTE12, ATTRIBUTE13, ATTRIBUTE14, ATTRIBUTE15, ATTRIBUTE16, ATTRIBUTE17, ATTRIBUTE18, ATTRIBUTE19, ATTRIBUTE20, GLOBAL_ATTRIBUTE_CATEGORY, GLOBAL_ATTRIBUTE1, GLOBAL_ATTRIBUTE2, GLOBAL_ATTRIBUTE3, GLOBAL_ATTRIBUTE4, GLOBAL_ATTRIBUTE5, GLOBAL_ATTRIBUTE6, GLOBAL_ATTRIBUTE7, GLOBAL_ATTRIBUTE8, GLOBAL_ATTRIBUTE9, GLOBAL_ATTRIBUTE10, GLOBAL_ATTRIBUTE11, GLOBAL_ATTRIBUTE12, GLOBAL_ATTRIBUTE13, GLOBAL_ATTRIBUTE14, GLOBAL_ATTRIBUTE15, GLOBAL_ATTRIBUTE16, GLOBAL_ATTRIBUTE17, GLOBAL_ATTRIBUTE18, GLOBAL_ATTRIBUTE19, GLOBAL_ATTRIBUTE20, ORIG_SYSTEM_REFERENCE, COUNTRY, ADDRESS1, ADDRESS2, ADDRESS3, ADDRESS4, CITY, POSTAL_CODE, STATE, PROVINCE, COUNTY, ADDRESS_KEY, ADDRESS_STYLE, VALIDATED_FLAG, ADDRESS_LINES_PHONETIC, APARTMENT_FLAG, PO_BOX_NUMBER, HOUSE_NUMBER, STREET_SUFFIX, APARTMENT_NUMBER, SECONDARY_SUFFIX_ELEMENT, STREET, RURAL_ROUTE_TYPE, RURAL_ROUTE_NUMBER, STREET_NUMBER, BUILDING, FLOOR, SUITE, ROOM, POSTAL_PLUS4_CODE, TIME_ZONE, OVERSEAS_ADDRESS_FLAG, POST_OFFICE, POSITION, DELIVERY_POINT_CODE, LOCATION_DIRECTIONS, ADDRESS_EFFECTIVE_DATE, ADDRESS_EXPIRATION_DATE, ADDRESS_ERROR_CODE, CLLI_CODE, DODAAC, TRAILING_DIRECTORY_CODE, LANGUAGE, LIFE_CYCLE_STATUS, SHORT_DESCRIPTION, DESCRIPTION, CONTENT_SOURCE_TYPE, LOC_HIERARCHY_ID, SALES_TAX_GEOCODE, SALES_TAX_INSIDE_CITY_LIMITS, FA_LOCATION_ID, GEOMETRY, OBJECT_VERSION_NUMBER, CREATED_BY_MODULE, APPLICATION_ID, TIMEZONE_ID, GEOMETRY_STATUS_CODE, ACTUAL_CONTENT_SOURCE, VALIDATION_STATUS_CODE, DATE_VALIDATED, DO_NOT_VALIDATE_FLAG, (SELECT rlv.meaning FROM rrs_lookups_v rlv WHERE rlv.lookup_type = 'RRS_GEO_SOURCE' AND rlv.lookup_code = geometry_source) as GEOCODE_SOURCE, ROUND(hl.geometry.SDO_POINT.X,8) as LONGITUDE, ROUND(hl.geometry.SDO_POINT.Y,8) as LATITUDE FROM HZ_LOCATIONS hl

View Text - HTML Formatted

SELECT LOCATION_ID
, LOCATION_ID AS EXISTING_LOC_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, WH_UPDATE_DATE
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE16
, ATTRIBUTE17
, ATTRIBUTE18
, ATTRIBUTE19
, ATTRIBUTE20
, GLOBAL_ATTRIBUTE_CATEGORY
, GLOBAL_ATTRIBUTE1
, GLOBAL_ATTRIBUTE2
, GLOBAL_ATTRIBUTE3
, GLOBAL_ATTRIBUTE4
, GLOBAL_ATTRIBUTE5
, GLOBAL_ATTRIBUTE6
, GLOBAL_ATTRIBUTE7
, GLOBAL_ATTRIBUTE8
, GLOBAL_ATTRIBUTE9
, GLOBAL_ATTRIBUTE10
, GLOBAL_ATTRIBUTE11
, GLOBAL_ATTRIBUTE12
, GLOBAL_ATTRIBUTE13
, GLOBAL_ATTRIBUTE14
, GLOBAL_ATTRIBUTE15
, GLOBAL_ATTRIBUTE16
, GLOBAL_ATTRIBUTE17
, GLOBAL_ATTRIBUTE18
, GLOBAL_ATTRIBUTE19
, GLOBAL_ATTRIBUTE20
, ORIG_SYSTEM_REFERENCE
, COUNTRY
, ADDRESS1
, ADDRESS2
, ADDRESS3
, ADDRESS4
, CITY
, POSTAL_CODE
, STATE
, PROVINCE
, COUNTY
, ADDRESS_KEY
, ADDRESS_STYLE
, VALIDATED_FLAG
, ADDRESS_LINES_PHONETIC
, APARTMENT_FLAG
, PO_BOX_NUMBER
, HOUSE_NUMBER
, STREET_SUFFIX
, APARTMENT_NUMBER
, SECONDARY_SUFFIX_ELEMENT
, STREET
, RURAL_ROUTE_TYPE
, RURAL_ROUTE_NUMBER
, STREET_NUMBER
, BUILDING
, FLOOR
, SUITE
, ROOM
, POSTAL_PLUS4_CODE
, TIME_ZONE
, OVERSEAS_ADDRESS_FLAG
, POST_OFFICE
, POSITION
, DELIVERY_POINT_CODE
, LOCATION_DIRECTIONS
, ADDRESS_EFFECTIVE_DATE
, ADDRESS_EXPIRATION_DATE
, ADDRESS_ERROR_CODE
, CLLI_CODE
, DODAAC
, TRAILING_DIRECTORY_CODE
, LANGUAGE
, LIFE_CYCLE_STATUS
, SHORT_DESCRIPTION
, DESCRIPTION
, CONTENT_SOURCE_TYPE
, LOC_HIERARCHY_ID
, SALES_TAX_GEOCODE
, SALES_TAX_INSIDE_CITY_LIMITS
, FA_LOCATION_ID
, GEOMETRY
, OBJECT_VERSION_NUMBER
, CREATED_BY_MODULE
, APPLICATION_ID
, TIMEZONE_ID
, GEOMETRY_STATUS_CODE
, ACTUAL_CONTENT_SOURCE
, VALIDATION_STATUS_CODE
, DATE_VALIDATED
, DO_NOT_VALIDATE_FLAG
, (SELECT RLV.MEANING
FROM RRS_LOOKUPS_V RLV
WHERE RLV.LOOKUP_TYPE = 'RRS_GEO_SOURCE'
AND RLV.LOOKUP_CODE = GEOMETRY_SOURCE) AS GEOCODE_SOURCE
, ROUND(HL.GEOMETRY.SDO_POINT.X
, 8) AS LONGITUDE
, ROUND(HL.GEOMETRY.SDO_POINT.Y
, 8) AS LATITUDE
FROM HZ_LOCATIONS HL