Product: | IGS - Student System (Obsolete) |
---|---|
Description: | Duplicate Documents stores all the duplicate requests for a document. |
Implementation/DBA Data: | Not implemented in this database |
SELECT AD.ROWID
, AD.ORDER_NUMBER
, AD.ITEM_NUMBER
, AD.REQUESTED_BY
, HZ1.FULL_NAME
, AD.REQUESTED_DATE
, AD.FULFILLED_BY
, HZ2.FULL_NAME
, AD.FULFILLED_DATE
, AD.CREATED_BY
, AD.CREATION_DATE
, AD.LAST_UPDATED_BY
, AD.LAST_UPDATE_DATE
, AD.LAST_UPDATE_LOGIN
FROM IGS_AS_DUP_DOCS AD
, IGS_PE_PERSON_BASE_V HZ1
, IGS_PE_PERSON_BASE_V HZ2
WHERE AD.REQUESTED_BY = HZ1.PERSON_ID
AND AD.FULFILLED_BY = HZ2. PERSON_ID (+)