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.FV_BE_RPR_HDR_V

Source

View Text - Preformatted


SELECT gt.event_id, rpr.budget_level_id, rpr.gl_date, rpr.transaction_id, rpr.doc_number, rpr.transaction_status, rpr.approved_by_user_id RPR_approved_by_user_id, 'RPR' source, rpr.set_of_books_id LEDGER_ID, gl.currency_code FROM XLA_EVENTS_GT gt, FV_BE_RPR_TRANSACTIONS rpr, GL_LEDGERS gl WHERE gt.event_id = rpr.event_id AND rpr.set_of_books_id = gl.ledger_id

View Text - HTML Formatted

SELECT GT.EVENT_ID
, RPR.BUDGET_LEVEL_ID
, RPR.GL_DATE
, RPR.TRANSACTION_ID
, RPR.DOC_NUMBER
, RPR.TRANSACTION_STATUS
, RPR.APPROVED_BY_USER_ID RPR_APPROVED_BY_USER_ID
, 'RPR' SOURCE
, RPR.SET_OF_BOOKS_ID LEDGER_ID
, GL.CURRENCY_CODE
FROM XLA_EVENTS_GT GT
, FV_BE_RPR_TRANSACTIONS RPR
, GL_LEDGERS GL
WHERE GT.EVENT_ID = RPR.EVENT_ID
AND RPR.SET_OF_BOOKS_ID = GL.LEDGER_ID