[Home] [Help]
View: IGS_FI_LB_FCIS_V
Product: | IGS - Student System (Obsolete) |
Description: | Form View used to show the mapping of bank codes with the fee calendar instances in the context of a Lockbox. |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT LB.ROWID
, LB.LOCKBOX_NAME
, LB.BANK_CD
, LB.FEE_CAL_TYPE
, LB.FEE_CI_SEQUENCE_NUMBER
, CI.DESCRIPTION
, LB.CREATED_BY
, LB.CREATION_DATE
, LB.LAST_UPDATE_DATE
, LB.LAST_UPDATED_BY
, LB.LAST_UPDATE_LOGIN
FROM IGS_FI_LB_FCIS LB
, IGS_CA_INST CI
WHERE LB.FEE_CAL_TYPE = CI.CAL_TYPE
AND LB.FEE_CI_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER
Columns
Name |
ROW_ID |
LOCKBOX_NAME |
BANK_CD |
FEE_CAL_TYPE |
FEE_CI_SEQUENCE_NUMBER |
FEE_CI_DESCRIPTION |
CREATED_BY |
CREATION_DATE |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_LOGIN |