View: CE_RECONCILIATION_ERRORS_V

Product:	CE - Cash Management
Description:	Reconciliation errors
Implementation/DBA Data:	APPS.CE_RECONCILIATION_ERRORS_V

View Text

SELECT ERR.ROWID ROW_ID
, SL.STATEMENT_HEADER_ID STATEMENT_HEADER_ID
, SL.STATEMENT_LINE_ID STATEMENT_LINE_ID
, SL.LINE_NUMBER STATEMENT_LINE_NUMBER
, ERR.MESSAGE_NAME MESSAGE_NAME
, ERR.CREATION_DATE CREATION_DATE
, ERR.CREATED_BY CREATED_BY
, NVL( ERR.APPLICATION_SHORT_NAME
, 'CE' ) APPLICATION_SHORT_NAME
FROM CE_RECONCILIATION_ERRORS ERR
, CE_STATEMENT_LINES SL
WHERE ERR.STATEMENT_LINE_ID = SL.STATEMENT_LINE_ID
AND ERR.STATEMENT_LINE_ID IS NOT NULL UNION ALL SELECT ERR.ROWID ROW_ID
, ERR.STATEMENT_HEADER_ID STATEMENT_HEADER_ID
, TO_NUMBER(NULL) STATEMENT_LINE_ID
, TO_NUMBER(NULL) STATEMENT_LINE_NUMBER
, ERR.MESSAGE_NAME MESSAGE_NAME
, ERR.CREATION_DATE CREATION_DATE
, ERR.CREATED_BY CREATED_BY
, NVL( ERR.APPLICATION_SHORT_NAME
, 'CE' ) APPLICATION_SHORT_NAME
FROM CE_RECONCILIATION_ERRORS ERR
WHERE ERR.STATEMENT_LINE_ID IS NULL

Columns