View: AR_LOCATION_RATES

Product:	FND - Application Object Library
Description:
Implementation/DBA Data:	APPS.AR_LOCATION_RATES

View Text

SELECT GEO.GEOGRAPHY_ID LOCATION_RATE_ID
, GEO.LAST_UPDATE_DATE LAST_UPDATE_DATE
, GEO.LAST_UPDATED_BY LAST_UPDATED_BY
, GEO.CREATED_BY CREATED_BY
, GEO.CREATION_DATE CREATION_DATE
, NULL OVERRIDE_STRUCTURE_ID
, REL.OBJECT_ID LOCATION_SEGMENT_ID
, GEO.START_DATE START_DATE
, GEO.END_DATE END_DATE
, GEO.GEOGRAPHY_NAME FROM_POSTAL_CODE
, GEO.GEOGRAPHY_NAME TO_POSTAL_CODE
, NULL TAX_RATE
, GEO.REQUEST_ID REQUEST_ID
, GEO.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, GEO.PROGRAM_ID PROGRAM_ID
, NULL PROGRAM_UPDATE_DATE
, GEO.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, GEO.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, GEO.GEOGRAPHY_CODE ATTRIBUTE1
, GEO.ATTRIBUTE2 ATTRIBUTE2
, GEO.ATTRIBUTE3 ATTRIBUTE3
, GEO.ATTRIBUTE4 ATTRIBUTE4
, GEO.ATTRIBUTE5 ATTRIBUTE5
, GEO.ATTRIBUTE6 ATTRIBUTE6
, GEO.ATTRIBUTE7 ATTRIBUTE7
, GEO.ATTRIBUTE8 ATTRIBUTE8
, GEO.ATTRIBUTE9 ATTRIBUTE9
, GEO.ATTRIBUTE10 ATTRIBUTE10
, GEO.ATTRIBUTE11 ATTRIBUTE11
, GEO.ATTRIBUTE12 ATTRIBUTE12
, GEO.ATTRIBUTE13 ATTRIBUTE13
, GEO.ATTRIBUTE14 ATTRIBUTE14
, GEO.ATTRIBUTE15 ATTRIBUTE15
, NULL OVERRIDE_RATE1
, NULL OVERRIDE_RATE2
, NULL OVERRIDE_RATE3
, NULL OVERRIDE_RATE4
, NULL OVERRIDE_RATE5
, NULL OVERRIDE_RATE6
, NULL OVERRIDE_RATE7
, NULL OVERRIDE_RATE8
, NULL OVERRIDE_RATE9
, NULL OVERRIDE_RATE10
FROM HZ_GEOGRAPHIES GEO
, HZ_RELATIONSHIPS REL
WHERE GEO.GEOGRAPHY_ID = REL.SUBJECT_ID
AND REL.RELATIONSHIP_CODE = 'CHILD_OF'
AND GEO.GEOGRAPHY_TYPE = REL.SUBJECT_TYPE
AND GEO.GEOGRAPHY_USE = 'MASTER_REF'
AND REL.OBJECT_TYPE = 'CITY'
AND REL.SUBJECT_TYPE = 'POSTAL_CODE'