VIEW: APPS.IGS_FI_FIN_LT_PLAN_V

Source

View Text - Preformatted

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 )

View Text - HTML Formatted

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 )