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_CUST_EVENT_RDL_ALL

Product:	PA - Projects
Description:	Information about event revenue distribution
Implementation/DBA Data:	PA.PA_CUST_EVENT_RDL_ALL

Primary Key: PA_CUST_EVENT_REV_DIST_LINE_PK

PROJECT_ID
EVENT_NUM
TASK_ID
LINE_NUM

Foreign Keys

Table	Foreign Table	Foreign Key Column
PA_CUST_EVENT_RDL_ALL	AR_VAT_TAX_ALL_B	PA_CUST_EVENT_RDL_ALL.OUTPUT_VAT_TAX_ID
PA_CUST_EVENT_RDL_ALL	FND_CURRENCIES	PA_CUST_EVENT_RDL_ALL.BILL_TRANS_CURRENCY_CODE
PA_CUST_EVENT_RDL_ALL	FND_CURRENCIES	PA_CUST_EVENT_RDL_ALL.REVPROC_CURRENCY_CODE
PA_CUST_EVENT_RDL_ALL	GL_DAILY_CONVERSION_TYPES	PA_CUST_EVENT_RDL_ALL.REVPROC_RATE_TYPE
PA_CUST_EVENT_RDL_ALL	FND_CURRENCIES	PA_CUST_EVENT_RDL_ALL.INVPROC_CURRENCY_CODE
PA_CUST_EVENT_RDL_ALL	GL_DAILY_CONVERSION_TYPES	PA_CUST_EVENT_RDL_ALL.INVPROC_RATE_TYPE
PA_CUST_EVENT_RDL_ALL	FND_CURRENCIES	PA_CUST_EVENT_RDL_ALL.PROJECT_CURRENCY_CODE
PA_CUST_EVENT_RDL_ALL	GL_DAILY_CONVERSION_TYPES	PA_CUST_EVENT_RDL_ALL.PROJECT_REV_RATE_TYPE
PA_CUST_EVENT_RDL_ALL	GL_DAILY_CONVERSION_TYPES	PA_CUST_EVENT_RDL_ALL.PROJECT_INV_RATE_TYPE
PA_CUST_EVENT_RDL_ALL	FND_CURRENCIES	PA_CUST_EVENT_RDL_ALL.PROJFUNC_CURRENCY_CODE
PA_CUST_EVENT_RDL_ALL	GL_DAILY_CONVERSION_TYPES	PA_CUST_EVENT_RDL_ALL.PROJFUNC_REV_RATE_TYPE
PA_CUST_EVENT_RDL_ALL	GL_DAILY_CONVERSION_TYPES	PA_CUST_EVENT_RDL_ALL.PROJFUNC_INV_RATE_TYPE
PA_CUST_EVENT_RDL_ALL	GL_DAILY_CONVERSION_TYPES	PA_CUST_EVENT_RDL_ALL.PROJECT_REV_RATE_TYPE
PA_CUST_EVENT_RDL_ALL	FND_CURRENCIES	PA_CUST_EVENT_RDL_ALL.PROJECT_CURRENCY_CODE
PA_CUST_EVENT_RDL_ALL	GL_DAILY_CONVERSION_TYPES	PA_CUST_EVENT_RDL_ALL.PROJECT_INV_RATE_TYPE
PA_CUST_EVENT_RDL_ALL	FND_CURRENCIES	PA_CUST_EVENT_RDL_ALL.PROJFUNC_CURRENCY_CODE
PA_CUST_EVENT_RDL_ALL	GL_DAILY_CONVERSION_TYPES	PA_CUST_EVENT_RDL_ALL.PROJFUNC_REV_RATE_TYPE
PA_CUST_EVENT_RDL_ALL	GL_DAILY_CONVERSION_TYPES	PA_CUST_EVENT_RDL_ALL.PROJFUNC_INV_RATE_TYPE
PA_CUST_EVENT_RDL_ALL	FND_CURRENCIES	PA_CUST_EVENT_RDL_ALL.FUNDING_CURRENCY_CODE
PA_CUST_EVENT_RDL_ALL	GL_DAILY_CONVERSION_TYPES	PA_CUST_EVENT_RDL_ALL.FUNDING_REV_RATE_TYPE
PA_CUST_EVENT_RDL_ALL	GL_DAILY_CONVERSION_TYPES	PA_CUST_EVENT_RDL_ALL.FUNDING_INV_RATE_TYPE
PA_CUST_EVENT_RDL_ALL	PA_DRAFT_INVOICE_ITEMS	PA_CUST_EVENT_RDL_ALL.PROJECT_ID PA_CUST_EVENT_RDL_ALL.RETN_DRAFT_INVOICE_NUM PA_CUST_EVENT_RDL_ALL.RETN_DRAFT_INVOICE_LINE_NUM
PA_CUST_EVENT_RDL_ALL	PA_DRAFT_REVENUE_ITEMS	PA_CUST_EVENT_RDL_ALL.PROJECT_ID PA_CUST_EVENT_RDL_ALL.DRAFT_REVENUE_NUM PA_CUST_EVENT_RDL_ALL.DRAFT_REVENUE_ITEM_LINE_NUM
PA_CUST_EVENT_RDL_ALL	PA_DRAFT_INVOICE_ITEMS	PA_CUST_EVENT_RDL_ALL.PROJECT_ID PA_CUST_EVENT_RDL_ALL.DRAFT_INVOICE_NUM PA_CUST_EVENT_RDL_ALL.DRAFT_INVOICE_ITEM_LINE_NUM
PA_CUST_EVENT_RDL_ALL	PA_CUST_EVENT_RDL_ALL	PA_CUST_EVENT_RDL_ALL.PROJECT_ID PA_CUST_EVENT_RDL_ALL.EVENT_NUM PA_CUST_EVENT_RDL_ALL.TASK_ID PA_CUST_EVENT_RDL_ALL.LINE_NUM_REVERSED
PA_CUST_EVENT_RDL_ALL	GL_CODE_COMBINATIONS	PA_CUST_EVENT_RDL_ALL.CODE_COMBINATION_ID
PA_CUST_EVENT_RDL_ALL	PA_CUST_EVENT_RDL_ALL	PA_CUST_EVENT_RDL_ALL.PROJECT_ID PA_CUST_EVENT_RDL_ALL.EVENT_NUM PA_CUST_EVENT_RDL_ALL.TASK_ID PA_CUST_EVENT_RDL_ALL.LINE_NUM_REVERSED
PA_MC_CUST_EVENT_RDL_ALL	PA_CUST_EVENT_RDL_ALL	PA_MC_CUST_EVENT_RDL_ALL.PROJECT_ID PA_MC_CUST_EVENT_RDL_ALL.EVENT_NUM PA_MC_CUST_EVENT_RDL_ALL.TASK_ID PA_MC_CUST_EVENT_RDL_ALL.LINE_NUM
PA_TXN_ACCUM_DETAILS	PA_CUST_EVENT_RDL_ALL	PA_TXN_ACCUM_DETAILS.PROJECT_ID PA_TXN_ACCUM_DETAILS.EVENT_NUM PA_TXN_ACCUM_DETAILS.TASK_ID PA_TXN_ACCUM_DETAILS.LINE_NUM