VIEW: APPS.CS_IB_W_EMPLOYEES_V

Source

View Text - Preformatted

SELECT e.full_name resource_name, e.employee_num resource_number, e.employee_id resource_id, 'EMPLOYEE' resource_type, a.address_line1||' '||a.address_line2||' '||a.address_line3||' '|| a.town_or_city||' '|| a.region_2||' '||a.postal_code||' '|| a.country resource_Address, e.employee_id original_resource_id, 'EMPLOYEE' contact_category, 'BBBB' Sort_Order , CS_Parties_PKG.get_party_phone(e.employee_id,fnd_profile.value('CS_AR_WORK_PHONE_TYPE')) work_phone, CS_Parties_PKG.get_party_phone(e.employee_id,fnd_profile.value('CS_AR_PAGER_PHONE_TYPE')) pager_phone, CS_Parties_PKG.get_party_phone(e.employee_id,fnd_profile.value('CS_AR_CELL_PHONE_TYPE')) cell_phone, CS_Parties_PKG.get_party_email(e.employee_id) email, CS_Parties_PKG.get_party_fax(e.employee_id) fax, CS_Parties_PKG.get_party_phone(e.employee_id,fnd_profile.value('CS_AR_HOME_PHONE_TYPE')) home_phone FROM hr_employees e, PER_ADDRESSES a WHERE e.employee_id = a.person_id (+)

View Text - HTML Formatted

SELECT E.FULL_NAME RESOURCE_NAME
, E.EMPLOYEE_NUM RESOURCE_NUMBER
, E.EMPLOYEE_ID RESOURCE_ID
, 'EMPLOYEE' RESOURCE_TYPE
, A.ADDRESS_LINE1||' '||A.ADDRESS_LINE2||' '||A.ADDRESS_LINE3||' '|| A.TOWN_OR_CITY||' '|| A.REGION_2||' '||A.POSTAL_CODE||' '|| A.COUNTRY RESOURCE_ADDRESS
, E.EMPLOYEE_ID ORIGINAL_RESOURCE_ID
, 'EMPLOYEE' CONTACT_CATEGORY
, 'BBBB' SORT_ORDER
, CS_PARTIES_PKG.GET_PARTY_PHONE(E.EMPLOYEE_ID
, FND_PROFILE.VALUE('CS_AR_WORK_PHONE_TYPE')) WORK_PHONE
, CS_PARTIES_PKG.GET_PARTY_PHONE(E.EMPLOYEE_ID
, FND_PROFILE.VALUE('CS_AR_PAGER_PHONE_TYPE')) PAGER_PHONE
, CS_PARTIES_PKG.GET_PARTY_PHONE(E.EMPLOYEE_ID
, FND_PROFILE.VALUE('CS_AR_CELL_PHONE_TYPE')) CELL_PHONE
, CS_PARTIES_PKG.GET_PARTY_EMAIL(E.EMPLOYEE_ID) EMAIL
, CS_PARTIES_PKG.GET_PARTY_FAX(E.EMPLOYEE_ID) FAX
, CS_PARTIES_PKG.GET_PARTY_PHONE(E.EMPLOYEE_ID
, FND_PROFILE.VALUE('CS_AR_HOME_PHONE_TYPE')) HOME_PHONE
FROM HR_EMPLOYEES E
, PER_ADDRESSES A
WHERE E.EMPLOYEE_ID = A.PERSON_ID (+)