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_REV_DIST_LINES_ALL

Product:	PA - Projects
Description:	Information about expenditure item revenue distribution
Implementation/DBA Data:	PA.PA_CUST_REV_DIST_LINES_ALL

Primary Key: PA_CUST_REV_DIST_LINES_PK

EXPENDITURE_ITEM_ID
LINE_NUM

Foreign Keys

Table	Foreign Table	Foreign Key Column
PA_CUST_REV_DIST_LINES_ALL	PA_EXPENDITURE_ITEMS_ALL	PA_CUST_REV_DIST_LINES_ALL.EXPENDITURE_ITEM_ID
PA_CUST_REV_DIST_LINES_ALL	AR_VAT_TAX_ALL_B	PA_CUST_REV_DIST_LINES_ALL.OUTPUT_VAT_TAX_ID
PA_CUST_REV_DIST_LINES_ALL	FND_CURRENCIES	PA_CUST_REV_DIST_LINES_ALL.BILL_TRANS_CURRENCY_CODE
PA_CUST_REV_DIST_LINES_ALL	FND_CURRENCIES	PA_CUST_REV_DIST_LINES_ALL.REVPROC_CURRENCY_CODE
PA_CUST_REV_DIST_LINES_ALL	GL_DAILY_CONVERSION_TYPES	PA_CUST_REV_DIST_LINES_ALL.REVPROC_RATE_TYPE
PA_CUST_REV_DIST_LINES_ALL	FND_CURRENCIES	PA_CUST_REV_DIST_LINES_ALL.INVPROC_CURRENCY_CODE
PA_CUST_REV_DIST_LINES_ALL	GL_DAILY_CONVERSION_TYPES	PA_CUST_REV_DIST_LINES_ALL.INVPROC_RATE_TYPE
PA_CUST_REV_DIST_LINES_ALL	FND_CURRENCIES	PA_CUST_REV_DIST_LINES_ALL.PROJECT_CURRENCY_CODE
PA_CUST_REV_DIST_LINES_ALL	PA_FUNCTION_TRANSACTIONS_ALL	PA_CUST_REV_DIST_LINES_ALL.FUNCTION_CODE PA_CUST_REV_DIST_LINES_ALL.FUNCTION_TRANSACTION_CODE PA_CUST_REV_DIST_LINES_ALL.PROGRAM_APPLICATION_ID PA_CUST_REV_DIST_LINES_ALL.ORG_ID
PA_CUST_REV_DIST_LINES_ALL	GL_DAILY_CONVERSION_TYPES	PA_CUST_REV_DIST_LINES_ALL.PROJECT_REV_RATE_TYPE
PA_CUST_REV_DIST_LINES_ALL	GL_DAILY_CONVERSION_TYPES	PA_CUST_REV_DIST_LINES_ALL.PROJECT_INV_RATE_TYPE
PA_CUST_REV_DIST_LINES_ALL	FND_CURRENCIES	PA_CUST_REV_DIST_LINES_ALL.PROJFUNC_CURRENCY_CODE
PA_CUST_REV_DIST_LINES_ALL	GL_DAILY_CONVERSION_TYPES	PA_CUST_REV_DIST_LINES_ALL.PROJFUNC_REV_RATE_TYPE
PA_CUST_REV_DIST_LINES_ALL	GL_DAILY_CONVERSION_TYPES	PA_CUST_REV_DIST_LINES_ALL.PROJFUNC_INV_RATE_TYPE
PA_CUST_REV_DIST_LINES_ALL	FND_CURRENCIES	PA_CUST_REV_DIST_LINES_ALL.FUNDING_CURRENCY_CODE
PA_CUST_REV_DIST_LINES_ALL	GL_DAILY_CONVERSION_TYPES	PA_CUST_REV_DIST_LINES_ALL.FUNDING_REV_RATE_TYPE
PA_CUST_REV_DIST_LINES_ALL	GL_DAILY_CONVERSION_TYPES	PA_CUST_REV_DIST_LINES_ALL.FUNDING_INV_RATE_TYPE
PA_CUST_REV_DIST_LINES_ALL	PA_DRAFT_INVOICE_ITEMS	PA_CUST_REV_DIST_LINES_ALL.PROJECT_ID PA_CUST_REV_DIST_LINES_ALL.RETN_DRAFT_INVOICE_NUM PA_CUST_REV_DIST_LINES_ALL.RETN_DRAFT_INVOICE_LINE_NUM
PA_CUST_REV_DIST_LINES_ALL	PA_DRAFT_REVENUE_ITEMS	PA_CUST_REV_DIST_LINES_ALL.PROJECT_ID PA_CUST_REV_DIST_LINES_ALL.DRAFT_REVENUE_NUM PA_CUST_REV_DIST_LINES_ALL.DRAFT_REVENUE_ITEM_LINE_NUM
PA_CUST_REV_DIST_LINES_ALL	PA_DRAFT_INVOICE_ITEMS	PA_CUST_REV_DIST_LINES_ALL.PROJECT_ID PA_CUST_REV_DIST_LINES_ALL.DRAFT_INVOICE_NUM PA_CUST_REV_DIST_LINES_ALL.DRAFT_INVOICE_ITEM_LINE_NUM
PA_CUST_REV_DIST_LINES_ALL	PA_CUST_REV_DIST_LINES_ALL	PA_CUST_REV_DIST_LINES_ALL.EXPENDITURE_ITEM_ID PA_CUST_REV_DIST_LINES_ALL.LINE_NUM_REVERSED
PA_CUST_REV_DIST_LINES_ALL	GL_CODE_COMBINATIONS	PA_CUST_REV_DIST_LINES_ALL.CODE_COMBINATION_ID
PA_CUST_REV_DIST_LINES_ALL	PA_CUST_REV_DIST_LINES_ALL	PA_CUST_REV_DIST_LINES_ALL.EXPENDITURE_ITEM_ID PA_CUST_REV_DIST_LINES_ALL.LINE_NUM_REVERSED
PA_MC_CUST_RDL_ALL	PA_CUST_REV_DIST_LINES_ALL	PA_MC_CUST_RDL_ALL.EXPENDITURE_ITEM_ID PA_MC_CUST_RDL_ALL.LINE_NUM
PA_TXN_ACCUM_DETAILS	PA_CUST_REV_DIST_LINES_ALL	PA_TXN_ACCUM_DETAILS.EXPENDITURE_ITEM_ID PA_TXN_ACCUM_DETAILS.LINE_NUM