VIEW: APPS.ASF_PERSON_LOV_V

Source

View Text - Preformatted

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, rt.role, c.meaning, relationship_id, b.party_id from hz_parties a,hz_relationships b, hz_relationship_types rt, ar_lookups c WHERE a.party_id = b.subject_id and a.party_type='PERSON' and rt.role = c.lookup_code and b.relationship_code = rt.forward_rel_code and b.relationship_type = rt.relationship_type and b.subject_type = rt.subject_type and b.object_type = rt.object_type 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) and c.lookup_type = 'HZ_RELATIONSHIP_ROLE' and c.enabled_flag = 'Y'

View Text - HTML Formatted

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
, RT.ROLE
, C.MEANING
, RELATIONSHIP_ID
, B.PARTY_ID
FROM HZ_PARTIES A
, HZ_RELATIONSHIPS B
, HZ_RELATIONSHIP_TYPES RT
, AR_LOOKUPS C
WHERE A.PARTY_ID = B.SUBJECT_ID
AND A.PARTY_TYPE='PERSON'
AND RT.ROLE = C.LOOKUP_CODE
AND B.RELATIONSHIP_CODE = RT.FORWARD_REL_CODE
AND B.RELATIONSHIP_TYPE = RT.RELATIONSHIP_TYPE
AND B.SUBJECT_TYPE = RT.SUBJECT_TYPE
AND B.OBJECT_TYPE = RT.OBJECT_TYPE
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)
AND C.LOOKUP_TYPE = 'HZ_RELATIONSHIP_ROLE'
AND C.ENABLED_FLAG = 'Y'