Product: | IGS - Student System (Obsolete) |
---|---|
Description: | Shows the location details for a person |
Implementation/DBA Data: | Not implemented in this database |
SELECT OL.ROW_ID ROW_ID
, OL.LOCATION_CD
, OL.DESCRIPTION
, OL.LOCATION_TYPE
, OL.COORD_PERSON_ID
, PE.PERSON_NUMBER COORD_PERSON_NUMBER
, LT.S_LOCATION_TYPE
, OL.MAIL_DLVRY_WRK_DAYS
, OL.ATTRIBUTE_CATEGORY
, OL.ATTRIBUTE1
, OL.ATTRIBUTE2
, OL.ATTRIBUTE3
, OL.ATTRIBUTE4
, OL.ATTRIBUTE5
, OL.ATTRIBUTE6
, OL.ATTRIBUTE7
, OL.ATTRIBUTE8
, OL.ATTRIBUTE9
, OL.ATTRIBUTE10
, OL.ATTRIBUTE11
, OL.ATTRIBUTE12
, OL.ATTRIBUTE13
, OL.ATTRIBUTE14
, OL.ATTRIBUTE15
, OL.ATTRIBUTE16
, OL.ATTRIBUTE17
, OL.ATTRIBUTE18
, OL.ATTRIBUTE19
, OL.ATTRIBUTE20
, OL.CREATION_DATE
, OL.CREATED_BY
, OL.LAST_UPDATE_DATE
, OL.LAST_UPDATED_BY
, OL.LAST_UPDATE_LOGIN
, OL.CLOSED_IND
, OL.REV_ACCOUNT_CD
FROM IGS_AD_LOCATION OL
, IGS_AD_LOCATION_TYPE_ALL LT
, IGS_PE_PERSON_BASE_V PE
WHERE OL.LOCATION_TYPE = LT.LOCATION_TYPE
AND OL.COORD_PERSON_ID = PE.PERSON_ID(+)