View: PER_REQUISITIONS_V

Product:	PER - Human Resources
Description:	Used to support user interface
Implementation/DBA Data:	APPS.PER_REQUISITIONS_V

View Text

SELECT REQ.ROWID ROW_ID
, REQ.REQUISITION_ID
, REQ.BUSINESS_GROUP_ID
, REQ.PERSON_ID
, PP1.FULL_NAME RAISED_BY
, PP1.EMPLOYEE_NUMBER RAISED_BY_NUMBER
, REQ.DATE_FROM
, REQ.NAME
, REQ.COMMENTS
, REQ.DATE_TO
, REQ.DESCRIPTION
, REQ.REQUEST_ID
, REQ.PROGRAM_APPLICATION_ID
, REQ.PROGRAM_ID
, REQ.PROGRAM_UPDATE_DATE
, REQ.ATTRIBUTE_CATEGORY
, REQ.ATTRIBUTE1
, REQ.ATTRIBUTE2
, REQ.ATTRIBUTE3
, REQ.ATTRIBUTE4
, REQ.ATTRIBUTE5
, REQ.ATTRIBUTE6
, REQ.ATTRIBUTE7
, REQ.ATTRIBUTE8
, REQ.ATTRIBUTE9
, REQ.ATTRIBUTE10
, REQ.ATTRIBUTE11
, REQ.ATTRIBUTE12
, REQ.ATTRIBUTE13
, REQ.ATTRIBUTE14
, REQ.ATTRIBUTE15
, REQ.ATTRIBUTE16
, REQ.ATTRIBUTE17
, REQ.ATTRIBUTE18
, REQ.ATTRIBUTE19
, REQ.ATTRIBUTE20
, REQ.LAST_UPDATE_DATE
, REQ.LAST_UPDATED_BY
, REQ.LAST_UPDATE_LOGIN
, REQ.CREATED_BY
, REQ.CREATION_DATE
FROM PER_REQUISITIONS REQ
, PER_ALL_PEOPLE_F PP1
WHERE REQ.PERSON_ID = PP1.PERSON_ID(+)
AND ( PP1.PERSON_ID IS NULL OR REQ.DATE_FROM BETWEEN PP1.EFFECTIVE_START_DATE
AND PP1.EFFECTIVE_END_DATE )

Columns