VIEW: APPS.AMS_PERSONS_V

Source

View Text - Preformatted

SELECT prsn.party_id ,prsn.party_id ,prsn.party_name ,prsn.person_last_name ,prsn.person_first_name ,prsn.person_middle_name ,prsn.known_as ,prsn.status ,cpph.phone_country_code || decode(cpph.phone_area_code, null, '', ' '||cpph.phone_area_code) || decode(cpph.phone_number, null, '', ' '||cpph.phone_number) || decode(cpph.phone_extension, null, '', ' ext. '||cpph.phone_extension) ,cpph.phone_country_code ,cpph.phone_area_code ,cpph.phone_number ,cpph.phone_extension ,cpph.phone_line_type ,prsn.email_address ,prsn.address1 || decode(prsn.address2, null, '', ' '||prsn.address2) || decode(prsn.address3, null, '', ' '||prsn.address3) || decode(prsn.address4, null, '', ' '||prsn.address4) || ', '||prsn.city ||', '||prsn.state||', '||prsn.postal_code||', '||prsn.country ,prsn.address1 || decode(prsn.address2, null, '', ' '||prsn.address2) || decode(prsn.address3, null, '', ' '||prsn.address3) || decode(prsn.address4, null, '', ' '||prsn.address4) ,prsn.address1 ,prsn.address2 ,prsn.address3 ,prsn.address4 ,prsn.state ,prsn.city ,prsn.province ,prsn.county ,prsn.postal_code ,prsn.country ,prsn.last_ordered_date ,prsn.creation_date ,prsn.last_update_date ,prsn.created_by ,prsn.last_updated_by from hz_parties prsn ,hz_contact_points cpph WHERE prsn.party_type = 'PERSON' and prsn.status = 'A' and prsn.party_id = cpph.owner_table_id (+) and cpph.owner_table_name (+) = 'HZ_PARTIES' and cpph.contact_point_type (+) = 'PHONE' and cpph.primary_flag (+) = 'Y'

View Text - HTML Formatted

SELECT PRSN.PARTY_ID
, PRSN.PARTY_ID
, PRSN.PARTY_NAME
, PRSN.PERSON_LAST_NAME
, PRSN.PERSON_FIRST_NAME
, PRSN.PERSON_MIDDLE_NAME
, PRSN.KNOWN_AS
, PRSN.STATUS
, CPPH.PHONE_COUNTRY_CODE || DECODE(CPPH.PHONE_AREA_CODE
, NULL
, ''
, ' '||CPPH.PHONE_AREA_CODE) || DECODE(CPPH.PHONE_NUMBER
, NULL
, ''
, ' '||CPPH.PHONE_NUMBER) || DECODE(CPPH.PHONE_EXTENSION
, NULL
, ''
, ' EXT. '||CPPH.PHONE_EXTENSION)
, CPPH.PHONE_COUNTRY_CODE
, CPPH.PHONE_AREA_CODE
, CPPH.PHONE_NUMBER
, CPPH.PHONE_EXTENSION
, CPPH.PHONE_LINE_TYPE
, PRSN.EMAIL_ADDRESS
, PRSN.ADDRESS1 || DECODE(PRSN.ADDRESS2
, NULL
, ''
, ' '||PRSN.ADDRESS2) || DECODE(PRSN.ADDRESS3
, NULL
, ''
, ' '||PRSN.ADDRESS3) || DECODE(PRSN.ADDRESS4
, NULL
, ''
, ' '||PRSN.ADDRESS4) || '
, '||PRSN.CITY ||'
, '||PRSN.STATE||'
, '||PRSN.POSTAL_CODE||'
, '||PRSN.COUNTRY
, PRSN.ADDRESS1 || DECODE(PRSN.ADDRESS2
, NULL
, ''
, ' '||PRSN.ADDRESS2) || DECODE(PRSN.ADDRESS3
, NULL
, ''
, ' '||PRSN.ADDRESS3) || DECODE(PRSN.ADDRESS4
, NULL
, ''
, ' '||PRSN.ADDRESS4)
, PRSN.ADDRESS1
, PRSN.ADDRESS2
, PRSN.ADDRESS3
, PRSN.ADDRESS4
, PRSN.STATE
, PRSN.CITY
, PRSN.PROVINCE
, PRSN.COUNTY
, PRSN.POSTAL_CODE
, PRSN.COUNTRY
, PRSN.LAST_ORDERED_DATE
, PRSN.CREATION_DATE
, PRSN.LAST_UPDATE_DATE
, PRSN.CREATED_BY
, PRSN.LAST_UPDATED_BY
FROM HZ_PARTIES PRSN
, HZ_CONTACT_POINTS CPPH
WHERE PRSN.PARTY_TYPE = 'PERSON'
AND PRSN.STATUS = 'A'
AND PRSN.PARTY_ID = CPPH.OWNER_TABLE_ID (+)
AND CPPH.OWNER_TABLE_NAME (+) = 'HZ_PARTIES'
AND CPPH.CONTACT_POINT_TYPE (+) = 'PHONE'
AND CPPH.PRIMARY_FLAG (+) = 'Y'