VIEW: APPS.IGF_AW_ADISB_COA_MATCH_V

Source

View Text - Preformatted

SELECT AWD.BASE_ID, AWD.FUND_ID, DISB.AWARD_ID, DISB.DISB_NUM, DISB.LD_CAL_TYPE, DISB.LD_SEQUENCE_NUMBER, DISB.DISB_GROSS_AMT, DISB.DISB_NET_AMT, DISB.DISB_DATE, DISB.TRANS_TYPE FROM IGF_AW_AWARD_ALL AWD, IGF_AW_AWD_DISB_ALL DISB, IGF_AW_COA_ITM_TERMS COA WHERE AWD.AWARD_ID = DISB.AWARD_ID AND AWD.AWARD_STATUS IN ('OFFERED','ACCEPTED') AND AWD.BASE_ID = COA.BASE_ID AND DISB.LD_CAL_TYPE = COA.LD_CAL_TYPE AND DISB.LD_SEQUENCE_NUMBER = COA.LD_SEQUENCE_NUMBER

View Text - HTML Formatted

SELECT AWD.BASE_ID
, AWD.FUND_ID
, DISB.AWARD_ID
, DISB.DISB_NUM
, DISB.LD_CAL_TYPE
, DISB.LD_SEQUENCE_NUMBER
, DISB.DISB_GROSS_AMT
, DISB.DISB_NET_AMT
, DISB.DISB_DATE
, DISB.TRANS_TYPE
FROM IGF_AW_AWARD_ALL AWD
, IGF_AW_AWD_DISB_ALL DISB
, IGF_AW_COA_ITM_TERMS COA
WHERE AWD.AWARD_ID = DISB.AWARD_ID
AND AWD.AWARD_STATUS IN ('OFFERED'
, 'ACCEPTED')
AND AWD.BASE_ID = COA.BASE_ID
AND DISB.LD_CAL_TYPE = COA.LD_CAL_TYPE
AND DISB.LD_SEQUENCE_NUMBER = COA.LD_SEQUENCE_NUMBER