VIEW: APPS.IGF_AP_FA_BASE_H_V

Source

View Text - Preformatted

SELECT fah.ROW_ID, fah.FABH_ID, fah.BASE_ID, fah.PERSON_ID, fah.PRIMARY_REC, fah.REC_LAST_UPDATED, fah.ENCUMBRANCE_TYPE, fien.DESCRIPTION, fah.VISA_TYPE, fah.CITIZENSHIP_STATUS, fah.RESIDENCY_STATUS, fah.MIL_SERVICE_TYPE, fah.ADMISSION_APPL_NUMBER, fah.ADM_APPL_STATUS, fah.S_ADM_APPL_STATUS, fah.APPL_DT, fah.CLASS_STANDING, fah.PERSON_TYPE, fah.CUR_ENROL_CREDIT_POINTS, fah.ADMISSION_CAT, fah.S_ADMISSION_PROCESS_TYPE, fah.PROG_ATT_COURSE_CD||' '||TO_CHAR(fah.PROG_ATT_VER_NUM) , fah.PROG_ATT_COURSE_CD, fah.PROG_ATT_VER_NUM, fah.PROG_ATT_ATTEND_MODE, fah.PROG_ATT_ATTEND_TYPE, fah.ADM_ORG_UNIT_CD, fah.ADM_OUTCOME_STATUS, fah.S_ADM_OUTCOME_STATUS, fah.DECISION_DATE, fah.ADM_OFFER_RESP_STATUS, fah.S_ADM_OFFER_RESP_STATUS, fah.ACTUAL_RESPONSE_DATE, fah.ADM_FEE_STATUS, fah.S_ADM_FEE_STATUS, fah.SP_PROGRAM_1, fah.SP_PROGRAM_2, fah.ENTRY_LEVEL, fah.ANTICIP_COMPL_DATE, fah.ATHLETIC_SPORT_ID, fah.ATHELETIC_SPORT, fah.ACADEMIC_INDEX, fah.FINAL_UNIT_SET_COURSE_CD||' '||TO_CHAR(fah.FINAL_UNIT_SET_VER_NUM), fah.FINAL_UNIT_SET_COURSE_CD, fah.FINAL_UNIT_SET_VER_NUM, fah.PROG_ATT_START_DT, fah.TRANSFERED, fah.ATB, ca.alternate_code, fah.ENRL_LOAD_CAL_TYPE, fah.ENRL_LOAD_SEQ_NUM, fah.SAP_EVALUATION_DATE, fah.SAP_SELECTED_FLAG, fah.ENRL_PRIMARY_PROG_COURSE_CD||' '||fah.ENRL_PRIMARY_PROG_VER_NUM, fah.ENRL_PRIMARY_PROG_COURSE_CD, fah.ENRL_PRIMARY_PROG_VER_NUM, fah.ENRL_PROGRAM_TYPE, fah.ENRL_USET_COURSE_CD||' '||fah.ENRL_USET_VER_NUM, fah.ENRL_USET_COURSE_CD, fah.ENRL_USET_VER_NUM, fah.ENRL_COURSE_ATTEMPT_STATUS, fah.DERIVED_ATTEND_TYPE, fah.CURRENT_GPA, fah.CUMULATIVE_GPA, fah.ACHEIVED_CR_PTS, fah.PRED_CLASS_STANDING, fah.ENRL_ORG_UNIT_CD, fah.ENRL_ATTEND_MODE, fah.ENRL_LOCATION_CD, fah.ENRL_TOTAL_CP, fah.ENRL_CUML_CP, fah.ENRL_CUML_TRANS_CP, fah.ORG_ID, fah.CREATED_BY, fah.CREATION_DATE, fah.LAST_UPDATED_BY, fah.LAST_UPDATE_DATE, fah.LAST_UPDATE_LOGIN, fah.REQUEST_ID, fah.PROGRAM_APPLICATION_ID, fah.PROGRAM_ID, fah.PROGRAM_UPDATE_DATE, fah.key_program FROM IGF_AP_FA_BASE_H fah , IGS_FI_ENCMB_TYPE fien, IGS_CA_INST ca WHERE fah.encumbrance_type = fien.encumbrance_type(+) and fah.enrl_load_cal_type = ca.cal_type(+) and fah.enrl_load_seq_num = ca.sequence_number(+)

View Text - HTML Formatted

