View: RA_INTERFACE_ERRORS_V

Product:	AR - Receivables
Description:
Implementation/DBA Data:	APPS.RA_INTERFACE_ERRORS_V

View Text

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

Columns