[Home] [Help]
View: 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
Name |
PARTY_NAME |
PRIMARY_PER_TYPE |
SITE_USE_TYPE |
ADDRESS1 |
ADDRESS2 |
ADDRESS3 |
CITY |
STATE |
POSTAL_CODE |
COUNTRY |
PARTY_ID |
LOCATION_ID |
CONTACT |
PARTY_SITE_ID |
END_DATE_ACTIVE |
STATUS |
CONTACT_PARTY_ID |