View: IGS_FI_LB_REC_TYPES_V

Product:	IGS - Student System
Description:	Form View used for showing the mapping of bank supplied record type identifiers in the context of a lockbox.
Implementation/DBA Data:	APPS.IGS_FI_LB_REC_TYPES_V

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