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]

Table: PA_RETN_INVOICE_DETAILS

Product:	PA - Projects
Description:	PA_RETN_INVOICE_DETAILS stores total retained amount as of the invoice generation
Implementation/DBA Data:	PA.PA_RETN_INVOICE_DETAILS

Foreign Keys

Table	Foreign Table	Foreign Key Column
PA_RETN_INVOICE_DETAILS	PA_DRAFT_INVOICE_ITEMS	PA_RETN_INVOICE_DETAILS.PROJECT_ID PA_RETN_INVOICE_DETAILS.DRAFT_INVOICE_NUM PA_RETN_INVOICE_DETAILS.LINE_NUM
PA_RETN_INVOICE_DETAILS	PA_PROJECTS_ALL	PA_RETN_INVOICE_DETAILS.PROJECT_ID
PA_RETN_INVOICE_DETAILS	FND_CURRENCIES	PA_RETN_INVOICE_DETAILS.PROJECT_CURRENCY_CODE
PA_RETN_INVOICE_DETAILS	FND_CURRENCIES	PA_RETN_INVOICE_DETAILS.PROJFUNC_CURRENCY_CODE
PA_RETN_INVOICE_DETAILS	FND_CURRENCIES	PA_RETN_INVOICE_DETAILS.FUNDING_CURRENCY_CODE
PA_RETN_INVOICE_DETAILS	FND_CURRENCIES	PA_RETN_INVOICE_DETAILS.INVPROC_CURRENCY_CODE