VIEW: APPS.OKL_AM_PARTY_SHIP_TO_UV

Source

View Text - Preformatted

SELECT o.party_name party_name, u.primary_per_type primary_per_type, u.site_use_type site_use_type, nvl (a.address1, ' ') address1, nvl (a.address2, ' ') address2, nvl (a.address3, ' ') address3, nvl (a.city, ' ') city, nvl (a.state, ' ') state, nvl (a.postal_code, ' ') postal_code, nvl (a.country, ' ') country, s.party_id party_id, s.location_id location_id, NULL contact, s.party_site_id party_site_id, s.end_date_active end_date_active, s.status status, NULL contact_party_id FROM HZ_PARTY_SITES S,HZ_LOCATIONS A,HZ_PARTY_SITE_USES U,HZ_PARTIES O WHERE s.status = 'A' AND u.party_site_id = s.party_site_id AND NVL (s.end_date_active, SYSDATE) >= SYSDATE AND s.party_id = o.party_id AND s.location_id = a.location_id AND u.site_use_type = 'SHIP_TO'

View Text - HTML Formatted

SELECT O.PARTY_NAME PARTY_NAME
, U.PRIMARY_PER_TYPE PRIMARY_PER_TYPE
, U.SITE_USE_TYPE SITE_USE_TYPE
, NVL (A.ADDRESS1
, ' ') ADDRESS1
, NVL (A.ADDRESS2
, ' ') ADDRESS2
, NVL (A.ADDRESS3
, ' ') ADDRESS3
, NVL (A.CITY
, ' ') CITY
, NVL (A.STATE
, ' ') STATE
, NVL (A.POSTAL_CODE
, ' ') POSTAL_CODE
, NVL (A.COUNTRY
, ' ') COUNTRY
, S.PARTY_ID PARTY_ID
, S.LOCATION_ID LOCATION_ID
, NULL CONTACT
, S.PARTY_SITE_ID PARTY_SITE_ID
, S.END_DATE_ACTIVE END_DATE_ACTIVE
, S.STATUS STATUS
, NULL CONTACT_PARTY_ID
FROM HZ_PARTY_SITES S
, HZ_LOCATIONS A
, HZ_PARTY_SITE_USES U
, HZ_PARTIES O
WHERE S.STATUS = 'A'
AND U.PARTY_SITE_ID = S.PARTY_SITE_ID
AND NVL (S.END_DATE_ACTIVE
, SYSDATE) >= SYSDATE
AND S.PARTY_ID = O.PARTY_ID
AND S.LOCATION_ID = A.LOCATION_ID
AND U.SITE_USE_TYPE = 'SHIP_TO'