VIEW: APPS.CSF_M_SR_CONTACTS_V

Source

View Text - Preformatted

SELECT acc.ACCESS_ID, cont.SR_CONTACT_POINT_ID, cont.PARTY_ID, cont.INCIDENT_ID, cont.CONTACT_TYPE, cont.CONTACT_POINT_ID, cont.CONTACT_POINT_TYPE, cont.primary_flag ,cp.phone_country_code || ' ' || cp.phone_area_code || ' ' || cp.phone_number || decode(cp.phone_extension, null, null, ' (' || cp.phone_extension || ')') as CONTACT_PHONE , cp.EMAIL_ADDRESS ,CSM_UTIL_PKG.GET_NUMBER(cont.CREATED_BY) as CREATED_BY ,CSM_UTIL_PKG.GET_NUMBER(cont.LAST_UPDATED_BY) as LAST_UPDATED_BY FROM HZ_CONTACT_POINTS cp, CS_HZ_SR_CONTACT_POINTS cont, csm_sr_contacts_acc acc WHERE acc.user_id = asg_base.get_user_id AND acc.sr_contact_point_id = cont.sr_contact_point_id AND cont.contact_point_id = cp.contact_point_id (+)

View Text - HTML Formatted

SELECT ACC.ACCESS_ID
, CONT.SR_CONTACT_POINT_ID
, CONT.PARTY_ID
, CONT.INCIDENT_ID
, CONT.CONTACT_TYPE
, CONT.CONTACT_POINT_ID
, CONT.CONTACT_POINT_TYPE
, CONT.PRIMARY_FLAG
, CP.PHONE_COUNTRY_CODE || ' ' || CP.PHONE_AREA_CODE || ' ' || CP.PHONE_NUMBER || DECODE(CP.PHONE_EXTENSION
, NULL
, NULL
, ' (' || CP.PHONE_EXTENSION || ')') AS CONTACT_PHONE
, CP.EMAIL_ADDRESS
, CSM_UTIL_PKG.GET_NUMBER(CONT.CREATED_BY) AS CREATED_BY
, CSM_UTIL_PKG.GET_NUMBER(CONT.LAST_UPDATED_BY) AS LAST_UPDATED_BY
FROM HZ_CONTACT_POINTS CP
, CS_HZ_SR_CONTACT_POINTS CONT
, CSM_SR_CONTACTS_ACC ACC
WHERE ACC.USER_ID = ASG_BASE.GET_USER_ID
AND ACC.SR_CONTACT_POINT_ID = CONT.SR_CONTACT_POINT_ID
AND CONT.CONTACT_POINT_ID = CP.CONTACT_POINT_ID (+)