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.

[Home] [Help]

View: PA_DRAFT_REVENUE_ITEMS_MRC_V

Product:	PA - Projects
Description:	Single currency MRC view
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT DRI.PROJECT_ID
, DRI.DRAFT_REVENUE_NUM
, DRI.LINE_NUM
, DRI.LAST_UPDATE_DATE
, DRI.LAST_UPDATED_BY
, DRI.CREATION_DATE
, DRI.CREATED_BY
, DRI.TASK_ID
, PA_MC_CURRENCY_PKG.SUM_MC_CUST_RDL_ERDL(DRI.PROJECT_ID
, DRI.DRAFT_REVENUE_NUM
, DRI.LINE_NUM)
, DRI.REVENUE_SOURCE
, DRI.REVENUE_CATEGORY_CODE
, DRI.LAST_UPDATE_LOGIN
, DRI.REQUEST_ID
, DRI.PROGRAM_APPLICATION_ID
, DRI.PROGRAM_ID
, DRI.PROGRAM_UPDATE_DATE
, GL_MC_CURRENCY_PKG.GET_CURRENCY_CODE(NVL(TO_NUMBER( SUBSTRB( USERENV('CLIENT_INFO')
, 45
, 10) )
, -99))
, PA_MC_CURRENCY_PKG.SUM_MC_CUST_RDL_ERDL(DRI.PROJECT_ID
, DRI.DRAFT_REVENUE_NUM
, DRI.LINE_NUM)
, DRI.PROJECT_CURRENCY_CODE
, DRI.PROJECT_REVENUE_AMOUNT
, DRI.FUNDING_CURRENCY_CODE
, DRI.FUNDING_REVENUE_AMOUNT
, GL_MC_CURRENCY_PKG.GET_CURRENCY_CODE(NVL(TO_NUMBER( SUBSTRB( USERENV('CLIENT_INFO')
, 45
, 10) )
, -99))
, NULL
, NULL
, NULL
, NVL(DRI.REVTRANS_AMOUNT
, DRI.AMOUNT)
, NVL(DRI.REVTRANS_CURRENCY_CODE
, DRI.REVPROC_CURRENCY_CODE)
, NULL
, NULL
, NULL
FROM PA_DRAFT_REVENUE_ITEMS DRI

Columns

Name
PROJECT_ID
DRAFT_REVENUE_NUM
LINE_NUM
LAST_UPDATE_DATE
LAST_UPDATED_BY
CREATION_DATE
CREATED_BY
TASK_ID
AMOUNT
REVENUE_SOURCE
REVENUE_CATEGORY_CODE
LAST_UPDATE_LOGIN
REQUEST_ID
PROGRAM_APPLICATION_ID
PROGRAM_ID
PROGRAM_UPDATE_DATE
PROJFUNC_CURRENCY_CODE
PROJFUNC_REVENUE_AMOUNT
PROJECT_CURRENCY_CODE
PROJECT_REVENUE_AMOUNT
FUNDING_CURRENCY_CODE
FUNDING_REVENUE_AMOUNT
REVPROC_CURRENCY_CODE
FUNDING_RATE_TYPE
FUNDING_RATE_DATE
FUNDING_EXCHANGE_RATE
REVTRANS_AMOUNT
REVTRANS_CURRENCY_CODE
REVPROC_REVTRANS_RATE_TYPE
REVPROC_REVTRANS_RATE_DATE
REVPROC_REVTRANS_EX_RATE