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_FORECAST_ITEMS

Product:	PA - Projects
Description:	This table stores the detail information by day for each requirement and assignment in Oracle Project Resource Management. It also stores similar information for each unassigned day for all resources that can be scheduled
Implementation/DBA Data:	PA.PA_FORECAST_ITEMS

Primary Key: PA_FORECAST_ITEMS_PK

FORECAST_ITEM_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
PA_FORECAST_ITEMS	PA_PROJECT_ASSIGNMENTS	PA_FORECAST_ITEMS.ASSIGNMENT_ID
PA_FORECAST_ITEMS	PER_JOBS	PA_FORECAST_ITEMS.JOB_ID
PA_FORECAST_ITEMS	HR_ALL_ORGANIZATION_UNITS	PA_FORECAST_ITEMS.EXPENDITURE_ORGANIZATION_ID
PA_FORECAST_ITEMS	HR_ALL_ORGANIZATION_UNITS	PA_FORECAST_ITEMS.PROJECT_ORGANIZATION_ID
PA_FI_AMOUNT_DETAILS	PA_FORECAST_ITEMS	PA_FI_AMOUNT_DETAILS.FORECAST_ITEM_ID