VIEW: APPS.IGS_FI_LB_RECT_ERRS_V

Source

View Text - Preformatted

SELECT LBERR.ROWID, LBERR.LOCKBOX_RECEIPT_ERROR_ID, LBERR.LOCKBOX_INTERFACE_ID, LBERR.ITEM_NUMBER, LBERR.LOCKBOX_NAME, LBERR.RECEIPT_AMT, LBERR.BATCH_NAME, LBERR.PARTY_NUMBER, LBERR.PAYER_NAME, LBERR.CHECK_CD, LBERR.DEPOSIT_DATE, LBERR.CREDIT_TYPE_CD, LBERR.FEE_CAL_INSTANCE_CD, LBERR.CHARGE_CD1, LBERR.CHARGE_CD2, LBERR.CHARGE_CD3, LBERR.CHARGE_CD4, LBERR.CHARGE_CD5, LBERR.CHARGE_CD6, LBERR.CHARGE_CD7, LBERR.CHARGE_CD8, LBERR.APPLIED_AMT1, LBERR.APPLIED_AMT2, LBERR.APPLIED_AMT3, LBERR.APPLIED_AMT4, LBERR.APPLIED_AMT5, LBERR.APPLIED_AMT6, LBERR.APPLIED_AMT7, LBERR.APPLIED_AMT8, LBERR.ADM_APPLICATION_ID, LBERR.ATTRIBUTE_CATEGORY, LBERR.ATTRIBUTE1, LBERR.ATTRIBUTE2, LBERR.ATTRIBUTE3, LBERR.ATTRIBUTE4, LBERR.ATTRIBUTE5, LBERR.ATTRIBUTE6, LBERR.ATTRIBUTE7, LBERR.ATTRIBUTE8, LBERR.ATTRIBUTE9, LBERR.ATTRIBUTE10, LBERR.ATTRIBUTE11, LBERR.ATTRIBUTE12, LBERR.ATTRIBUTE13, LBERR.ATTRIBUTE14, LBERR.ATTRIBUTE15, LBERR.ATTRIBUTE16, LBERR.ATTRIBUTE17, LBERR.ATTRIBUTE18, LBERR.ATTRIBUTE19, LBERR.ATTRIBUTE20, LBERR.CREATED_BY, LBERR.CREATION_DATE, LBERR.LAST_UPDATE_DATE, LBERR.LAST_UPDATED_BY, LBERR.LAST_UPDATE_LOGIN, LBERR.REQUEST_ID, LBERR.PROGRAM_ID, LBERR.PROGRAM_APPLICATION_ID, LBERR.PROGRAM_UPDATE_DATE FROM IGS_FI_LB_RECT_ERRS LBERR

View Text - HTML Formatted

SELECT LBERR.ROWID
, LBERR.LOCKBOX_RECEIPT_ERROR_ID
, LBERR.LOCKBOX_INTERFACE_ID
, LBERR.ITEM_NUMBER
, LBERR.LOCKBOX_NAME
, LBERR.RECEIPT_AMT
, LBERR.BATCH_NAME
, LBERR.PARTY_NUMBER
, LBERR.PAYER_NAME
, LBERR.CHECK_CD
, LBERR.DEPOSIT_DATE
, LBERR.CREDIT_TYPE_CD
, LBERR.FEE_CAL_INSTANCE_CD
, LBERR.CHARGE_CD1
, LBERR.CHARGE_CD2
, LBERR.CHARGE_CD3
, LBERR.CHARGE_CD4
, LBERR.CHARGE_CD5
, LBERR.CHARGE_CD6
, LBERR.CHARGE_CD7
, LBERR.CHARGE_CD8
, LBERR.APPLIED_AMT1
, LBERR.APPLIED_AMT2
, LBERR.APPLIED_AMT3
, LBERR.APPLIED_AMT4
, LBERR.APPLIED_AMT5
, LBERR.APPLIED_AMT6
, LBERR.APPLIED_AMT7
, LBERR.APPLIED_AMT8
, LBERR.ADM_APPLICATION_ID
, LBERR.ATTRIBUTE_CATEGORY
, LBERR.ATTRIBUTE1
, LBERR.ATTRIBUTE2
, LBERR.ATTRIBUTE3
, LBERR.ATTRIBUTE4
, LBERR.ATTRIBUTE5
, LBERR.ATTRIBUTE6
, LBERR.ATTRIBUTE7
, LBERR.ATTRIBUTE8
, LBERR.ATTRIBUTE9
, LBERR.ATTRIBUTE10
, LBERR.ATTRIBUTE11
, LBERR.ATTRIBUTE12
, LBERR.ATTRIBUTE13
, LBERR.ATTRIBUTE14
, LBERR.ATTRIBUTE15
, LBERR.ATTRIBUTE16
, LBERR.ATTRIBUTE17
, LBERR.ATTRIBUTE18
, LBERR.ATTRIBUTE19
, LBERR.ATTRIBUTE20
, LBERR.CREATED_BY
, LBERR.CREATION_DATE
, LBERR.LAST_UPDATE_DATE
, LBERR.LAST_UPDATED_BY
, LBERR.LAST_UPDATE_LOGIN
, LBERR.REQUEST_ID
, LBERR.PROGRAM_ID
, LBERR.PROGRAM_APPLICATION_ID
, LBERR.PROGRAM_UPDATE_DATE
FROM IGS_FI_LB_RECT_ERRS LBERR