VIEW: APPS.IEX_LOCATIONS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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