Product: | IGS - Student System |
---|---|
Description: | View for IGS_PE_NONIMG_FORM base table |
Implementation/DBA Data: | APPS.IGS_PE_NONIMG_FORM_V |
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(+)