eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.CEFV_BSRE

Source

View Text - Preformatted


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

View Text - HTML Formatted

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