[Home] [Help]
| Product: | IGS - Student System (Obsolete) |
|---|---|
| Description: | |
| Implementation/DBA Data: | Not implemented in this database |
SELECT IPD.PANEL_DTLS_ID
, IPD.PERSON_ID
, P.PARTY_NUMBER
, PP.PERSON_NAME
, IPD.ADMISSION_APPL_NUMBER
, IPD.NOMINATED_COURSE_CD
, PSV.TITLE
, IPD.SEQUENCE_NUMBER
, IPD.PANEL_CODE
, IPN.PANEL_DESC
, IPD.FINAL_DECISION_CODE
, CC.DESCRIPTION
, '_LA:IPD.FINAL_DECISION_TYPE:IGS_LOOKUP_VALUES:INTERVIEW_PANEL_TYPE:MEANING'
, '_LA:IPD.CLOSED_FLAG:IGS_LOOKUP_VALUES:YES_NO:MEANING'
, IPD.INTERVIEW_DATE
, IPD.INTERVIEW_TIME
, IPD.LOCATION_CD
, LOC.DESCRIPTION
, IPD.ROOM_ID
, RM.ROOM_CD
, RM.DESCRIPTION
, IPD.FINAL_DECISION_DATE
, '_DF:IGS:IGS_AD_PANEL_DTLS_FLEX:IPD'
, IPD.CREATED_BY
, IPD.CREATION_DATE
, IPD.LAST_UPDATED_BY
, IPD.LAST_UPDATE_DATE
FROM IGS_AD_PANEL_DTLS IPD
, HZ_PARTIES P
, HZ_PERSON_PROFILES PP
, IGS_AD_CODE_CLASSES CC
, IGS_AD_LOCATION LOC
, IGS_AD_ROOM RM
, IGS_AD_INTVW_PNLS IPN
, IGS_PS_VER_ALL PSV
, IGS_AD_PS_APPL_INST_ALL INST
WHERE IPD.PANEL_CODE = IPN.PANEL_CODE
AND IPD.PERSON_ID = P.PARTY_ID
AND P.PARTY_ID = PP.PARTY_ID
AND PP.CONTENT_SOURCE_TYPE = 'USER_ENTERED'
AND SYSDATE BETWEEN PP.EFFECTIVE_START_DATE
AND NVL(PP.EFFECTIVE_END_DATE
, SYSDATE)
AND IPD.FINAL_DECISION_CODE = CC.NAME
AND IPD.FINAL_DECISION_TYPE = CC.CLASS
AND IPD.LOCATION_CD = LOC.LOCATION_CD(+)
AND IPD.ROOM_ID = RM.ROOM_ID(+)
AND IPD.NOMINATED_COURSE_CD = PSV.COURSE_CD
AND IPD.NOMINATED_COURSE_CD = INST.NOMINATED_COURSE_CD
AND IPD.PERSON_ID = INST.PERSON_ID
AND IPD.ADMISSION_APPL_NUMBER = INST.ADMISSION_APPL_NUMBER
AND IPD.SEQUENCE_NUMBER = INST.SEQUENCE_NUMBER
AND INST.CRV_VERSION_NUMBER = PSV.VERSION_NUMBER WITH READ ONLY