Product: | AST - TeleSales |
---|---|
Description: | |
Implementation/DBA Data: | APPS.AST_LOCATIONS_V |
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
, TM.NAME
, TM.NAME
, TM.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_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')