Product: | ASF - Sales Online |
---|---|
Description: | |
Implementation/DBA Data: | APPS.ASF_PERSON_LOV_V |
SELECT DISTINCT A.PARTY_ID
, B.OBJECT_ID
, PARTY_NAME
, ADDRESS1
, ADDRESS2
, ADDRESS3
, ADDRESS4
, CITY
, PROVINCE
, STATE
, POSTAL_CODE
, COUNTY
, COUNTRY
, A.STATUS
, PERSON_LAST_NAME
, PERSON_FIRST_NAME
, PERSON_MIDDLE_NAME
, PERSON_PRE_NAME_ADJUNCT
, RELATIONSHIP_CODE
, C.MEANING
, RELATIONSHIP_ID
, B.PARTY_ID
FROM HZ_PARTIES A
, HZ_RELATIONSHIPS B
, AR_LOOKUPS C
WHERE A.PARTY_ID = B.SUBJECT_ID
AND A.PARTY_TYPE='PERSON'
AND B.RELATIONSHIP_CODE=C.LOOKUP_CODE
AND B.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
AND B.OBJECT_TABLE_NAME = 'HZ_PARTIES'
AND A.STATUS IN ('A'
, 'I')
AND B.STATUS = 'A'
AND SYSDATE BETWEEN B.START_DATE
AND NVL(B.END_DATE
, SYSDATE)