[Home] [Help]
| Product: | IGS - Student System (Obsolete) |
|---|---|
| Description: | |
| Implementation/DBA Data: | Not implemented in this database |
SELECT DISB.ROW_ID
, DISB.AWARD_ID
, BASE.PERSON_ID
, DISB.DISB_NUM
, DISB.DISB_NET_AMT
, DISB.DISB_DATE
, DISB.SHOW_ON_BILL
, DISB.LD_CAL_TYPE
, DISB.LD_SEQUENCE_NUMBER
, CIR.SUP_CAL_TYPE
, CIR.SUP_CI_SEQUENCE_NUMBER
, CA.START_DT
, CA.END_DT
, DISB.TRANS_TYPE
, FMAST.FUND_CODE
, FMAST.FUND_ID
, NULL
, FMAST.CREDIT_TYPE_ID
, DISB.CREATED_BY
, DISB.CREATION_DATE
, DISB.LAST_UPDATED_BY
, DISB.LAST_UPDATE_DATE
, DISB.LAST_UPDATE_LOGIN
FROM IGF_AW_AWD_DISB DISB
, IGF_AW_AWARD AWD
, IGF_AP_FA_BASE_REC BASE
, IGF_AW_FUND_MAST FMAST
, IGS_CA_INST_REL CIR
, IGS_CA_TYPE CT
, IGS_CA_INST CA
, IGF_AP_BATCH_AW_MAP BM
WHERE DISB.AWARD_ID = AWD.AWARD_ID
AND AWD.FUND_ID = FMAST.FUND_ID
AND AWD.BASE_ID = BASE.BASE_ID
AND DISB.LD_CAL_TYPE = CIR.SUB_CAL_TYPE (+)
AND DISB.LD_SEQUENCE_NUMBER = CIR.SUB_CI_SEQUENCE_NUMBER (+)
AND CT.CAL_TYPE (+) = CIR.SUP_CAL_TYPE
AND CIR.SUP_CAL_TYPE = CA.CAL_TYPE (+)
AND CIR.SUP_CI_SEQUENCE_NUMBER = CA.SEQUENCE_NUMBER (+)
AND FMAST.CI_CAL_TYPE = BM.CI_CAL_TYPE
AND FMAST.CI_SEQUENCE_NUMBER = BM.CI_SEQUENCE_NUMBER
AND (CT.S_CAL_CAT = 'FEE' OR CT.S_CAL_CAT IS NULL)
AND DISB.TRANS_TYPE = 'P'
AND DISB.SHOW_ON_BILL = 'Y'
AND AWD.AWARD_STATUS = 'ACCEPTED'
AND BM.AWARD_YEAR_STATUS_CODE = 'O'