VIEW: APPS.CS_IB_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 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
FROM HR_EMPLOYEES E
, PER_ADDRESSES A
WHERE E.EMPLOYEE_ID = A.PERSON_ID (+)