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_COST_DISTRIBUTION_LINES_ALL

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

Primary Key: PA_COST_DISTRIBUTION_LINES_PK

LINE_NUM
EXPENDITURE_ITEM_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
PA_COST_DISTRIBUTION_LINES_ALL	AP_INVOICE_DISTRIBUTIONS_ALL	PA_COST_DISTRIBUTION_LINES_ALL.SYSTEM_REFERENCE2 PA_COST_DISTRIBUTION_LINES_ALL.SYSTEM_REFERENCE3
PA_COST_DISTRIBUTION_LINES_ALL	PA_EXPENDITURE_ITEMS_ALL	PA_COST_DISTRIBUTION_LINES_ALL.EXPENDITURE_ITEM_ID
PA_COST_DISTRIBUTION_LINES_ALL	PA_COST_DISTRIBUTION_LINES_ALL	PA_COST_DISTRIBUTION_LINES_ALL.LINE_NUM_REVERSED PA_COST_DISTRIBUTION_LINES_ALL.EXPENDITURE_ITEM_ID
PA_COST_DISTRIBUTION_LINES_ALL	PA_EXPENDITURE_BATCHES_ALL	PA_COST_DISTRIBUTION_LINES_ALL.BATCH_NAME PA_COST_DISTRIBUTION_LINES_ALL.ORG_ID
PA_COST_DISTRIBUTION_LINES_ALL	GL_CODE_COMBINATIONS	PA_COST_DISTRIBUTION_LINES_ALL.DR_CODE_COMBINATION_ID
PA_COST_DISTRIBUTION_LINES_ALL	GL_CODE_COMBINATIONS	PA_COST_DISTRIBUTION_LINES_ALL.CR_CODE_COMBINATION_ID
PA_COST_DISTRIBUTION_LINES_ALL	PA_PROJECTS_ALL	PA_COST_DISTRIBUTION_LINES_ALL.PROJECT_ID
PA_COST_DISTRIBUTION_LINES_ALL	PO_VENDORS	PA_COST_DISTRIBUTION_LINES_ALL.SYSTEM_REFERENCE2
PA_COST_DISTRIBUTION_LINES_ALL	PA_TASKS	PA_COST_DISTRIBUTION_LINES_ALL.TASK_ID
PA_COST_DISTRIBUTION_LINES_ALL	GL_DAILY_CONVERSION_TYPES	PA_COST_DISTRIBUTION_LINES_ALL.ACCT_RATE_TYPE
PA_COST_DISTRIBUTION_LINES_ALL	GL_DAILY_CONVERSION_TYPES	PA_COST_DISTRIBUTION_LINES_ALL.PROJECT_RATE_TYPE
PA_COST_DISTRIBUTION_LINES_ALL	FND_CURRENCIES	PA_COST_DISTRIBUTION_LINES_ALL.ACCT_CURRENCY_CODE
PA_COST_DISTRIBUTION_LINES_ALL	FND_CURRENCIES	PA_COST_DISTRIBUTION_LINES_ALL.PROJECT_CURRENCY_CODE
PA_COST_DISTRIBUTION_LINES_ALL	GL_ENCUMBRANCE_TYPES	PA_COST_DISTRIBUTION_LINES_ALL.ENCUMBRANCE_TYPE_ID
PA_COST_DISTRIBUTION_LINES_ALL	PA_WORK_TYPES_B	PA_COST_DISTRIBUTION_LINES_ALL.WORK_TYPE_ID
PA_COST_DISTRIBUTION_LINES_ALL	GL_DAILY_CONVERSION_TYPES	PA_COST_DISTRIBUTION_LINES_ALL.PROJFUNC_COST_RATE_TYPE
PA_COST_DISTRIBUTION_LINES_ALL	FND_CURRENCIES	PA_COST_DISTRIBUTION_LINES_ALL.PROJFUNC_CURRENCY_CODE
PA_COST_DISTRIBUTION_LINES_ALL	AP_INVOICE_PAYMENTS_ALL	PA_COST_DISTRIBUTION_LINES_ALL.SYSTEM_REFERENCE4
PA_COST_DISTRIBUTION_LINES_ALL	PA_ORG_LABOR_SCH_RULE	PA_COST_DISTRIBUTION_LINES_ALL.ORG_LABOR_SCH_RULE_ID
PA_COST_DISTRIBUTION_LINES_ALL	PA_COST_DISTRIBUTION_LINES_ALL	PA_COST_DISTRIBUTION_LINES_ALL.LINE_NUM_REVERSED PA_COST_DISTRIBUTION_LINES_ALL.EXPENDITURE_ITEM_ID
PA_MC_COST_DIST_LINES_ALL	PA_COST_DISTRIBUTION_LINES_ALL	PA_MC_COST_DIST_LINES_ALL.LINE_NUM PA_MC_COST_DIST_LINES_ALL.EXPENDITURE_ITEM_ID
PA_PROJECT_ASSET_LINE_DETAILS	PA_COST_DISTRIBUTION_LINES_ALL	PA_PROJECT_ASSET_LINE_DETAILS.LINE_NUM PA_PROJECT_ASSET_LINE_DETAILS.EXPENDITURE_ITEM_ID
PA_TXN_ACCUM_DETAILS	PA_COST_DISTRIBUTION_LINES_ALL	PA_TXN_ACCUM_DETAILS.LINE_NUM PA_TXN_ACCUM_DETAILS.EXPENDITURE_ITEM_ID
PA_BC_COMMITMENTS_ALL	PA_COST_DISTRIBUTION_LINES_ALL	PA_BC_COMMITMENTS_ALL.PCL_LINE_NUM PA_BC_COMMITMENTS_ALL.PCL_EXPENDITURE_ITEM_ID