[Home] [Help]
View: 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
Name |
ROW_ID |
STATEMENT_HEADER_ID |
STATEMENT_LINE_ID |
STATEMENT_LINE_NUMBER |
MESSAGE_NAME |
CREATION_DATE |
CREATED_BY |
APPLICATION_SHORT_NAME |