VIEW: APPS.ASF_HZ_PERSON_LOV_V

Source

View Text - Preformatted

SELECT party_id, party_name, address1, address2, address3, address4, city, province, state, postal_code, county, country, status, person_last_name, person_first_name, person_middle_name, person_pre_name_adjunct, null, null, null from hz_parties WHERE party_type='PERSON' and status in ('A','I')

View Text - HTML Formatted

SELECT PARTY_ID
, PARTY_NAME
, ADDRESS1
, ADDRESS2
, ADDRESS3
, ADDRESS4
, CITY
, PROVINCE
, STATE
, POSTAL_CODE
, COUNTY
, COUNTRY
, STATUS
, PERSON_LAST_NAME
, PERSON_FIRST_NAME
, PERSON_MIDDLE_NAME
, PERSON_PRE_NAME_ADJUNCT
, NULL
, NULL
, NULL
FROM HZ_PARTIES
WHERE PARTY_TYPE='PERSON'
AND STATUS IN ('A'
, 'I')