[Home] [Help]
View: CS_IB_W_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
, 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 (+)
Columns
Name |
RESOURCE_NAME |
RESOURCE_NUMBER |
RESOURCE_ID |
RESOURCE_TYPE |
RESOURCE_ADDRESS |
ORIGINAL_RESOURCE_ID |
CONTACT_CATEGORY |
SORT_ORDER |
WORK_PHONE |
PAGER_PHONE |
CELL_PHONE |
EMAIL |
FAX |
HOME_PHONE |