VIEW: APPS.RA_INTERFACE_ERRORS_V

Source

View Text - Preformatted

SELECT NVL(LINE.INTERFACE_LINE_ID, ERR.LINK_TO_LINE_ID) INTERFACE_ID , NVL(LINE.LINE_TYPE, 'TAX') INTERFACE_TYPE , 'LINE' MAIN_TYPE , ERR.MESSAGE_TEXT , ERR.INVALID_VALUE , ERR.LINK_TO_LINE_ID , NVL(LINE.LINK_TO_LINE_ID,LINE.INTERFACE_LINE_ID) LINE_ID , LINE.ORG_ID FROM RA_INTERFACE_ERRORS ERR, RA_INTERFACE_LINES LINE WHERE ERR.INTERFACE_LINE_ID = LINE.INTERFACE_LINE_ID (+) AND ERR.INTERFACE_DISTRIBUTION_ID IS NULL AND ERR.INTERFACE_SALESCREDIT_ID IS NULL UNION SELECT ERR.INTERFACE_DISTRIBUTION_ID, 'DISTRIBUTION', LINE.LINE_TYPE, ERR.MESSAGE_TEXT, ERR.INVALID_VALUE, ERR.INTERFACE_LINE_ID, NVL(LINE.LINK_TO_LINE_ID,LINE.INTERFACE_LINE_ID), LINE.ORG_ID FROM RA_INTERFACE_ERRORS ERR, RA_INTERFACE_LINES LINE WHERE ERR.INTERFACE_DISTRIBUTION_ID IS NOT NULL AND ERR.INTERFACE_LINE_ID = LINE.INTERFACE_LINE_ID UNION SELECT ERR.INTERFACE_SALESCREDIT_ID, 'SALESCREDIT', 'LINE', ERR.MESSAGE_TEXT, ERR.INVALID_VALUE, ERR.INTERFACE_LINE_ID, ERR.INTERFACE_LINE_ID, ERR.ORG_ID FROM RA_INTERFACE_ERRORS ERR WHERE ERR.INTERFACE_SALESCREDIT_ID IS NOT NULL UNION SELECT ERR.INTERFACE_CONTINGENCY_ID, 'CONTINGENCIES', 'LINE', ERR.MESSAGE_TEXT, ERR.INVALID_VALUE, ERR.INTERFACE_LINE_ID, ERR.INTERFACE_LINE_ID, ERR.ORG_ID FROM RA_INTERFACE_ERRORS ERR WHERE ERR.INTERFACE_CONTINGENCY_ID IS NOT NULL

View Text - HTML Formatted

SELECT NVL(LINE.INTERFACE_LINE_ID
, ERR.LINK_TO_LINE_ID) INTERFACE_ID
, NVL(LINE.LINE_TYPE
, 'TAX') INTERFACE_TYPE
, 'LINE' MAIN_TYPE
, ERR.MESSAGE_TEXT
, ERR.INVALID_VALUE
, ERR.LINK_TO_LINE_ID
, NVL(LINE.LINK_TO_LINE_ID
, LINE.INTERFACE_LINE_ID) LINE_ID
, LINE.ORG_ID
FROM RA_INTERFACE_ERRORS ERR
, RA_INTERFACE_LINES LINE
WHERE ERR.INTERFACE_LINE_ID = LINE.INTERFACE_LINE_ID (+)
AND ERR.INTERFACE_DISTRIBUTION_ID IS NULL
AND ERR.INTERFACE_SALESCREDIT_ID IS NULL UNION SELECT ERR.INTERFACE_DISTRIBUTION_ID
, 'DISTRIBUTION'
, LINE.LINE_TYPE
, ERR.MESSAGE_TEXT
, ERR.INVALID_VALUE
, ERR.INTERFACE_LINE_ID
, NVL(LINE.LINK_TO_LINE_ID
, LINE.INTERFACE_LINE_ID)
, LINE.ORG_ID
FROM RA_INTERFACE_ERRORS ERR
, RA_INTERFACE_LINES LINE
WHERE ERR.INTERFACE_DISTRIBUTION_ID IS NOT NULL
AND ERR.INTERFACE_LINE_ID = LINE.INTERFACE_LINE_ID UNION SELECT ERR.INTERFACE_SALESCREDIT_ID
, 'SALESCREDIT'
, 'LINE'
, ERR.MESSAGE_TEXT
, ERR.INVALID_VALUE
, ERR.INTERFACE_LINE_ID
, ERR.INTERFACE_LINE_ID
, ERR.ORG_ID
FROM RA_INTERFACE_ERRORS ERR
WHERE ERR.INTERFACE_SALESCREDIT_ID IS NOT NULL UNION SELECT ERR.INTERFACE_CONTINGENCY_ID
, 'CONTINGENCIES'
, 'LINE'
, ERR.MESSAGE_TEXT
, ERR.INVALID_VALUE
, ERR.INTERFACE_LINE_ID
, ERR.INTERFACE_LINE_ID
, ERR.ORG_ID
FROM RA_INTERFACE_ERRORS ERR
WHERE ERR.INTERFACE_CONTINGENCY_ID IS NOT NULL