Product: | OKL - Lease and Finance Management |
---|---|
Description: | |
Implementation/DBA Data: | APPS.OKL_AM_PARTIES_UV |
SELECT DISTINCT HZPO.ADDRESS1 CUSTOMER_ADDRESS1
, HZPO.ADDRESS2 CUSTOMER_ADDRESS2
, HZPO.ADDRESS3 CUSTOMER_ADDRESS3
, HZPO.ADDRESS4 CUSTOMER_ADDRESS4
, HZPO.CITY CUSTOMER_CITY
, HZPO.POSTAL_CODE CUSTOMER_POSTAL_CODE
, HZPO.STATE CUSTOMER_STATE
, HZPO.COUNTRY CUSTOMER_COUNTRY
, HZPO.PARTY_ID CUSTOMER_PARTY_ID
, HZPO.PARTY_TYPE CUSTOMER_PARTY_TYPE
, HZPO.PARTY_NAME CUSTOMER_PARTY_NAME
FROM HZ_RELATIONSHIPS HZPR
, HZ_PARTIES HZPO
WHERE HZPR.OBJECT_ID = HZPO.PARTY_ID
AND HZPR.STATUS = 'A'
AND HZPR.DIRECTIONAL_FLAG = 'F'
AND HZPR.START_DATE <= SYSDATE
AND NVL(HZPR.END_DATE
, SYSDATE) >= SYSDATE