VIEW: APPS.IGS_SV_EV_CRT_FIN_V

Source

View Text - Preformatted

SELECT fncl.person_id, fncl.batch_id, fncl.recvd_us_gvt_funds recvd_us_gov_funds, fncl.program_sponsor prgm_sponsor_funds, fncl.govt_org1_code us_govt_org1_code, fncl.govt_org1 us_govt_org1_funds, fncl.govt_org2_code us_govt_org2_code, fncl.govt_org2 us_govt_org2_funds, fncl.intl_org1_code intl_govt_org1_code, fncl.intl_org1 intl_govt_org1_funds, fncl.intl_org2_code intl_govt_org2_code, fncl.intl_org2 intl_govt_org2_funds, fncl.ev_govt ev_govt_funds, fncl.bi_natnl_com bi_national_comm_funds, fncl.other_org other_org_funds, fncl.personal_funds personal_funds, fncl.remarks fund_remarks, fncl.GOVT_ORG1_OTHR_NAME, fncl.GOVT_ORG2_OTHR_NAME, fncl.INTL_ORG1_OTHR_NAME, fncl.INTL_ORG2_OTHR_NAME, fncl.OTHER_GOVT_NAME FROM igs_sv_finance_info fncl

View Text - HTML Formatted

SELECT FNCL.PERSON_ID
, FNCL.BATCH_ID
, FNCL.RECVD_US_GVT_FUNDS RECVD_US_GOV_FUNDS
, FNCL.PROGRAM_SPONSOR PRGM_SPONSOR_FUNDS
, FNCL.GOVT_ORG1_CODE US_GOVT_ORG1_CODE
, FNCL.GOVT_ORG1 US_GOVT_ORG1_FUNDS
, FNCL.GOVT_ORG2_CODE US_GOVT_ORG2_CODE
, FNCL.GOVT_ORG2 US_GOVT_ORG2_FUNDS
, FNCL.INTL_ORG1_CODE INTL_GOVT_ORG1_CODE
, FNCL.INTL_ORG1 INTL_GOVT_ORG1_FUNDS
, FNCL.INTL_ORG2_CODE INTL_GOVT_ORG2_CODE
, FNCL.INTL_ORG2 INTL_GOVT_ORG2_FUNDS
, FNCL.EV_GOVT EV_GOVT_FUNDS
, FNCL.BI_NATNL_COM BI_NATIONAL_COMM_FUNDS
, FNCL.OTHER_ORG OTHER_ORG_FUNDS
, FNCL.PERSONAL_FUNDS PERSONAL_FUNDS
, FNCL.REMARKS FUND_REMARKS
, FNCL.GOVT_ORG1_OTHR_NAME
, FNCL.GOVT_ORG2_OTHR_NAME
, FNCL.INTL_ORG1_OTHR_NAME
, FNCL.INTL_ORG2_OTHR_NAME
, FNCL.OTHER_GOVT_NAME
FROM IGS_SV_FINANCE_INFO FNCL