SELECT FAH.ROW_ID
, FAH.FABH_ID
, FAH.BASE_ID
, FAH.PERSON_ID
, FAH.PRIMARY_REC
, FAH.REC_LAST_UPDATED
, FAH.ENCUMBRANCE_TYPE
, FIEN.DESCRIPTION
, FAH.VISA_TYPE
, FAH.CITIZENSHIP_STATUS
, FAH.RESIDENCY_STATUS
, FAH.MIL_SERVICE_TYPE
, FAH.ADMISSION_APPL_NUMBER
, FAH.ADM_APPL_STATUS
, FAH.S_ADM_APPL_STATUS
, FAH.APPL_DT
, FAH.CLASS_STANDING
, FAH.PERSON_TYPE
, FAH.CUR_ENROL_CREDIT_POINTS
, FAH.ADMISSION_CAT
, FAH.S_ADMISSION_PROCESS_TYPE
, FAH.PROG_ATT_COURSE_CD||' '||TO_CHAR(FAH.PROG_ATT_VER_NUM)
, FAH.PROG_ATT_COURSE_CD
, FAH.PROG_ATT_VER_NUM
, FAH.PROG_ATT_ATTEND_MODE
, FAH.PROG_ATT_ATTEND_TYPE
, FAH.ADM_ORG_UNIT_CD
, FAH.ADM_OUTCOME_STATUS
, FAH.S_ADM_OUTCOME_STATUS
, FAH.DECISION_DATE
, FAH.ADM_OFFER_RESP_STATUS
, FAH.S_ADM_OFFER_RESP_STATUS
, FAH.ACTUAL_RESPONSE_DATE
, FAH.ADM_FEE_STATUS
, FAH.S_ADM_FEE_STATUS
, FAH.SP_PROGRAM_1
, FAH.SP_PROGRAM_2
, FAH.ENTRY_LEVEL
, FAH.ANTICIP_COMPL_DATE
, FAH.ATHLETIC_SPORT_ID
, FAH.ATHELETIC_SPORT
, FAH.ACADEMIC_INDEX
, FAH.FINAL_UNIT_SET_COURSE_CD||' '||TO_CHAR(FAH.FINAL_UNIT_SET_VER_NUM)
, FAH.FINAL_UNIT_SET_COURSE_CD
, FAH.FINAL_UNIT_SET_VER_NUM
, FAH.PROG_ATT_START_DT
, FAH.TRANSFERED
, FAH.ATB
, CA.ALTERNATE_CODE
, FAH.ENRL_LOAD_CAL_TYPE
, FAH.ENRL_LOAD_SEQ_NUM
, FAH.SAP_EVALUATION_DATE
, FAH.SAP_SELECTED_FLAG
, FAH.ENRL_PRIMARY_PROG_COURSE_CD||' '||FAH.ENRL_PRIMARY_PROG_VER_NUM
, FAH.ENRL_PRIMARY_PROG_COURSE_CD
, FAH.ENRL_PRIMARY_PROG_VER_NUM
, FAH.ENRL_PROGRAM_TYPE
, FAH.ENRL_USET_COURSE_CD||' '||FAH.ENRL_USET_VER_NUM
, FAH.ENRL_USET_COURSE_CD
, FAH.ENRL_USET_VER_NUM
, FAH.ENRL_COURSE_ATTEMPT_STATUS
, FAH.DERIVED_ATTEND_TYPE
, FAH.CURRENT_GPA
, FAH.CUMULATIVE_GPA
, FAH.ACHEIVED_CR_PTS
, FAH.PRED_CLASS_STANDING
, FAH.ENRL_ORG_UNIT_CD
, FAH.ENRL_ATTEND_MODE
, FAH.ENRL_LOCATION_CD
, FAH.ENRL_TOTAL_CP
, FAH.ENRL_CUML_CP
, FAH.ENRL_CUML_TRANS_CP
, FAH.ORG_ID
, FAH.CREATED_BY
, FAH.CREATION_DATE
, FAH.LAST_UPDATED_BY
, FAH.LAST_UPDATE_DATE
, FAH.LAST_UPDATE_LOGIN
, FAH.REQUEST_ID
, FAH.PROGRAM_APPLICATION_ID
, FAH.PROGRAM_ID
, FAH.PROGRAM_UPDATE_DATE
, FAH.KEY_PROGRAM
FROM IGF_AP_FA_BASE_H FAH
, IGS_FI_ENCMB_TYPE FIEN
, IGS_CA_INST CA
WHERE FAH.ENCUMBRANCE_TYPE = FIEN.ENCUMBRANCE_TYPE(+)
AND FAH.ENRL_LOAD_CAL_TYPE = CA.CAL_TYPE(+)
AND FAH.ENRL_LOAD_SEQ_NUM = CA.SEQUENCE_NUMBER(+)