VIEW: APPS.IGF_AW_FUND_DET_GRP_V

Source

View Text - Preformatted

SELECT FA.CI_CAL_TYPE, FA.CI_SEQUENCE_NUMBER, CI.ALTERNATE_CODE, CI.START_DT, CI.END_DT, FM.FUND_CODE, SUM(NVL(AWD.OFFERED_AMT,0)) , SUM(NVL(AWD.ACCEPTED_AMT,0)) , SUM(NVL(AWD.PAID_AMT,0)), FA.PERSON_NUMBER FROM IGF_AW_AWARD_V AWD , IGF_AW_FUND_MAST FM, IGF_AP_FA_CON_V FA, IGS_CA_INST CI WHERE AWD.FUND_ID = FM.FUND_ID AND CI.CAL_TYPE = FA.CI_CAL_TYPE AND AWD.AWARD_STATUS IN ('OFFERED','ACCEPTED') AND CI.SEQUENCE_NUMBER=FA.CI_SEQUENCE_NUMBER AND AWD.BASE_ID=FA.BASE_ID GROUP BY FA.CI_CAL_TYPE, FA.CI_SEQUENCE_NUMBER, CI.ALTERNATE_CODE, CI.START_DT, CI.END_DT, FM.FUND_CODE, FA.PERSON_NUMBER

View Text - HTML Formatted

SELECT FA.CI_CAL_TYPE
, FA.CI_SEQUENCE_NUMBER
, CI.ALTERNATE_CODE
, CI.START_DT
, CI.END_DT
, FM.FUND_CODE
, SUM(NVL(AWD.OFFERED_AMT
, 0))
, SUM(NVL(AWD.ACCEPTED_AMT
, 0))
, SUM(NVL(AWD.PAID_AMT
, 0))
, FA.PERSON_NUMBER
FROM IGF_AW_AWARD_V AWD
, IGF_AW_FUND_MAST FM
, IGF_AP_FA_CON_V FA
, IGS_CA_INST CI
WHERE AWD.FUND_ID = FM.FUND_ID
AND CI.CAL_TYPE = FA.CI_CAL_TYPE
AND AWD.AWARD_STATUS IN ('OFFERED'
, 'ACCEPTED')
AND CI.SEQUENCE_NUMBER=FA.CI_SEQUENCE_NUMBER
AND AWD.BASE_ID=FA.BASE_ID GROUP BY FA.CI_CAL_TYPE
, FA.CI_SEQUENCE_NUMBER
, CI.ALTERNATE_CODE
, CI.START_DT
, CI.END_DT
, FM.FUND_CODE
, FA.PERSON_NUMBER