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_RETN_INV_DET_MRC_V

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

View Text

SELECT MC.SET_OF_BOOKS_ID
, MC.RETN_INVOICE_DETAIL_ID
, MC.PROJECT_ID
, MC.DRAFT_INVOICE_NUM
, MC.LINE_NUM
, PA.PROJECT_RETENTION_ID
, PA.TOTAL_RETAINED
, PA.INVPROC_CURRENCY_CODE
, MC.ACCT_CURRENCY_CODE
, MC.TOTAL_RETAINED
, PA.PROJECT_CURRENCY_CODE
, PA.PROJECT_TOTAL_RETAINED
, PA.FUNDING_CURRENCY_CODE
, PA.FUNDING_TOTAL_RETAINED
, MC.PROGRAM_APPLICATION_ID
, MC.PROGRAM_ID
, MC.PROGRAM_UPDATE_DATE
, MC.REQUEST_ID
, PA.CREATION_DATE
, PA.CREATED_BY
, PA.LAST_UPDATE_DATE
, PA.LAST_UPDATED_BY
FROM PA_RETN_INVOICE_DETAILS PA
, PA_MC_RETN_INV_DETAILS MC
WHERE MC.RETN_INVOICE_DETAIL_ID = PA.RETN_INVOICE_DETAIL_ID
AND MC.SET_OF_BOOKS_ID = NVL( TO_NUMBER( SUBSTRB( USERENV('CLIENT_INFO')
, 45
, 10) )
, -99)

Columns

Name
SET_OF_BOOKS_ID
RETN_INVOICE_DETAIL_ID
PROJECT_ID
DRAFT_INVOICE_NUM
LINE_NUM
PROJECT_RETENTION_ID
TOTAL_RETAINED
INVPROC_CURRENCY_CODE
PROJFUNC_CURRENCY_CODE
PROJFUNC_TOTAL_RETAINED
PROJECT_CURRENCY_CODE
PROJECT_TOTAL_RETAINED
FUNDING_CURRENCY_CODE
FUNDING_TOTAL_RETAINED
PROGRAM_APPLICATION_ID
PROGRAM_ID
PROGRAM_UPDATE_DATE
REQUEST_ID
CREATION_DATE
CREATED_BY
LAST_UPDATE_DATE
LAST_UPDATED_BY