VIEW: APPS.IGS_PE_NONIMG_FORM_V

Source

View Text - Preformatted

SELECT pv.rowid row_id, pv.nonimg_form_id, pv.person_id, pv.print_form, pv.form_effective_date, pv.form_status, l1.meaning form_status_desc, pv.acad_term_length, pv.tuition_amt, pv.living_exp_amt, pv.personal_funds_amt, pv.issue_reason, pv.commuter_ind, pv.english_reqd, pv.length_of_study, pv.prgm_start_date, pv.prgm_end_date, pv.primary_major, l2.meaning primary_major_desc, pv.education_level, l3.meaning education_level_desc, pv.educ_lvl_remarks, pv.depdnt_exp_amt, pv.other_exp_amt, pv.other_exp_desc, pv.school_funds_amt, pv.school_funds_desc, pv.other_funds_amt, pv.other_funds_desc, pv.empl_funds_amt, pv.remarks, pv.curr_session_end_date, pv.next_session_start_date, pv.transfer_from_school, pv.other_reason, pv.last_reprint_date, pv.reprint_reason, l4.meaning reprint_reason_desc, pv.reprint_remarks, pv.secondary_major, l5.meaning secondary_major_desc, pv.minor, l6.meaning minor_desc, pv.english_reqd_met, pv.not_reqd_reason, pv.visa_type, pv.creation_date, pv.created_by, pv.last_updated_by, pv.last_update_date, pv.last_update_login, PV.LAST_SESSION_FLAG, PV.ADJUDICATED_FLAG , PV.SEVIS_SCHOOL_IDENTIFIER, hp.party_name sevis_school FROM IGS_PE_NONIMG_FORM PV, IGS_LOOKUP_VALUES L1, IGS_LOOKUP_VALUES L2, IGS_LOOKUP_VALUES L3, IGS_LOOKUP_VALUES L4, IGS_LOOKUP_VALUES L5, IGS_LOOKUP_VALUES L6, HZ_PARTIES HP WHERE PV.FORM_STATUS = L1.LOOKUP_CODE AND L1.LOOKUP_TYPE = 'PE_SV_FM_STAT_TYPE' AND PV.PRIMARY_MAJOR = L2.LOOKUP_CODE AND L2.LOOKUP_TYPE = 'PE_US_COURSE_SUBJECT' AND PV.EDUCATION_LEVEL = L3.LOOKUP_CODE AND L3.LOOKUP_TYPE = 'PE_SV_EDUC_LEVEL' AND PV.REPRINT_REASON = L4.LOOKUP_CODE(+) AND L4.LOOKUP_TYPE (+) = 'PE_SV_REPRINT_REASON' AND PV.SECONDARY_MAJOR = L5.LOOKUP_CODE(+) AND L5.LOOKUP_TYPE (+) = 'PE_US_COURSE_SUBJECT' AND PV.MINOR = L6.LOOKUP_CODE(+) AND L6.LOOKUP_TYPE(+) = 'PE_US_COURSE_SUBJECT' AND hp.party_type (+)= 'ORGANIZATION' AND PV.SEVIS_SCHOOL_IDENTIFIER = HP.PARTY_ID(+)

View Text - HTML Formatted

SELECT PV.ROWID ROW_ID
, PV.NONIMG_FORM_ID
, PV.PERSON_ID
, PV.PRINT_FORM
, PV.FORM_EFFECTIVE_DATE
, PV.FORM_STATUS
, L1.MEANING FORM_STATUS_DESC
, PV.ACAD_TERM_LENGTH
, PV.TUITION_AMT
, PV.LIVING_EXP_AMT
, PV.PERSONAL_FUNDS_AMT
, PV.ISSUE_REASON
, PV.COMMUTER_IND
, PV.ENGLISH_REQD
, PV.LENGTH_OF_STUDY
, PV.PRGM_START_DATE
, PV.PRGM_END_DATE
, PV.PRIMARY_MAJOR
, L2.MEANING PRIMARY_MAJOR_DESC
, PV.EDUCATION_LEVEL
, L3.MEANING EDUCATION_LEVEL_DESC
, PV.EDUC_LVL_REMARKS
, PV.DEPDNT_EXP_AMT
, PV.OTHER_EXP_AMT
, PV.OTHER_EXP_DESC
, PV.SCHOOL_FUNDS_AMT
, PV.SCHOOL_FUNDS_DESC
, PV.OTHER_FUNDS_AMT
, PV.OTHER_FUNDS_DESC
, PV.EMPL_FUNDS_AMT
, PV.REMARKS
, PV.CURR_SESSION_END_DATE
, PV.NEXT_SESSION_START_DATE
, PV.TRANSFER_FROM_SCHOOL
, PV.OTHER_REASON
, PV.LAST_REPRINT_DATE
, PV.REPRINT_REASON
, L4.MEANING REPRINT_REASON_DESC
, PV.REPRINT_REMARKS
, PV.SECONDARY_MAJOR
, L5.MEANING SECONDARY_MAJOR_DESC
, PV.MINOR
, L6.MEANING MINOR_DESC
, PV.ENGLISH_REQD_MET
, PV.NOT_REQD_REASON
, PV.VISA_TYPE
, PV.CREATION_DATE
, PV.CREATED_BY
, PV.LAST_UPDATED_BY
, PV.LAST_UPDATE_DATE
, PV.LAST_UPDATE_LOGIN
, PV.LAST_SESSION_FLAG
, PV.ADJUDICATED_FLAG
, PV.SEVIS_SCHOOL_IDENTIFIER
, HP.PARTY_NAME SEVIS_SCHOOL
FROM IGS_PE_NONIMG_FORM PV
, IGS_LOOKUP_VALUES L1
, IGS_LOOKUP_VALUES L2
, IGS_LOOKUP_VALUES L3
, IGS_LOOKUP_VALUES L4
, IGS_LOOKUP_VALUES L5
, IGS_LOOKUP_VALUES L6
, HZ_PARTIES HP
WHERE PV.FORM_STATUS = L1.LOOKUP_CODE
AND L1.LOOKUP_TYPE = 'PE_SV_FM_STAT_TYPE'
AND PV.PRIMARY_MAJOR = L2.LOOKUP_CODE
AND L2.LOOKUP_TYPE = 'PE_US_COURSE_SUBJECT'
AND PV.EDUCATION_LEVEL = L3.LOOKUP_CODE
AND L3.LOOKUP_TYPE = 'PE_SV_EDUC_LEVEL'
AND PV.REPRINT_REASON = L4.LOOKUP_CODE(+)
AND L4.LOOKUP_TYPE (+) = 'PE_SV_REPRINT_REASON'
AND PV.SECONDARY_MAJOR = L5.LOOKUP_CODE(+)
AND L5.LOOKUP_TYPE (+) = 'PE_US_COURSE_SUBJECT'
AND PV.MINOR = L6.LOOKUP_CODE(+)
AND L6.LOOKUP_TYPE(+) = 'PE_US_COURSE_SUBJECT'
AND HP.PARTY_TYPE (+)= 'ORGANIZATION'
AND PV.SEVIS_SCHOOL_IDENTIFIER = HP.PARTY_ID(+)