[Home] [Help]
View: IGS_FI_LB_CR_TYPES_V
Product: | IGS - Student System (Obsolete) |
Description: | Form view used to show the mapping of bank-supplied codes with pre-defined Credit Types 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.CREDIT_TYPE_ID
, CR.CREDIT_TYPE_NAME
, LB.CREATED_BY
, LB.CREATION_DATE
, LB.LAST_UPDATE_DATE
, LB.LAST_UPDATED_BY
, LB.LAST_UPDATE_LOGIN
FROM IGS_FI_LB_CR_TYPES LB
, IGS_FI_CR_TYPES CR
WHERE LB.CREDIT_TYPE_ID = CR.CREDIT_TYPE_ID
Columns
Name |
ROW_ID |
LOCKBOX_NAME |
BANK_CD |
CREDIT_TYPE_ID |
CREDIT_TYPE_NAME |
CREATED_BY |
CREATION_DATE |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_LOGIN |