[Home] [Help]
View: CS_IB_EMPLOYEES_V
View Text
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 (+)
Columns
Name |
RESOURCE_NAME |
RESOURCE_NUMBER |
RESOURCE_ID |
RESOURCE_TYPE |
RESOURCE_ADDRESS |
ORIGINAL_RESOURCE_ID |
CONTACT_CATEGORY |
SORT_ORDER |