[Home] [Help]
| Product: | IGS - Student System (Obsolete) |
|---|---|
| Description: | This view is used in Billing History form to display the planned credits that got extracted for a particular bill. |
| Implementation/DBA Data: | Not implemented in this database |
SELECT PLN.ROWID
, PLN.BILL_ID
, PLN.PLN_CREDIT_DATE
, PLN.AWARD_ID
, PLN.DISB_NUM
, PLN.FUND_ID
, FMAST.FUND_CODE
, PLN.FEE_CAL_TYPE
, PLN.FEE_CI_SEQUENCE_NUMBER
, PLN.PLN_CREDIT_AMOUNT
, INST.START_DT
, INST.END_DT
, PLN.BILL_DESC
, PLN.CREATED_BY
, PLN.CREATION_DATE
, PLN.LAST_UPDATED_BY
, PLN.LAST_UPDATE_DATE
, PLN.LAST_UPDATE_LOGIN
, PLN.REQUEST_ID
, PLN.PROGRAM_APPLICATION_ID
, PLN.PROGRAM_ID
, PLN.PROGRAM_UPDATE_DATE
FROM IGS_FI_BILL_PLN_CRD PLN
, IGF_AW_FUND_MAST FMAST
, IGS_CA_INST INST
WHERE PLN.FEE_CAL_TYPE = INST.CAL_TYPE (+)
AND PLN.FEE_CI_SEQUENCE_NUMBER = INST.SEQUENCE_NUMBER (+)
AND PLN.FUND_ID = FMAST.FUND_ID