VIEW: APPS.IGS_FI_PLN_CREDITS_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'