VIEW: APPS.IGS_PE_EV_FORM_V

Source

View Text - Preformatted

SELECT pv.rowid row_id, pv.ev_form_id, pv.person_id, pv.print_form, pv.form_effective_date, pv.form_status, l1.meaning form_status_desc, pv.create_reason, pv.is_valid, pv.prgm_sponsor_amt, pv.govt_org1_amt, pv.govt_org1_code, l2.meaning govt_org1_desc, pv.govt_org2_amt, pv.govt_org2_code, l3.meaning govt_org2_desc, pv.intl_org1_amt, pv.intl_org1_code, l4.meaning intl_org1_desc, pv.intl_org2_amt, pv.intl_org2_code, l5.meaning intl_org2_desc, pv.ev_govt_amt, pv.bi_natnl_com_amt, pv.other_govt_amt, pv.personal_funds_amt, pv.ev_form_number, pv.prgm_start_date, pv.prgm_end_date, pv.last_reprint_date, pv.reprint_reason, l6.meaning reprint_reason_desc, pv.reprint_remarks, pv.position_code, l7.meaning position_desc, pv.position_remarks, pv.subject_field_code, l8.meaning subject_field_desc, pv.subject_field_remarks, pv.matriculation, l9.meaning matriculation_desc, pv.remarks, pv.creation_date, pv.created_by, pv.last_updated_by, pv.last_update_date, pv.last_update_login, pv.init_prgm_start_date, pv.category_code, l10.meaning category_code_desc, pv.NO_SHOW_FLAG, pv.GOVT_ORG1_OTHR_NAME, pv.GOVT_ORG2_OTHR_NAME, pv.INTL_ORG1_OTHR_NAME, pv.INTL_ORG2_OTHR_NAME, pv.OTHER_GOVT_NAME , PV.SEVIS_SCHOOL_IDENTIFIER, hp.party_name sevis_school FROM IGS_PE_EV_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, IGS_LOOKUP_VALUES L7, IGS_LOOKUP_VALUES L8, IGS_LOOKUP_VALUES L9, IGS_LOOKUP_VALUES L10, HZ_PARTIES HP WHERE PV.FORM_STATUS = L1.LOOKUP_CODE AND L1.LOOKUP_TYPE = 'PE_SV_FM_STAT_TYPE' AND PV.GOVT_ORG1_CODE = L2.LOOKUP_CODE(+) AND L2.LOOKUP_TYPE (+) = 'PE_US_GVT_AGENCY' AND PV.GOVT_ORG2_CODE = L3.LOOKUP_CODE(+) AND L3.LOOKUP_TYPE(+) = 'PE_US_GVT_AGENCY' AND PV.INTL_ORG1_CODE = L4.LOOKUP_CODE(+) AND L4.LOOKUP_TYPE (+) = 'PE_SV_INTL_ORG' AND PV.INTL_ORG2_CODE = L5.LOOKUP_CODE(+) AND L5.LOOKUP_TYPE(+) = 'PE_SV_INTL_ORG' AND PV.REPRINT_REASON = L6.LOOKUP_CODE(+) AND L6.LOOKUP_TYPE (+) = 'PE_SV_REPRINT_REASON' AND PV.POSITION_CODE = L7.LOOKUP_CODE AND L7.LOOKUP_TYPE = 'PE_SV_EV_POSITION' AND PV.SUBJECT_FIELD_CODE = L8.LOOKUP_CODE AND L8.LOOKUP_TYPE = 'PE_US_COURSE_SUBJECT' AND PV.MATRICULATION = L9.LOOKUP_CODE(+) AND L9.LOOKUP_TYPE (+) = 'PE_SV_EV_MATR_CODE' AND PV.CATEGORY_CODE = L10.LOOKUP_CODE (+) AND L10.LOOKUP_TYPE (+) = 'PE_SV_EV_PRG_CATEGORY' AND hp.party_type(+) = 'ORGANIZATION' AND PV.SEVIS_SCHOOL_IDENTIFIER = HP.PARTY_ID(+)

View Text - HTML Formatted

