FND Design Data [Home] [Help]

View: CEFV_BSRE

Product: CE - Cash Management
Description: Business View
Implementation/DBA Data: ViewAPPS.CEFV_BSRE
View Text

SELECT RE.STATEMENT_LINE_ID
, NE.MESSAGE_TEXT
, SL.LINE_NUMBER
, RE.CREATION_DATE
, RE.CREATED_BY
, RE.CREATION_DATE
, RE.CREATED_BY
FROM CE_RECONCILIATION_ERRORS RE
, FND_NEW_MESSAGES NE
, CE_STATEMENT_LINES SL
WHERE NE.APPLICATION_ID = 260
AND NE.LANGUAGE_CODE = USERENV('LANG')
AND NE.MESSAGE_NAME = RE.MESSAGE_NAME
AND SL.STATEMENT_LINE_ID = RE.STATEMENT_LINE_ID WITH READ ONLY

Columns

Name
STATEMENT_LINE_ID
ERROR_MESSAGE
STATEMENT_LINE_NUMBER
CREATED_DATE
CREATED_BY
LAST_UPDATED_DATE
LAST_UPDATED_BY