eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: IGS_FI_LB_OVFL_ERRS_V

Product:	IGS - Student System
Description:	Form View used to display the lockbox receipt overflow records that had validation errors detected during the import process from the interface table.
Implementation/DBA Data:	APPS.IGS_FI_LB_OVFL_ERRS_V

View Text

SELECT LBOE.ROWID
, LBOE.RECEIPT_OVERFLOW_ERROR_ID
, LBOE.LOCKBOX_RECEIPT_ERROR_ID
, LBOE.CHARGE_CD1
, LBOE.CHARGE_CD2
, LBOE.CHARGE_CD3
, LBOE.CHARGE_CD4
, LBOE.CHARGE_CD5
, LBOE.CHARGE_CD6
, LBOE.CHARGE_CD7
, LBOE.CHARGE_CD8
, LBOE.APPLIED_AMT1
, LBOE.APPLIED_AMT2
, LBOE.APPLIED_AMT3
, LBOE.APPLIED_AMT4
, LBOE.APPLIED_AMT5
, LBOE.APPLIED_AMT6
, LBOE.APPLIED_AMT7
, LBOE.APPLIED_AMT8
, LBOE.CREATED_BY
, LBOE.CREATION_DATE
, LBOE.LAST_UPDATE_DATE
, LBOE.LAST_UPDATED_BY
, LBOE.LAST_UPDATE_LOGIN
, LBOE.REQUEST_ID
, LBOE.PROGRAM_ID
, LBOE.PROGRAM_APPLICATION_ID
, LBOE.PROGRAM_UPDATE_DATE
FROM IGS_FI_LB_OVFL_ERRS LBOE

Columns

Name
ROW_ID
RECEIPT_OVERFLOW_ERROR_ID
LOCKBOX_RECEIPT_ERROR_ID
CHARGE_CD1
CHARGE_CD2
CHARGE_CD3
CHARGE_CD4
CHARGE_CD5
CHARGE_CD6
CHARGE_CD7
CHARGE_CD8
APPLIED_AMT1
APPLIED_AMT2
APPLIED_AMT3
APPLIED_AMT4
APPLIED_AMT5
APPLIED_AMT6
APPLIED_AMT7
APPLIED_AMT8
CREATED_BY
CREATION_DATE
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
REQUEST_ID
PROGRAM_ID
PROGRAM_APPLICATION_ID
PROGRAM_UPDATE_DATE