VIEW: APPS.CSC_EMP_SEARCH_DS_V

Source

View Text - Preformatted

SELECT pho.phone_number, hr.first_name, hr.middle_name, hr.last_name, hr.full_name, hr.prefix, decode(hr.assignment_type,'C',hr.npw_number,hr.employee_number) employee_num, hr.email_address, hr.person_id employee_id, hr.party_id party_id, pho.phone_id, hr.termination_date from per_workforce_x hr, per_phones pho WHERE hr.person_id = pho.parent_id(+) and pho.phone_type(+) = 'W1' and pho.parent_table(+) = 'PER_ALL_PEOPE_F'

View Text - HTML Formatted

SELECT PHO.PHONE_NUMBER
, HR.FIRST_NAME
, HR.MIDDLE_NAME
, HR.LAST_NAME
, HR.FULL_NAME
, HR.PREFIX
, DECODE(HR.ASSIGNMENT_TYPE
, 'C'
, HR.NPW_NUMBER
, HR.EMPLOYEE_NUMBER) EMPLOYEE_NUM
, HR.EMAIL_ADDRESS
, HR.PERSON_ID EMPLOYEE_ID
, HR.PARTY_ID PARTY_ID
, PHO.PHONE_ID
, HR.TERMINATION_DATE
FROM PER_WORKFORCE_X HR
, PER_PHONES PHO
WHERE HR.PERSON_ID = PHO.PARENT_ID(+)
AND PHO.PHONE_TYPE(+) = 'W1'
AND PHO.PARENT_TABLE(+) = 'PER_ALL_PEOPE_F'