Product: | IGS - Student System (Obsolete) |
---|---|
Description: | View for retrieving the records from Billing Deposits. |
Implementation/DBA Data: | Not implemented in this database |
SELECT BDP.ROWID
, BDP.BILL_ID
, BDP.CREDIT_ACTIVITY_ID
, CRA.TRANSACTION_DATE
, CRD.CREDIT_NUMBER
, CRT.CREDIT_CLASS
, LKV.MEANING
, CRD.CREDIT_TYPE_ID
, CRT.CREDIT_TYPE_NAME
, CRA.AMOUNT
, BDP.CREATED_BY
, BDP.CREATION_DATE
, BDP.LAST_UPDATED_BY
, BDP.LAST_UPDATE_DATE
, BDP.LAST_UPDATE_LOGIN
FROM IGS_FI_BILL_DPSTS BDP
, IGS_FI_CR_ACTIVITIES CRA
, IGS_FI_CREDITS CRD
, IGS_FI_CR_TYPES CRT
, IGS_LOOKUP_VALUES LKV
WHERE BDP.CREDIT_ACTIVITY_ID = CRA.CREDIT_ACTIVITY_ID
AND CRA.CREDIT_ID = CRD.CREDIT_ID
AND CRD.CREDIT_TYPE_ID = CRT.CREDIT_TYPE_ID
AND CRT.CREDIT_CLASS= LKV.LOOKUP_CODE
AND LKV.LOOKUP_TYPE = 'IGS_FI_CREDIT_CLASS'