[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 |
APPS.CS_IB_EMPLOYEES_V