VIEW: APPS.CS_CONT_CONTACTS_RG_V

Source

View Text - Preformatted

SELECT hzp.person_pre_name_adjunct||' '||hzp.person_first_name ||''||decode(hzp.person_middle_name,null,null,hzp.person_middle_name||'')|| decode(hzp.person_last_name,null,null,hzp.person_last_name||' ') Party_name, hzp.person_first_name first_name, hzp.address1||decode(hzp.address1,null,null,',',',')|| hzp.address2||decode(hzp.address2,null,null,',',',')|| hzp.address3||decode(hzp.address3,null,null,',',',')|| hzp.address4||decode(hzp.address4,null,null,',',',')|| hzp.city||decode(hzp.city,null,null,',',',')|| hzp.state||decode(hzp.state,null,null,',',',')|| hzp.postal_code||decode(hzp.postal_code,null,null,',',',')|| hzp.province||decode(hzp.province,null,null,',',',')|| hzp.county||decode(hzp.country,null,null,',',',') Address, CS_Parties_PKG.get_party_phone(hzp.party_id, fnd_profile.value_wnps('CS_AR_WORK_PHONE_TYPE')) work_phone_number, CS_Parties_PKG.get_party_phone(hzp.party_id,fnd_profile.value_wnps('CS_AR_CELL _PHONE_TYPE')) cell_phone_number, CS_Parties_PKG.get_party_phone(hzp.party_id,fnd_profile.value_wnps('CS_AR_PAGE R_PHONE_TYPE')) pager_phone_number, CS_Parties_PKG.get_party_email(hzp.party_id) email_address, CS_Parties_PKG.get_party_fax(hzp.party_id) fax_number, CS_Parties_PKG.get_party_phone(hzp.party_id,fnd_profile.value_wnps('CS_AR_HOME _PHONE_TYPE')) home_phone_number, hzp.party_id, hzp.party_number from fnd_territories_vl ft, hz_parties hzp WHERE hzp.country = ft.territory_code(+) and hzp.party_type = 'PERSON'

View Text - HTML Formatted

SELECT HZP.PERSON_PRE_NAME_ADJUNCT||' '||HZP.PERSON_FIRST_NAME ||''||DECODE(HZP.PERSON_MIDDLE_NAME
, NULL
, NULL
, HZP.PERSON_MIDDLE_NAME||'')|| DECODE(HZP.PERSON_LAST_NAME
, NULL
, NULL
, HZP.PERSON_LAST_NAME||' ') PARTY_NAME
, HZP.PERSON_FIRST_NAME FIRST_NAME
, HZP.ADDRESS1||DECODE(HZP.ADDRESS1
, NULL
, NULL
, '
, '
, '
, ')|| HZP.ADDRESS2||DECODE(HZP.ADDRESS2
, NULL
, NULL
, '
, '
, '
, ')|| HZP.ADDRESS3||DECODE(HZP.ADDRESS3
, NULL
, NULL
, '
, '
, '
, ')|| HZP.ADDRESS4||DECODE(HZP.ADDRESS4
, NULL
, NULL
, '
, '
, '
, ')|| HZP.CITY||DECODE(HZP.CITY
, NULL
, NULL
, '
, '
, '
, ')|| HZP.STATE||DECODE(HZP.STATE
, NULL
, NULL
, '
, '
, '
, ')|| HZP.POSTAL_CODE||DECODE(HZP.POSTAL_CODE
, NULL
, NULL
, '
, '
, '
, ')|| HZP.PROVINCE||DECODE(HZP.PROVINCE
, NULL
, NULL
, '
, '
, '
, ')|| HZP.COUNTY||DECODE(HZP.COUNTRY
, NULL
, NULL
, '
, '
, '
, ') ADDRESS
, CS_PARTIES_PKG.GET_PARTY_PHONE(HZP.PARTY_ID
, FND_PROFILE.VALUE_WNPS('CS_AR_WORK_PHONE_TYPE')) WORK_PHONE_NUMBER
, CS_PARTIES_PKG.GET_PARTY_PHONE(HZP.PARTY_ID
, FND_PROFILE.VALUE_WNPS('CS_AR_CELL _PHONE_TYPE')) CELL_PHONE_NUMBER
, CS_PARTIES_PKG.GET_PARTY_PHONE(HZP.PARTY_ID
, FND_PROFILE.VALUE_WNPS('CS_AR_PAGE R_PHONE_TYPE')) PAGER_PHONE_NUMBER
, CS_PARTIES_PKG.GET_PARTY_EMAIL(HZP.PARTY_ID) EMAIL_ADDRESS
, CS_PARTIES_PKG.GET_PARTY_FAX(HZP.PARTY_ID) FAX_NUMBER
, CS_PARTIES_PKG.GET_PARTY_PHONE(HZP.PARTY_ID
, FND_PROFILE.VALUE_WNPS('CS_AR_HOME _PHONE_TYPE')) HOME_PHONE_NUMBER
, HZP.PARTY_ID
, HZP.PARTY_NUMBER
FROM FND_TERRITORIES_VL FT
, HZ_PARTIES HZP
WHERE HZP.COUNTRY = FT.TERRITORY_CODE(+)
AND HZP.PARTY_TYPE = 'PERSON'