View: CS_IB_W_EMPLOYEES_V

Product:	CS - Service
Description:
Implementation/DBA Data:	APPS.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