View: PN_SPACE_ASSIGN_EMP_V

Product:	PN - Property Manager
Description:
Implementation/DBA Data:	APPS.PN_SPACE_ASSIGN_EMP_V

View Text

SELECT PSAE.ROWID ROW_ID
, PSAE.EMP_SPACE_ASSIGN_ID EMP_SPACE_ASSIGN_ID
, PSAE.LOCATION_ID LOCATION_ID
, PL.LOCATION_ID LOCATION_LOCATION_ID
, PL.LOCATION_TYPE_LOOKUP_CODE LOCATION_TYPE_LOOKUP_CODE
, PL.SUITE LOCATION_SUITE_NAME
, PL.LOCATION_CODE LOCATION_CODE
, PL.ACTIVE_START_DATE ACTIVE_START_DATE
, PL.ACTIVE_END_DATE ACTIVE_END_DATE
, PSAE.PERSON_ID PERSON_ID
, PPF.LAST_NAME LAST_NAME
, PPF.FIRST_NAME FIRST_NAME
, PPF.FULL_NAME FULL_NAME
, PPF.EMPLOYEE_NUMBER EMPLOYEE_NUMBER
, PSAE.PROJECT_ID PROJECT_ID
, PSAE.TASK_ID TASK_ID
, PSAE.EMP_ASSIGN_START_DATE EMP_ASSIGN_START_DATE
, PSAE.EMP_ASSIGN_END_DATE EMP_ASSIGN_END_DATE
, PSAE.COST_CENTER_CODE COST_CENTER_CODE
, PSAE.ALLOCATED_AREA_PCT ALLOCATED_AREA_PCT
, PSAE.ALLOCATED_AREA ALLOCATED_AREA
, PL.UOM_CODE UOM_CODE
, PSAE.UTILIZED_AREA UTILIZED_AREA
, PSAE.EMP_SPACE_COMMENTS EMP_SPACE_COMMENTS
, PSAE.LAST_UPDATE_DATE LAST_UPDATE_DATE
, PSAE.LAST_UPDATED_BY LAST_UPDATED_BY
, PSAE.CREATION_DATE CREATION_DATE
, PSAE.CREATED_BY CREATED_BY
, PSAE.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, PSAE.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, PSAE.ATTRIBUTE1 ATTRIBUTE1
, PSAE.ATTRIBUTE2 ATTRIBUTE2
, PSAE.ATTRIBUTE3 ATTRIBUTE3
, PSAE.ATTRIBUTE4 ATTRIBUTE4
, PSAE.ATTRIBUTE5 ATTRIBUTE5
, PSAE.ATTRIBUTE6 ATTRIBUTE6
, PSAE.ATTRIBUTE7 ATTRIBUTE7
, PSAE.ATTRIBUTE8 ATTRIBUTE8
, PSAE.ATTRIBUTE9 ATTRIBUTE9
, PSAE.ATTRIBUTE10 ATTRIBUTE10
, PSAE.ATTRIBUTE11 ATTRIBUTE11
, PSAE.ATTRIBUTE12 ATTRIBUTE12
, PSAE.ATTRIBUTE13 ATTRIBUTE13
, PSAE.ATTRIBUTE14 ATTRIBUTE14
, PSAE.ATTRIBUTE15 ATTRIBUTE15
, PL.ORG_ID ORG_ID
FROM PER_ALL_PEOPLE_F PPF
, PN_LOCATIONS PL
, PN_SPACE_ASSIGN_EMP PSAE
WHERE SYSDATE BETWEEN PPF.EFFECTIVE_START_DATE(+)
AND PPF.EFFECTIVE_END_DATE(+)
AND PPF.PERSON_ID(+) = PSAE.PERSON_ID
AND NVL(PL.COMMON_AREA_FLAG
, 'N') = 'N'
AND PL.LOCATION_ID = PSAE.LOCATION_ID(+) UNION ALL SELECT PSAE.ROWID ROW_ID
, PSAE.EMP_SPACE_ASSIGN_ID EMP_SPACE_ASSIGN_ID
, PSAE.LOCATION_ID LOCATION_ID
, PL.LOCATION_ID LOCATION_LOCATION_ID
, PL.LOCATION_TYPE_LOOKUP_CODE LOCATION_TYPE_LOOKUP_CODE
, PL.SUITE LOCATION_SUITE_NAME
, PL.LOCATION_CODE LOCATION_CODE
, PL.ACTIVE_START_DATE ACTIVE_START_DATE
, PL.ACTIVE_END_DATE ACTIVE_END_DATE
, PSAE.PERSON_ID PERSON_ID
, NULL LAST_NAME
, NULL FIRST_NAME
, NULL FULL_NAME
, NULL EMPLOYEE_NUMBER
, PSAE.PROJECT_ID PROJECT_ID
, PSAE.TASK_ID TASK_ID
, PSAE.EMP_ASSIGN_START_DATE EMP_ASSIGN_START_DATE
, PSAE.EMP_ASSIGN_END_DATE EMP_ASSIGN_END_DATE
, PSAE.COST_CENTER_CODE COST_CENTER_CODE
, PSAE.ALLOCATED_AREA_PCT ALLOCATED_AREA_PCT
, PSAE.ALLOCATED_AREA ALLOCATED_AREA
, PL.UOM_CODE UOM_CODE
, PSAE.UTILIZED_AREA UTILIZED_AREA
, PSAE.EMP_SPACE_COMMENTS EMP_SPACE_COMMENTS
, PSAE.LAST_UPDATE_DATE LAST_UPDATE_DATE
, PSAE.LAST_UPDATED_BY LAST_UPDATED_BY
, PSAE.CREATION_DATE CREATION_DATE
, PSAE.CREATED_BY CREATED_BY
, PSAE.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, PSAE.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, PSAE.ATTRIBUTE1 ATTRIBUTE1
, PSAE.ATTRIBUTE2 ATTRIBUTE2
, PSAE.ATTRIBUTE3 ATTRIBUTE3
, PSAE.ATTRIBUTE4 ATTRIBUTE4
, PSAE.ATTRIBUTE5 ATTRIBUTE5
, PSAE.ATTRIBUTE6 ATTRIBUTE6
, PSAE.ATTRIBUTE7 ATTRIBUTE7
, PSAE.ATTRIBUTE8 ATTRIBUTE8
, PSAE.ATTRIBUTE9 ATTRIBUTE9
, PSAE.ATTRIBUTE10 ATTRIBUTE10
, PSAE.ATTRIBUTE11 ATTRIBUTE11
, PSAE.ATTRIBUTE12 ATTRIBUTE12
, PSAE.ATTRIBUTE13 ATTRIBUTE13
, PSAE.ATTRIBUTE14 ATTRIBUTE14
, PSAE.ATTRIBUTE15 ATTRIBUTE15
, PL.ORG_ID ORG_ID
FROM PN_LOCATIONS PL
, PN_SPACE_ASSIGN_EMP PSAE
WHERE PSAE.LOCATION_ID (+) = PL.LOCATION_ID * (-1)
AND EXISTS (SELECT NULL
FROM PN_SPACE_ASSIGN_EMP EMP1
WHERE EMP1.LOCATION_ID = PL.LOCATION_ID)

Columns