Product: | IBE - iStore |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT L.LOCATION_ID
, L.LAST_UPDATE_DATE
, L.LAST_UPDATED_BY
, L.CREATION_DATE
, L.CREATED_BY
, L.LAST_UPDATE_LOGIN
, L.REQUEST_ID
, L.PROGRAM_APPLICATION_ID
, L.PROGRAM_ID
, L.PROGRAM_UPDATE_DATE
, L.WH_UPDATE_DATE
, L.ATTRIBUTE_CATEGORY
, L.ATTRIBUTE1
, L.ATTRIBUTE2
, L.ATTRIBUTE3
, L.ATTRIBUTE4
, L.ATTRIBUTE5
, L.ATTRIBUTE6
, L.ATTRIBUTE7
, L.ATTRIBUTE8
, L.ATTRIBUTE9
, L.ATTRIBUTE10
, L.ATTRIBUTE11
, L.ATTRIBUTE12
, L.ATTRIBUTE13
, L.ATTRIBUTE14
, L.ATTRIBUTE15
, L.ATTRIBUTE16
, L.ATTRIBUTE17
, L.ATTRIBUTE18
, L.ATTRIBUTE19
, L.ATTRIBUTE20
, L.GLOBAL_ATTRIBUTE_CATEGORY
, L.GLOBAL_ATTRIBUTE1
, L.GLOBAL_ATTRIBUTE2
, L.GLOBAL_ATTRIBUTE3
, L.GLOBAL_ATTRIBUTE4
, L.GLOBAL_ATTRIBUTE5
, L.GLOBAL_ATTRIBUTE6
, L.GLOBAL_ATTRIBUTE7
, L.GLOBAL_ATTRIBUTE8
, L.GLOBAL_ATTRIBUTE9
, L.GLOBAL_ATTRIBUTE10
, L.GLOBAL_ATTRIBUTE11
, L.GLOBAL_ATTRIBUTE12
, L.GLOBAL_ATTRIBUTE13
, L.GLOBAL_ATTRIBUTE14
, L.GLOBAL_ATTRIBUTE15
, L.GLOBAL_ATTRIBUTE16
, L.GLOBAL_ATTRIBUTE17
, L.GLOBAL_ATTRIBUTE18
, L.GLOBAL_ATTRIBUTE19
, L.GLOBAL_ATTRIBUTE20
, L.ORIG_SYSTEM_REFERENCE
, L.COUNTRY
, L.ADDRESS1
, L.ADDRESS2
, L.ADDRESS3
, L.ADDRESS4
, L.CITY
, L.POSTAL_CODE
, L.STATE
, L.PROVINCE
, L.COUNTY
, L.ADDRESS_KEY
, L.ADDRESS_STYLE
, L.VALIDATED_FLAG
, L.ADDRESS_LINES_PHONETIC
, L.APARTMENT_FLAG
, L.PO_BOX_NUMBER
, L.HOUSE_NUMBER
, L.STREET_SUFFIX
, L.APARTMENT_NUMBER
, L.SECONDARY_SUFFIX_ELEMENT
, L.STREET
, L.RURAL_ROUTE_TYPE
, L.RURAL_ROUTE_NUMBER
, L.STREET_NUMBER
, L.BUILDING
, L.FLOOR
, L.SUITE
, L.ROOM
, L.POSTAL_PLUS4_CODE
, L.TIME_ZONE
, L.OVERSEAS_ADDRESS_FLAG
, L.POST_OFFICE
, L.POSITION
, L.DELIVERY_POINT_CODE
, L.LOCATION_DIRECTIONS
, PS.START_DATE_ACTIVE
, PS.END_DATE_ACTIVE
, L.ADDRESS_ERROR_CODE
, L.CLLI_CODE
, L.DODAAC
, L.TRAILING_DIRECTORY_CODE
, L.LANGUAGE
, L.LIFE_CYCLE_STATUS
, L.SHORT_DESCRIPTION
, L.DESCRIPTION
, L.CONTENT_SOURCE_TYPE
, L.LOC_HIERARCHY_ID
, L.SALES_TAX_GEOCODE
, L.SALES_TAX_INSIDE_CITY_LIMITS
, PS.PARTY_SITE_ID
, PS.PARTY_ID
, PS.LAST_UPDATE_DATE PS_LAST_UPDATE_DATE
FROM HZ_PARTY_SITES PS
, HZ_LOCATIONS L
WHERE PS.LOCATION_ID = L.LOCATION_ID
AND NVL(PS.END_DATE_ACTIVE
, SYSDATE+10) > SYSDATE