SELECT PV.ROWID ROW_ID
, PV.EV_FORM_ID
, PV.PERSON_ID
, PV.PRINT_FORM
, PV.FORM_EFFECTIVE_DATE
, PV.FORM_STATUS
, L1.MEANING FORM_STATUS_DESC
, PV.CREATE_REASON
, PV.IS_VALID
, PV.PRGM_SPONSOR_AMT
, PV.GOVT_ORG1_AMT
, PV.GOVT_ORG1_CODE
, L2.MEANING GOVT_ORG1_DESC
, PV.GOVT_ORG2_AMT
, PV.GOVT_ORG2_CODE
, L3.MEANING GOVT_ORG2_DESC
, PV.INTL_ORG1_AMT
, PV.INTL_ORG1_CODE
, L4.MEANING INTL_ORG1_DESC
, PV.INTL_ORG2_AMT
, PV.INTL_ORG2_CODE
, L5.MEANING INTL_ORG2_DESC
, PV.EV_GOVT_AMT
, PV.BI_NATNL_COM_AMT
, PV.OTHER_GOVT_AMT
, PV.PERSONAL_FUNDS_AMT
, PV.EV_FORM_NUMBER
, PV.PRGM_START_DATE
, PV.PRGM_END_DATE
, PV.LAST_REPRINT_DATE
, PV.REPRINT_REASON
, L6.MEANING REPRINT_REASON_DESC
, PV.REPRINT_REMARKS
, PV.POSITION_CODE
, L7.MEANING POSITION_DESC
, PV.POSITION_REMARKS
, PV.SUBJECT_FIELD_CODE
, L8.MEANING SUBJECT_FIELD_DESC
, PV.SUBJECT_FIELD_REMARKS
, PV.MATRICULATION
, L9.MEANING MATRICULATION_DESC
, PV.REMARKS
, PV.CREATION_DATE
, PV.CREATED_BY
, PV.LAST_UPDATED_BY
, PV.LAST_UPDATE_DATE
, PV.LAST_UPDATE_LOGIN
, PV.INIT_PRGM_START_DATE
, PV.CATEGORY_CODE
, L10.MEANING CATEGORY_CODE_DESC
, PV.NO_SHOW_FLAG
, PV.GOVT_ORG1_OTHR_NAME
, PV.GOVT_ORG2_OTHR_NAME
, PV.INTL_ORG1_OTHR_NAME
, PV.INTL_ORG2_OTHR_NAME
, PV.OTHER_GOVT_NAME
, PV.SEVIS_SCHOOL_IDENTIFIER
, HP.PARTY_NAME SEVIS_SCHOOL
FROM IGS_PE_EV_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
, IGS_LOOKUP_VALUES L7
, IGS_LOOKUP_VALUES L8
, IGS_LOOKUP_VALUES L9
, IGS_LOOKUP_VALUES L10
, HZ_PARTIES HP
WHERE PV.FORM_STATUS = L1.LOOKUP_CODE
AND L1.LOOKUP_TYPE = 'PE_SV_FM_STAT_TYPE'
AND PV.GOVT_ORG1_CODE = L2.LOOKUP_CODE(+)
AND L2.LOOKUP_TYPE (+) = 'PE_US_GVT_AGENCY'
AND PV.GOVT_ORG2_CODE = L3.LOOKUP_CODE(+)
AND L3.LOOKUP_TYPE(+) = 'PE_US_GVT_AGENCY'
AND PV.INTL_ORG1_CODE = L4.LOOKUP_CODE(+)
AND L4.LOOKUP_TYPE (+) = 'PE_SV_INTL_ORG'
AND PV.INTL_ORG2_CODE = L5.LOOKUP_CODE(+)
AND L5.LOOKUP_TYPE(+) = 'PE_SV_INTL_ORG'
AND PV.REPRINT_REASON = L6.LOOKUP_CODE(+)
AND L6.LOOKUP_TYPE (+) = 'PE_SV_REPRINT_REASON'
AND PV.POSITION_CODE = L7.LOOKUP_CODE
AND L7.LOOKUP_TYPE = 'PE_SV_EV_POSITION'
AND PV.SUBJECT_FIELD_CODE = L8.LOOKUP_CODE
AND L8.LOOKUP_TYPE = 'PE_US_COURSE_SUBJECT'
AND PV.MATRICULATION = L9.LOOKUP_CODE(+)
AND L9.LOOKUP_TYPE (+) = 'PE_SV_EV_MATR_CODE'
AND PV.CATEGORY_CODE = L10.LOOKUP_CODE (+)
AND L10.LOOKUP_TYPE (+) = 'PE_SV_EV_PRG_CATEGORY'
AND HP.PARTY_TYPE(+) = 'ORGANIZATION'
AND PV.SEVIS_SCHOOL_IDENTIFIER = HP.PARTY_ID(+)