VIEW: APPS.IGF_SE_EARNINGS_SUMMARY_V

Source

View Text - Preformatted

SELECT base_id, fund_id, ld_cal_type, ld_sequence_number, ld_alternate_code, award_amount, earnings_till_date, (award_amount - earnings_till_date) remaining_amount, (ROUND(earnings_till_date/award_amount) * 100) progress_to_limit, NULL notification_sent, NULL notification_date, NULL auth_id, NULL auth_date FROM (select AWD.BASE_ID BASE_ID,AWD.FUND_ID FUND_ID,AWDISB.LD_CAL_TYPE LD_CAL_TYPE, AWDISB.LD_SEQUENCE_NUMBER LD_SEQUENCE_NUMBER,LOAD.ALTERNATE_CODE LD_ALTERNATE_CODE , NVL(DECODE(SUM(NVL(AWDISB.DISB_ACCEPTED_AMT,0)),0,SUM(NVL(AWDISB.DISB_GROSS_AMT,0)),SUM(NVL(AWDISB.DISB_ACCEPTED_AMT,0))),0) AWARD_AMOUNT, SUM (NVL (AWDISB.DISB_PAID_AMT,0)) EARNINGS_TILL_DATE, NULL NOTIFICATION_SENT, NULL NOTIFICATION_DATE, NULL AUTH_ID, NULL AUTH_DATE FROM IGF_AW_AWARD_V AWD, IGF_AW_AWD_DISB AWDISB, IGS_CA_INST LOAD where AWD.AWARD_ID =AWDISB.AWARD_ID AND LOAD.CAL_TYPE = AWDISB.LD_CAL_TYPE AND LOAD.SEQUENCE_NUMBER= AWDISB.LD_SEQUENCE_NUMBER AND AWD.FED_FUND_CODE ='FWS' GROUP BY AWD.BASE_ID, AWD.FUND_ID, AWDISB.LD_CAL_TYPE, AWDISB.LD_SEQUENCE_NUMBER, LOAD.ALTERNATE_CODE )

View Text - HTML Formatted

SELECT BASE_ID
, FUND_ID
, LD_CAL_TYPE
, LD_SEQUENCE_NUMBER
, LD_ALTERNATE_CODE
, AWARD_AMOUNT
, EARNINGS_TILL_DATE
, (AWARD_AMOUNT - EARNINGS_TILL_DATE) REMAINING_AMOUNT
, (ROUND(EARNINGS_TILL_DATE/AWARD_AMOUNT) * 100) PROGRESS_TO_LIMIT
, NULL NOTIFICATION_SENT
, NULL NOTIFICATION_DATE
, NULL AUTH_ID
, NULL AUTH_DATE
FROM (SELECT AWD.BASE_ID BASE_ID
, AWD.FUND_ID FUND_ID
, AWDISB.LD_CAL_TYPE LD_CAL_TYPE
, AWDISB.LD_SEQUENCE_NUMBER LD_SEQUENCE_NUMBER
, LOAD.ALTERNATE_CODE LD_ALTERNATE_CODE
, NVL(DECODE(SUM(NVL(AWDISB.DISB_ACCEPTED_AMT
, 0))
, 0
, SUM(NVL(AWDISB.DISB_GROSS_AMT
, 0))
, SUM(NVL(AWDISB.DISB_ACCEPTED_AMT
, 0)))
, 0) AWARD_AMOUNT
, SUM (NVL (AWDISB.DISB_PAID_AMT
, 0)) EARNINGS_TILL_DATE
, NULL NOTIFICATION_SENT
, NULL NOTIFICATION_DATE
, NULL AUTH_ID
, NULL AUTH_DATE
FROM IGF_AW_AWARD_V AWD
, IGF_AW_AWD_DISB AWDISB
, IGS_CA_INST LOAD
WHERE AWD.AWARD_ID =AWDISB.AWARD_ID
AND LOAD.CAL_TYPE = AWDISB.LD_CAL_TYPE
AND LOAD.SEQUENCE_NUMBER= AWDISB.LD_SEQUENCE_NUMBER
AND AWD.FED_FUND_CODE ='FWS' GROUP BY AWD.BASE_ID
, AWD.FUND_ID
, AWDISB.LD_CAL_TYPE
, AWDISB.LD_SEQUENCE_NUMBER
, LOAD.ALTERNATE_CODE )