Product: | PN - Property Manager |
---|---|
Description: | |
Implementation/DBA Data: | APPS.PN_SPACE_ALLOCATIONS_V |
SELECT SP.ROWID ROW_ID
, SP.SPACE_ALLOCATION_ID SPACE_ALLOCATION_ID
, SP.LAST_UPDATE_DATE LAST_UPDATE_DATE
, SP.LAST_UPDATED_BY LAST_UPDATED_BY
, SP.CREATION_DATE CREATION_DATE
, SP.CREATED_BY CREATED_BY
, SP.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, SP.LOCATION_ID LOCATION_ID
, SP.EMPLOYEE_ID EMPLOYEE_ID
, SP.COST_CENTER_CODE COST_CENTER_CODE
, SP.ALLOCATED_AREA ALLOCATED_AREA
, SP.ALLOCATED_AREA_PCT ALLOCATED_AREA_PCT
, SP.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, SP.ATTRIBUTE1 ATTRIBUTE1
, SP.ATTRIBUTE2 ATTRIBUTE2
, SP.ATTRIBUTE3 ATTRIBUTE3
, SP.ATTRIBUTE4 ATTRIBUTE4
, SP.ATTRIBUTE5 ATTRIBUTE5
, SP.ATTRIBUTE6 ATTRIBUTE6
, SP.ATTRIBUTE7 ATTRIBUTE7
, SP.ATTRIBUTE8 ATTRIBUTE8
, SP.ATTRIBUTE9 ATTRIBUTE9
, SP.ATTRIBUTE10 ATTRIBUTE10
, SP.ATTRIBUTE11 ATTRIBUTE11
, SP.ATTRIBUTE12 ATTRIBUTE12
, SP.ATTRIBUTE13 ATTRIBUTE13
, SP.ATTRIBUTE14 ATTRIBUTE14
, SP.ATTRIBUTE15 ATTRIBUTE15
, PP.FULL_NAME EMPLOYEE_NAME
, PP.EMPLOYEE_NUMBER EMPLOYEE_NUMBER
FROM PER_ALL_PEOPLE_F PP
, PN_SPACE_ALLOCATIONS SP
WHERE PP.PERSON_ID = SP.EMPLOYEE_ID
AND TRUNC(SYSDATE) BETWEEN PP.EFFECTIVE_START_DATE
AND PP.EFFECTIVE_END_DATE UNION SELECT SP.ROWID ROW_ID
, SP.SPACE_ALLOCATION_ID SPACE_ALLOCATION_ID
, SP.LAST_UPDATE_DATE LAST_UPDATE_DATE
, SP.LAST_UPDATED_BY LAST_UPDATED_BY
, SP.CREATION_DATE CREATION_DATE
, SP.CREATED_BY CREATED_BY
, SP.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, SP.LOCATION_ID LOCATION_ID
, SP.EMPLOYEE_ID EMPLOYEE_ID
, SP.COST_CENTER_CODE COST_CENTER_CODE
, SP.ALLOCATED_AREA ALLOCATED_AREA
, SP.ALLOCATED_AREA_PCT ALLOCATED_AREA_PCT
, SP.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, SP.ATTRIBUTE1 ATTRIBUTE1
, SP.ATTRIBUTE2 ATTRIBUTE2
, SP.ATTRIBUTE3 ATTRIBUTE3
, SP.ATTRIBUTE4 ATTRIBUTE4
, SP.ATTRIBUTE5 ATTRIBUTE5
, SP.ATTRIBUTE6 ATTRIBUTE6
, SP.ATTRIBUTE7 ATTRIBUTE7
, SP.ATTRIBUTE8 ATTRIBUTE8
, SP.ATTRIBUTE9 ATTRIBUTE9
, SP.ATTRIBUTE10 ATTRIBUTE10
, SP.ATTRIBUTE11 ATTRIBUTE11
, SP.ATTRIBUTE12 ATTRIBUTE12
, SP.ATTRIBUTE13 ATTRIBUTE13
, SP.ATTRIBUTE14 ATTRIBUTE14
, SP.ATTRIBUTE15 ATTRIBUTE15
, TO_CHAR(NULL) EMPLOYEE_NAME
, TO_CHAR(NULL) EMPLOYEE_NUMBER
FROM PN_SPACE_ALLOCATIONS SP
WHERE SP.EMPLOYEE_ID IS NULL