VIEW: APPS.CE_RECONCILIATION_ERRORS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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