View: IGS_FI_FIN_LT_PLAN_V

Product:	IGS - Student System
Description:	This a FORM VIEW and is created by joining IGS_FI_FIN_LT_PLAN table, IGS_FI_SUBACCTS MO view, IGS_FI_FEE_TYPE MO view and IGS_LOOKUPS View. This view holds details of Finance and late charges plan information.
Implementation/DBA Data:	APPS.IGS_FI_FIN_LT_PLAN_V

View Text

SELECT FLP.ROWID
, FLP.PLAN_NAME
, FLP.PLAN_TYPE
, LKP1.MEANING
, FLP.DESCRIPTION
, FLP.CLOSED_IND
, FLP.SUBACCOUNT_ID
, NULL
, FLP.BALANCE_TYPE
, LKP2.MEANING
, FLP.FEE_TYPE
, FT.DESCRIPTION
, FLP.ACCRUAL_TYPE
, LKP3.MEANING
, FLP.OFFSET_DAYS
, FLP.CHG_RATE
, FLP.FLAT_AMOUNT
, FLP.MAX_CHARGE_AMOUNT
, FLP.MIN_CHARGE_AMOUNT
, FLP.MIN_CHARGE_AMOUNT_NO_CHARGE
, FLP.MIN_BALANCE_AMOUNT
, FLP.ATTRIBUTE_CATEGORY
, FLP.ATTRIBUTE1
, FLP.ATTRIBUTE2
, FLP.ATTRIBUTE3
, FLP.ATTRIBUTE4
, FLP.ATTRIBUTE5
, FLP.ATTRIBUTE6
, FLP.ATTRIBUTE7
, FLP.ATTRIBUTE8
, FLP.ATTRIBUTE9
, FLP.ATTRIBUTE10
, FLP.ATTRIBUTE11
, FLP.ATTRIBUTE12
, FLP.ATTRIBUTE13
, FLP.ATTRIBUTE14
, FLP.ATTRIBUTE15
, FLP.ATTRIBUTE16
, FLP.ATTRIBUTE17
, FLP.ATTRIBUTE18
, FLP.ATTRIBUTE19
, FLP.ATTRIBUTE20
, FLP.CREATED_BY
, FLP.CREATION_DATE
, FLP.LAST_UPDATED_BY
, FLP.LAST_UPDATE_DATE
, FLP.LAST_UPDATE_LOGIN
, FLP.PAYMENT_PLAN_ACCRL_TYPE_CODE
, LKP4.MEANING
, FLP.PAYMENT_PLAN_CHG_RATE
, FLP.PAYMENT_PLAN_FLAT_AMT
, FLP.PAYMENT_PLAN_MAX_CHARGE_AMT
, FLP.PAYMENT_PLAN_MIN_CHARGE_AMT
, FLP.PAYMENT_PLAN_MINCHGAMT_NOCHG
, FLP.PAYMENT_PLAN_MIN_BALANCE_AMT
FROM IGS_FI_FIN_LT_PLAN FLP
, IGS_LOOKUPS_VIEW LKP1
, IGS_LOOKUPS_VIEW LKP2
, IGS_FI_FEE_TYPE FT
, IGS_LOOKUPS_VIEW LKP3
, IGS_LOOKUPS_VIEW LKP4
WHERE (LKP1.LOOKUP_TYPE = 'IGS_FI_PLAN_TYPE'
AND LKP1.LOOKUP_CODE = FLP.PLAN_TYPE)
AND (LKP2.LOOKUP_TYPE = 'IGS_FI_BALANCE_TYPE'
AND LKP2.LOOKUP_CODE = FLP.BALANCE_TYPE)
AND FLP.FEE_TYPE = FT.FEE_TYPE
AND (LKP3.LOOKUP_TYPE = 'IGS_FI_ACCRUAL_TYPE'
AND LKP3.LOOKUP_CODE = FLP.ACCRUAL_TYPE)
AND (LKP4.LOOKUP_TYPE (+) = 'IGS_FI_ACCRUAL_TYPE'
AND LKP4.LOOKUP_CODE (+) = FLP.PAYMENT_PLAN_ACCRL_TYPE_CODE )

Columns