View: OKL_AM_PARTY_SHIP_TO_UV

Product:	OKL - Lease and Finance Management
Description:
Implementation/DBA Data:	APPS.OKL_AM_PARTY_SHIP_TO_UV

View Text

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'

Columns