[Home] [Help]
View: IGS_FI_LB_REC_TYPES_V
Product: | IGS - Student System (Obsolete) |
Description: | Form View used for showing the mapping of bank supplied record type identifiers in the context of a lockbox. |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT LB.ROWID
, LB.LOCKBOX_NAME
, LB.RECORD_IDENTIFIER_CD
, LB.RECORD_TYPE_CODE
, LKP.MEANING
, LB.CREATED_BY
, LB.CREATION_DATE
, LB.LAST_UPDATE_DATE
, LB.LAST_UPDATED_BY
, LB.LAST_UPDATE_LOGIN
FROM IGS_FI_LB_REC_TYPES LB
, IGS_LOOKUP_VALUES LKP
WHERE LB. RECORD_TYPE_CODE = LKP.LOOKUP_CODE
AND LKP.LOOKUP_TYPE = 'IGS_FI_RECORD_IDENTIFIER'
Columns
Name |
ROW_ID |
LOCKBOX_NAME |
RECORD_IDENTIFIER_CD |
RECORD_TYPE_CODE |
RECORD_TYPE_MEANING |
CREATED_BY |
CREATION_DATE |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_LOGIN |