VIEW: APPS.IGF_AW_SS_DISB_V

Source

View Text - Preformatted

SELECT disb.award_id, awd.fund_id, SUM (disb.disb_gross_amt) offered_amt, SUM (disb.disb_accepted_amt) accepted_amt, SUM (disb.disb_paid_amt) paid_amt, awd.award_status, disb.ld_cal_type, disb.ld_sequence_number, aprd.award_prd_cd, aprd.ci_cal_type, aprd.ci_sequence_number, aprd.award_prd_desc, fa.base_id FROM igf_aw_award_all awd, igf_aw_awd_disb_all disb, igf_aw_award_prd aprd, igf_ap_fa_base_rec_all fa WHERE awd.award_id = disb.award_id AND fa.base_id = awd.base_id AND fa.ci_cal_type = aprd.ci_cal_type AND fa.ci_sequence_number = aprd.ci_sequence_number AND NVL (awd.publish_in_ss_flag, 'N') = 'Y' AND NOT EXISTS ( SELECT ld_cal_type, ld_sequence_number FROM igf_aw_awd_disb_all disb1 WHERE disb1.award_id = awd.award_id MINUS SELECT ld_cal_type, ld_sequence_number FROM igf_aw_awd_prd_term apt WHERE aprd.ci_cal_type = apt.ci_cal_type AND aprd.ci_sequence_number = apt.ci_sequence_number AND aprd.award_prd_cd = apt.award_prd_cd) GROUP BY disb.award_id, awd.fund_id, disb.ld_cal_type, disb.ld_sequence_number, awd.award_status, aprd.award_prd_cd, aprd.ci_cal_type, aprd.ci_sequence_number, aprd.award_prd_desc, fa.base_id ORDER BY disb.award_id, aprd.award_prd_cd

View Text - HTML Formatted

SELECT DISB.AWARD_ID
, AWD.FUND_ID
, SUM (DISB.DISB_GROSS_AMT) OFFERED_AMT
, SUM (DISB.DISB_ACCEPTED_AMT) ACCEPTED_AMT
, SUM (DISB.DISB_PAID_AMT) PAID_AMT
, AWD.AWARD_STATUS
, DISB.LD_CAL_TYPE
, DISB.LD_SEQUENCE_NUMBER
, APRD.AWARD_PRD_CD
, APRD.CI_CAL_TYPE
, APRD.CI_SEQUENCE_NUMBER
, APRD.AWARD_PRD_DESC
, FA.BASE_ID
FROM IGF_AW_AWARD_ALL AWD
, IGF_AW_AWD_DISB_ALL DISB
, IGF_AW_AWARD_PRD APRD
, IGF_AP_FA_BASE_REC_ALL FA
WHERE AWD.AWARD_ID = DISB.AWARD_ID
AND FA.BASE_ID = AWD.BASE_ID
AND FA.CI_CAL_TYPE = APRD.CI_CAL_TYPE
AND FA.CI_SEQUENCE_NUMBER = APRD.CI_SEQUENCE_NUMBER
AND NVL (AWD.PUBLISH_IN_SS_FLAG
, 'N') = 'Y'
AND NOT EXISTS ( SELECT LD_CAL_TYPE
, LD_SEQUENCE_NUMBER
FROM IGF_AW_AWD_DISB_ALL DISB1
WHERE DISB1.AWARD_ID = AWD.AWARD_ID MINUS SELECT LD_CAL_TYPE
, LD_SEQUENCE_NUMBER
FROM IGF_AW_AWD_PRD_TERM APT
WHERE APRD.CI_CAL_TYPE = APT.CI_CAL_TYPE
AND APRD.CI_SEQUENCE_NUMBER = APT.CI_SEQUENCE_NUMBER
AND APRD.AWARD_PRD_CD = APT.AWARD_PRD_CD) GROUP BY DISB.AWARD_ID
, AWD.FUND_ID
, DISB.LD_CAL_TYPE
, DISB.LD_SEQUENCE_NUMBER
, AWD.AWARD_STATUS
, APRD.AWARD_PRD_CD
, APRD.CI_CAL_TYPE
, APRD.CI_SEQUENCE_NUMBER
, APRD.AWARD_PRD_DESC
, FA.BASE_ID ORDER BY DISB.AWARD_ID
, APRD.AWARD_PRD_CD