VIEW: APPS.IGS_FI_LOCKBOXES_V

Source

View Text - Preformatted

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 (+)

View Text - HTML Formatted

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 (+)