[Home] [Help]
View: PN_EMPLOYEE_SPACE_INFO_V
Product: | PN - Property Manager |
Description: | Employee and Space Asignment Information |
Implementation/DBA Data: |
Not implemented in this database
|
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
Name |
EMPLOYEE_ID |
EMPLOYEE_NUM |
FULL_NAME |
FIRST_NAME |
MIDDLE_NAME |
LAST_NAME |
COST_CENTER_CODE |
SPACE_ALLOCATED |
LOCATION_ID |