VIEW: APPS.IGS_AD_ADMDE_INT

Source

View Text - Preformatted

SELECT tab.rowid row_id, tab.interface_mkdes_id interface_mkdes_id, tab.interface_run_id interface_run_id, tab.batch_id batch_id, tab.person_id person_id, tab.admission_appl_number admission_appl_number, tab.nominated_course_cd nominated_course_cd, tab.sequence_number sequence_number, tab.adm_outcome_status adm_outcome_status, tab.decision_make_id decision_make_id, tab.decision_date decision_date, tab.decision_reason_id decision_reason_id, tab.pending_reason_id pending_reason_id, tab.offer_dt offer_dt, tab.offer_response_dt offer_response_dt, tab.status status, tab.error_code error_code, tab.creation_date creation_date, tab.created_by created_by, tab.last_update_date last_update_date, tab.last_updated_by last_updated_by, tab.last_update_login last_update_login, tab.request_id request_id, tab.program_application_id program_application_id, tab.program_id program_id, tab.program_update_date program_update_date, tab.org_id org_id, tab.reconsider_flag reconsider_flag, tab. prpsd_commencement_date, tab.error_text FROM igs_ad_admde_int_all tab

View Text - HTML Formatted

SELECT TAB.ROWID ROW_ID
, TAB.INTERFACE_MKDES_ID INTERFACE_MKDES_ID
, TAB.INTERFACE_RUN_ID INTERFACE_RUN_ID
, TAB.BATCH_ID BATCH_ID
, TAB.PERSON_ID PERSON_ID
, TAB.ADMISSION_APPL_NUMBER ADMISSION_APPL_NUMBER
, TAB.NOMINATED_COURSE_CD NOMINATED_COURSE_CD
, TAB.SEQUENCE_NUMBER SEQUENCE_NUMBER
, TAB.ADM_OUTCOME_STATUS ADM_OUTCOME_STATUS
, TAB.DECISION_MAKE_ID DECISION_MAKE_ID
, TAB.DECISION_DATE DECISION_DATE
, TAB.DECISION_REASON_ID DECISION_REASON_ID
, TAB.PENDING_REASON_ID PENDING_REASON_ID
, TAB.OFFER_DT OFFER_DT
, TAB.OFFER_RESPONSE_DT OFFER_RESPONSE_DT
, TAB.STATUS STATUS
, TAB.ERROR_CODE ERROR_CODE
, TAB.CREATION_DATE CREATION_DATE
, TAB.CREATED_BY CREATED_BY
, TAB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, TAB.LAST_UPDATED_BY LAST_UPDATED_BY
, TAB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, TAB.REQUEST_ID REQUEST_ID
, TAB.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, TAB.PROGRAM_ID PROGRAM_ID
, TAB.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, TAB.ORG_ID ORG_ID
, TAB.RECONSIDER_FLAG RECONSIDER_FLAG
, TAB. PRPSD_COMMENCEMENT_DATE
, TAB.ERROR_TEXT
FROM IGS_AD_ADMDE_INT_ALL TAB