[Home] [Help]
View: 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
Name |
INTERFACE_ID |
INTERFACE_TYPE |
MAIN_TYPE |
MESSAGE_TEXT |
INVALID_VALUE |
LINK_TO_LINE_ID |
LINE_ID |
ORG_ID |