View: PN_EMPLOYEE_SPACE_INFO_V

View Text

SELECT EMP.EMPLOYEE_ID EMPLOYEE_ID
, EMP.EMPLOYEE_NUM EMPLOYEE_NUM
, EMP.FULL_NAME FULL_NAME
, EMP.FIRST_NAME FIRST_NAME
, EMP.MIDDLE_NAME MIDDLE_NAME
, EMP.LAST_NAME LAST_NAME
, DECODE(SPC.COST_CENTER_CODE
, NULL
, PNP_UTIL_FUNC.GET_CC_CODE(EMP.EMPLOYEE_ID)
, SPC.COST_CENTER_CODE) COST_CENTER_CODE
, DECODE(SPC.LOCATION_ID
, NULL
, 'N'
, 'Y') SPACE_ALLOCATED
, SPC.LOCATION_ID LOCATION_ID
FROM PER_EMPLOYEES_CURRENT_X EMP
, PN_SPACE_ALLOCATIONS SPC
WHERE EMP.EMPLOYEE_ID = SPC.EMPLOYEE_ID (+)

Columns