View: IGS_FI_BILL_PLN_CRD_V

Product:	IGS - Student System
Description:	This view is used in Billing History form to display the planned credits that got extracted for a particular bill.
Implementation/DBA Data:	APPS.IGS_FI_BILL_PLN_CRD_V

View Text

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

Columns