VIEW: APPS.IGSBV_APPL_PANEL_DETAILS

Source

View Text - Preformatted

SELECT ipd.PANEL_DTLS_ID, ipd.PERSON_ID, ipd.ADMISSION_APPL_NUMBER, ipd.NOMINATED_COURSE_CD, ipd.SEQUENCE_NUMBER, ipd.PANEL_CODE, ipd.FINAL_DECISION_CODE, '_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, ipd.ROOM_ID, 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 WITH READ ONLY

View Text - HTML Formatted

SELECT IPD.PANEL_DTLS_ID
, IPD.PERSON_ID
, IPD.ADMISSION_APPL_NUMBER
, IPD.NOMINATED_COURSE_CD
, IPD.SEQUENCE_NUMBER
, IPD.PANEL_CODE
, IPD.FINAL_DECISION_CODE
, '_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
, IPD.ROOM_ID
, 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 WITH READ ONLY