eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.IGF_GR_REP_SMRY_V

Source

View Text - Preformatted


SELECT LOC1.DOCUMENT_ID_TXT, TRIM(LOC1.REP_ENTITY_ID_TXT), 'Pell' FIN_AWARD_TYPE, FIN_AWARD_YEAR, COUNT(DISTINCT BASE_ID) TOT_CNT_NUM, SUM(AWARD_AMT) TOT_REP_AWD_AMT, SUM(DISB_AMT) TOT_REP_DISB_AMT FROM IGF_GR_COD_DTLS LOC1, (SELECT LOC2.AWARD_ID, SUM(DISB2.DISB_ACCEPTED_AMT) DISB_AMT FROM IGF_AW_DB_COD_DTLS DISB2, IGF_GR_COD_DTLS LOC2 WHERE LOC2.AWARD_ID = DISB2.AWARD_ID GROUP BY LOC2.AWARD_ID ) DISB1 WHERE LOC1.AWARD_ID = DISB1.AWARD_ID GROUP BY DOCUMENT_ID_TXT, REP_ENTITY_ID_TXT, FIN_AWARD_YEAR

View Text - HTML Formatted

SELECT LOC1.DOCUMENT_ID_TXT
, TRIM(LOC1.REP_ENTITY_ID_TXT)
, 'PELL' FIN_AWARD_TYPE
, FIN_AWARD_YEAR
, COUNT(DISTINCT BASE_ID) TOT_CNT_NUM
, SUM(AWARD_AMT) TOT_REP_AWD_AMT
, SUM(DISB_AMT) TOT_REP_DISB_AMT
FROM IGF_GR_COD_DTLS LOC1
, (SELECT LOC2.AWARD_ID
, SUM(DISB2.DISB_ACCEPTED_AMT) DISB_AMT
FROM IGF_AW_DB_COD_DTLS DISB2
, IGF_GR_COD_DTLS LOC2
WHERE LOC2.AWARD_ID = DISB2.AWARD_ID GROUP BY LOC2.AWARD_ID ) DISB1
WHERE LOC1.AWARD_ID = DISB1.AWARD_ID GROUP BY DOCUMENT_ID_TXT
, REP_ENTITY_ID_TXT
, FIN_AWARD_YEAR