Product: | IGS - Student System (Obsolete) |
---|---|
Description: | Form View used for Lockbox Setup. |
Implementation/DBA Data: | Not implemented in this database |
SELECT LB.ROWID
, LB.LOCKBOX_NAME
, LB.LOCKBOX_DESC
, LB.CLOSED_FLAG
, LB.GL_DATE_SOURCE_CODE
, LKP.MEANING
, LB.DEFAULT_CREDIT_TYPE_ID
, CR.CREDIT_TYPE_NAME
, NULL
, NULL
, LB.BANK_ACCOUNT_ID
, NULL
, LB.ATTRIBUTE_CATEGORY
, LB.ATTRIBUTE1
, LB.ATTRIBUTE2
, LB.ATTRIBUTE3
, LB.ATTRIBUTE4
, LB.ATTRIBUTE5
, LB.ATTRIBUTE6
, LB.ATTRIBUTE7
, LB.ATTRIBUTE8
, LB.ATTRIBUTE9
, LB.ATTRIBUTE10
, LB.ATTRIBUTE11
, LB.ATTRIBUTE12
, LB.ATTRIBUTE13
, LB.ATTRIBUTE14
, LB.ATTRIBUTE15
, LB.ATTRIBUTE16
, LB.ATTRIBUTE17
, LB.ATTRIBUTE18
, LB.ATTRIBUTE19
, LB.ATTRIBUTE20
, LB.CREATED_BY
, LB.CREATION_DATE
, LB.LAST_UPDATE_DATE
, LB.LAST_UPDATED_BY
, LB.LAST_UPDATE_LOGIN
FROM IGS_FI_LOCKBOXES LB
, IGS_FI_CR_TYPES CR
, IGS_LOOKUP_VALUES LKP
WHERE LB.GL_DATE_SOURCE_CODE = LKP.LOOKUP_CODE
AND LKP.LOOKUP_TYPE = 'IGS_FI_GL_DATE_SOURCE'
AND LB.DEFAULT_CREDIT_TYPE_ID = CR.CREDIT_TYPE_ID (+)