VIEW: APPS.IGSBV_EXCHANGE_VISITORS

Source

View Text - Preformatted

SELECT PEV.PRINT_FORM, PEV.FORM_EFFECTIVE_DATE, '_LA:PEV.FORM_STATUS:IGS_LOOKUP_VALUES:PE_SV_FM_STAT_TYPE:MEANING', PEV.CREATE_REASON, PEV.IS_VALID, PEV.PRGM_SPONSOR_AMT, PEV.GOVT_ORG1_AMT, PEV.GOVT_ORG1_CODE, PEV.GOVT_ORG2_AMT, PEV.GOVT_ORG2_CODE, PEV.INTL_ORG1_AMT, PEV.INTL_ORG1_CODE, PEV.INTL_ORG2_AMT, PEV.INTL_ORG2_CODE, PEV.EV_GOVT_AMT, PEV.BI_NATNL_COM_AMT, PEV.OTHER_GOVT_AMT, PEV.PERSONAL_FUNDS_AMT, PEV.EV_FORM_NUMBER, PEV.PRGM_START_DATE, PEV.PRGM_END_DATE, PEV.LAST_REPRINT_DATE, '_LA:PEV.REPRINT_REASON:IGS_LOOKUP_VALUES:PE_SV_REPRINT_REASON:MEANING', PEV.REPRINT_REMARKS, '_LA:PEV.POSITION_CODE:IGS_LOOKUP_VALUES:PE_SV_EV_POSITION:MEANING', PEV.POSITION_REMARKS, '_LA:PEV.SUBJECT_FIELD_CODE:IGS_LOOKUP_VALUES:PE_US_COURSE_SUBJECT:MEANING', PEV.SUBJECT_FIELD_REMARKS, '_LA:PEV.MATRICULATION:IGS_LOOKUP_VALUES:PE_SV_EV_MATR_CODE:MEANING', PEV.REMARKS, '_LA:PEV.CATEGORY_CODE:IGS_LOOKUP_VALUES:PE_SV_EV_PRG_CATEGORY:MEANING', PEV.INIT_PRGM_START_DATE, PEV.EV_FORM_ID, PEV.PERSON_ID, PEV.CREATION_DATE, PEV.CREATED_BY, PEV.LAST_UPDATED_BY, PEV.LAST_UPDATE_DATE FROM IGS_PE_EV_FORM PEV WITH READ ONLY

View Text - HTML Formatted

SELECT PEV.PRINT_FORM
, PEV.FORM_EFFECTIVE_DATE
, '_LA:PEV.FORM_STATUS:IGS_LOOKUP_VALUES:PE_SV_FM_STAT_TYPE:MEANING'
, PEV.CREATE_REASON
, PEV.IS_VALID
, PEV.PRGM_SPONSOR_AMT
, PEV.GOVT_ORG1_AMT
, PEV.GOVT_ORG1_CODE
, PEV.GOVT_ORG2_AMT
, PEV.GOVT_ORG2_CODE
, PEV.INTL_ORG1_AMT
, PEV.INTL_ORG1_CODE
, PEV.INTL_ORG2_AMT
, PEV.INTL_ORG2_CODE
, PEV.EV_GOVT_AMT
, PEV.BI_NATNL_COM_AMT
, PEV.OTHER_GOVT_AMT
, PEV.PERSONAL_FUNDS_AMT
, PEV.EV_FORM_NUMBER
, PEV.PRGM_START_DATE
, PEV.PRGM_END_DATE
, PEV.LAST_REPRINT_DATE
, '_LA:PEV.REPRINT_REASON:IGS_LOOKUP_VALUES:PE_SV_REPRINT_REASON:MEANING'
, PEV.REPRINT_REMARKS
, '_LA:PEV.POSITION_CODE:IGS_LOOKUP_VALUES:PE_SV_EV_POSITION:MEANING'
, PEV.POSITION_REMARKS
, '_LA:PEV.SUBJECT_FIELD_CODE:IGS_LOOKUP_VALUES:PE_US_COURSE_SUBJECT:MEANING'
, PEV.SUBJECT_FIELD_REMARKS
, '_LA:PEV.MATRICULATION:IGS_LOOKUP_VALUES:PE_SV_EV_MATR_CODE:MEANING'
, PEV.REMARKS
, '_LA:PEV.CATEGORY_CODE:IGS_LOOKUP_VALUES:PE_SV_EV_PRG_CATEGORY:MEANING'
, PEV.INIT_PRGM_START_DATE
, PEV.EV_FORM_ID
, PEV.PERSON_ID
, PEV.CREATION_DATE
, PEV.CREATED_BY
, PEV.LAST_UPDATED_BY
, PEV.LAST_UPDATE_DATE
FROM IGS_PE_EV_FORM PEV WITH READ ONLY