[Home] [Help]
View: CS_CONT_CONTACTS_RG_V
View Text
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'
Columns
Name |
PARTY_NAME |
FIRST_NAME |
ADDRESS |
WORK_PHONE_NUMBER |
CELL_PHONE_NUMBER |
PAGER_PHONE_NUMBER |
EMAIL_ADDRESS |
FAX_NUMBER |
HOME_PHONE_NUMBER |
PARTY_ID |
PARTY_NUMBER |