Product: | OKL - Lease and Finance Management |
---|---|
Description: | |
Implementation/DBA Data: | APPS.OKL_AM_PARTY_LOCATION_UV |
SELECT O.PARTY_NAME PARTY_NAME
, U.PRIMARY_PER_TYPE PRIMARY_PER_TYPE
, U.SITE_USE_TYPE SITE_USE_TYPE
, S.PARTY_ID PARTY_ID
, S.LOCATION_ID LOCATION_ID
, S.PARTY_SITE_ID PARTY_SITE_ID
, U.PARTY_SITE_USE_ID PARTY_SITE_USE_ID
, S.END_DATE_ACTIVE END_DATE_ACTIVE
, S.STATUS STATUS
, A.ADDRESS1 ADDRESS1
, A.ADDRESS2 ADDRESS2
, A.ADDRESS3 ADDRESS3
, A.CITY CITY
, A.STATE STATE
, A.POSTAL_CODE POSTAL_CODE
, A.COUNTRY COUNTRY
, SUBSTR (ARP_ADDR_LABEL_PKG.FORMAT_ADDRESS ( NULL
, A.ADDRESS1
, A.ADDRESS2
, A.ADDRESS3
, A.ADDRESS4
, A.CITY
, A.COUNTY
, A.STATE
, A.PROVINCE
, A.POSTAL_CODE
, NULL
, A.COUNTRY
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, 'N'
, 'N'
, 80
, 1
, 1)
, 1
, 80) LOCATION_ADDRESS
, TO_CHAR(NULL) CONTACT
, TO_NUMBER(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