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: PA.PA_MC_EVENTS_AR#

Source

View Text - Preformatted


select PURGE_BATCH_ID PURGE_BATCH_ID, PURGE_RELEASE PURGE_RELEASE, PURGE_PROJECT_ID PURGE_PROJECT_ID, SET_OF_BOOKS_ID SET_OF_BOOKS_ID, EVENT_ID EVENT_ID, PROJECT_ID PROJECT_ID, TASK_ID TASK_ID, EVENT_NUM EVENT_NUM, REVENUE_AMOUNT REVENUE_AMOUNT, BILL_AMOUNT BILL_AMOUNT, CURRENCY_CODE CURRENCY_CODE, EXCHANGE_RATE EXCHANGE_RATE, CONVERSION_DATE CONVERSION_DATE, PRC_ASSIGNMENT_ID PRC_ASSIGNMENT_ID, RATE_TYPE RATE_TYPE, PROJFUNC_INV_RATE_DATE PROJFUNC_INV_RATE_DATE, PROJFUNC_INV_EXCHANGE_RATE PROJFUNC_INV_EXCHANGE_RATE, DESCRIPTION DESCRIPTION from "PA"."PA_MC_EVENTS_AR"

View Text - HTML Formatted

SELECT PURGE_BATCH_ID PURGE_BATCH_ID
, PURGE_RELEASE PURGE_RELEASE
, PURGE_PROJECT_ID PURGE_PROJECT_ID
, SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, EVENT_ID EVENT_ID
, PROJECT_ID PROJECT_ID
, TASK_ID TASK_ID
, EVENT_NUM EVENT_NUM
, REVENUE_AMOUNT REVENUE_AMOUNT
, BILL_AMOUNT BILL_AMOUNT
, CURRENCY_CODE CURRENCY_CODE
, EXCHANGE_RATE EXCHANGE_RATE
, CONVERSION_DATE CONVERSION_DATE
, PRC_ASSIGNMENT_ID PRC_ASSIGNMENT_ID
, RATE_TYPE RATE_TYPE
, PROJFUNC_INV_RATE_DATE PROJFUNC_INV_RATE_DATE
, PROJFUNC_INV_EXCHANGE_RATE PROJFUNC_INV_EXCHANGE_RATE
, DESCRIPTION DESCRIPTION
FROM "PA"."PA_MC_EVENTS_AR"