VIEW: APPS.IGF_SL_REP_SMRY_V

Source

View Text - Preformatted

SELECT DOCUMENT_ID_TXT, REP_ENTITY_ID_TXT, FIN_AWARD_YEAR, LOAN_TYPE, DECODE (LOAN_TYPE, 'DLS' , 'DLSubsidized','DLP' , 'DLPLUS','DLU' , 'DLUnsubsidized') FIN_AWARD_TYPE, COUNT(DISTINCT BASE_ID) TOT_CNT_NUM, SUM(LOAN_AMT_ACCEPTED) TOT_REP_AWD_AMT, SUM(NVL(DISB_AMT,0)) TOT_REP_DISB_AMT FROM IGF_SL_LOR_LOC_ALL LOC1, (SELECT LOC2.AWARD_ID, SUM(DISB2.DISB_ACCEPTED_AMT) DISB_AMT FROM IGF_AW_DB_COD_DTLS DISB2, IGF_SL_LOR_LOC_ALL LOC2 WHERE LOC2.AWARD_ID = DISB2.AWARD_ID GROUP BY LOC2.AWARD_ID )DISB1 WHERE LOC1.AWARD_ID = DISB1.AWARD_ID (+) AND LOC1.LOAN_TYPE IN ('DLP','DLS','DLU') GROUP BY DOCUMENT_ID_TXT,REP_ENTITY_ID_TXT,FIN_AWARD_YEAR,LOAN_TYPE

View Text - HTML Formatted

SELECT DOCUMENT_ID_TXT
, REP_ENTITY_ID_TXT
, FIN_AWARD_YEAR
, LOAN_TYPE
, DECODE (LOAN_TYPE
, 'DLS'
, 'DLSUBSIDIZED'
, 'DLP'
, 'DLPLUS'
, 'DLU'
, 'DLUNSUBSIDIZED') FIN_AWARD_TYPE
, COUNT(DISTINCT BASE_ID) TOT_CNT_NUM
, SUM(LOAN_AMT_ACCEPTED) TOT_REP_AWD_AMT
, SUM(NVL(DISB_AMT
, 0)) TOT_REP_DISB_AMT
FROM IGF_SL_LOR_LOC_ALL LOC1
, (SELECT LOC2.AWARD_ID
, SUM(DISB2.DISB_ACCEPTED_AMT) DISB_AMT
FROM IGF_AW_DB_COD_DTLS DISB2
, IGF_SL_LOR_LOC_ALL LOC2
WHERE LOC2.AWARD_ID = DISB2.AWARD_ID GROUP BY LOC2.AWARD_ID )DISB1
WHERE LOC1.AWARD_ID = DISB1.AWARD_ID (+)
AND LOC1.LOAN_TYPE IN ('DLP'
, 'DLS'
, 'DLU') GROUP BY DOCUMENT_ID_TXT
, REP_ENTITY_ID_TXT
, FIN_AWARD_YEAR
, LOAN_TYPE