[Home] [Help]
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
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
|
|
|
|