[Home] [Help]
View: IGF_SL_REP_SMRY_V
Product: | IGF - Financial Aid |
Description: | View used for reproting the financial summary tag in the outbound XML for Direct Loan |
Implementation/DBA Data: |
APPS.IGF_SL_REP_SMRY_V
|
View Text
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
Columns
Name |
DOCUMENT_ID_TXT |
REP_ENTITY_ID_TXT |
FIN_AWARD_YEAR |
LOAN_TYPE |
FIN_AWARD_TYPE |
TOT_CNT_NUM |
TOT_REP_AWD_AMT |
TOT_REP_DISB_AMT |