VIEW: APPS.AST_LOCATIONS_V

Source

View Text - Preformatted

SELECT SITE.ROWID, SITE.PARTY_ID, LOC.LOCATION_ID, SITE.PARTY_SITE_ID, SITE.PARTY_SITE_NUMBER, SITE.MAILSTOP, SITE.STATUS, LOC.ADDRESS1, LOC.ADDRESS2, LOC.ADDRESS3, LOC.ADDRESS4, LOC.CITY, LOC.STATE, LOC.PROVINCE, LOC.POSTAL_CODE, LOC.COUNTY, LOC.COUNTRY, FND.TERRITORY_SHORT_NAME, LOC.ADDRESS_LINES_PHONETIC, LOC.PO_BOX_NUMBER, LOC.HOUSE_NUMBER, LOC.STREET_SUFFIX, LOC.STREET, LOC.STREET_NUMBER, LOC.FLOOR, LOC.SUITE, LOC.POSTAL_PLUS4_CODE, tz_tl.NAME, tz_tl.NAME, tz.UPGRADE_TZ_ID, SITE.IDENTIFYING_ADDRESS_FLAG, LOC.LAST_UPDATE_DATE, LOC.LAST_UPDATED_BY, LOC.LAST_UPDATE_LOGIN, LOC.CREATED_BY, LOC.CREATION_DATE, SITE.LAST_UPDATE_DATE , SITE.START_DATE_ACTIVE, SITE.END_DATE_ACTIVE, LOC.ADDRESS_EFFECTIVE_DATE, LOC.ADDRESS_EXPIRATION_DATE, LOC.ADDRESS_STYLE, LOC.OBJECT_VERSION_NUMBER, LOC.APPLICATION_ID, LOC.CREATED_BY_MODULE, SITE.OBJECT_VERSION_NUMBER, SITE.APPLICATION_ID, SITE.CREATED_BY_MODULE, SITE.PARTY_SITE_NAME, SITE.ATTRIBUTE_CATEGORY, SITE.ATTRIBUTE1, SITE.ATTRIBUTE2, SITE.ATTRIBUTE3, SITE.ATTRIBUTE4, SITE.ATTRIBUTE5, SITE.ATTRIBUTE6, SITE.ATTRIBUTE7, SITE.ATTRIBUTE8, SITE.ATTRIBUTE9, SITE.ATTRIBUTE10, SITE.ATTRIBUTE11, SITE.ATTRIBUTE12, SITE.ATTRIBUTE13, SITE.ATTRIBUTE14, SITE.ATTRIBUTE15, SITE.ATTRIBUTE16, SITE.ATTRIBUTE17, SITE.ATTRIBUTE18, SITE.ATTRIBUTE19, SITE.ATTRIBUTE20 FROM HZ_PARTY_SITES SITE, HZ_LOCATIONS LOC, FND_TERRITORIES_TL FND, fnd_timezones_b tz, fnd_timezones_tl tz_tl WHERE SITE.LOCATION_ID = LOC.LOCATION_ID AND LOC.COUNTRY= FND.TERRITORY_CODE(+) AND tz.UPGRADE_TZ_ID(+) = LOC.TIMEZONE_ID AND FND.LANGUAGE(+) = userenv('LANG') AND SITE.status IN ('A','I') AND tz.TIMEZONE_CODE = tz_tl.TIMEZONE_CODE(+) AND tz_tl.language(+) = USERENV('LANG')

View Text - HTML Formatted

SELECT SITE.ROWID
, SITE.PARTY_ID
, LOC.LOCATION_ID
, SITE.PARTY_SITE_ID
, SITE.PARTY_SITE_NUMBER
, SITE.MAILSTOP
, SITE.STATUS
, LOC.ADDRESS1
, LOC.ADDRESS2
, LOC.ADDRESS3
, LOC.ADDRESS4
, LOC.CITY
, LOC.STATE
, LOC.PROVINCE
, LOC.POSTAL_CODE
, LOC.COUNTY
, LOC.COUNTRY
, FND.TERRITORY_SHORT_NAME
, LOC.ADDRESS_LINES_PHONETIC
, LOC.PO_BOX_NUMBER
, LOC.HOUSE_NUMBER
, LOC.STREET_SUFFIX
, LOC.STREET
, LOC.STREET_NUMBER
, LOC.FLOOR
, LOC.SUITE
, LOC.POSTAL_PLUS4_CODE
, TZ_TL.NAME
, TZ_TL.NAME
, TZ.UPGRADE_TZ_ID
, SITE.IDENTIFYING_ADDRESS_FLAG
, LOC.LAST_UPDATE_DATE
, LOC.LAST_UPDATED_BY
, LOC.LAST_UPDATE_LOGIN
, LOC.CREATED_BY
, LOC.CREATION_DATE
, SITE.LAST_UPDATE_DATE
, SITE.START_DATE_ACTIVE
, SITE.END_DATE_ACTIVE
, LOC.ADDRESS_EFFECTIVE_DATE
, LOC.ADDRESS_EXPIRATION_DATE
, LOC.ADDRESS_STYLE
, LOC.OBJECT_VERSION_NUMBER
, LOC.APPLICATION_ID
, LOC.CREATED_BY_MODULE
, SITE.OBJECT_VERSION_NUMBER
, SITE.APPLICATION_ID
, SITE.CREATED_BY_MODULE
, SITE.PARTY_SITE_NAME
, SITE.ATTRIBUTE_CATEGORY
, SITE.ATTRIBUTE1
, SITE.ATTRIBUTE2
, SITE.ATTRIBUTE3
, SITE.ATTRIBUTE4
, SITE.ATTRIBUTE5
, SITE.ATTRIBUTE6
, SITE.ATTRIBUTE7
, SITE.ATTRIBUTE8
, SITE.ATTRIBUTE9
, SITE.ATTRIBUTE10
, SITE.ATTRIBUTE11
, SITE.ATTRIBUTE12
, SITE.ATTRIBUTE13
, SITE.ATTRIBUTE14
, SITE.ATTRIBUTE15
, SITE.ATTRIBUTE16
, SITE.ATTRIBUTE17
, SITE.ATTRIBUTE18
, SITE.ATTRIBUTE19
, SITE.ATTRIBUTE20
FROM HZ_PARTY_SITES SITE
, HZ_LOCATIONS LOC
, FND_TERRITORIES_TL FND
, FND_TIMEZONES_B TZ
, FND_TIMEZONES_TL TZ_TL
WHERE SITE.LOCATION_ID = LOC.LOCATION_ID
AND LOC.COUNTRY= FND.TERRITORY_CODE(+)
AND TZ.UPGRADE_TZ_ID(+) = LOC.TIMEZONE_ID
AND FND.LANGUAGE(+) = USERENV('LANG')
AND SITE.STATUS IN ('A'
, 'I')
AND TZ.TIMEZONE_CODE = TZ_TL.TIMEZONE_CODE(+)
AND TZ_TL.LANGUAGE(+) = USERENV('LANG')