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.

DBA Data [Home] [Help] [Dependency Information]

TABLE: PA.PA_FORECAST_ITEMS

Object Details

Object Name:	PA_FORECAST_ITEMS
Object Type:	TABLE
Owner:	PA
FND Design Data:	PA.PA_FORECAST_ITEMS
Subobject Name:
Status:	VALID

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.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PA_FORECAST_ITEMS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	FORECAST_ITEM_ID
PA_FORECAST_ITEMS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ASSIGNMENT_ID DELETE_FLAG ERROR_FLAG ITEM_DATE ASGMT_SYS_STATUS_CODE
PA_FORECAST_ITEMS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	EXPENDITURE_ORGANIZATION_ID FORECAST_ITEM_TYPE DELETE_FLAG ERROR_FLAG ITEM_DATE AVAILABILITY_FLAG OVERCOMMITMENT_FLAG CAPACITY_QUANTITY
PA_FORECAST_ITEMS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	RESOURCE_ID FORECAST_ITEM_TYPE DELETE_FLAG ITEM_DATE AVAILABILITY_FLAG OVERCOMMITMENT_FLAG CAPACITY_QUANTITY
PA_FORECAST_ITEMS_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ITEM_DATE EXPENDITURE_ORG_ID
PA_FORECAST_ITEMS_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	RESOURCE_ID FORECAST_ITEM_TYPE DELETE_FLAG GLOBAL_EXP_PERIOD_END_DATE
PA_FORECAST_ITEMS_N6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	FORECAST_AMT_CALC_FLAG
PA_FORECAST_ITEMS_N7	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PROJECT_ID
PA_FORECAST_ITEMS_N8	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PROJECT_ORGANIZATION_ID FORECAST_ITEM_TYPE DELETE_FLAG ERROR_FLAG ITEM_DATE
PA_FORECAST_ITEMS_N9	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	REQUEST_ID

Columns

Name	Datatype	Length	Mandatory	Comments
FORECAST_ITEM_ID	NUMBER		Yes	The system -generated number that uniquely identifies the forecast item.
FORECAST_ITEM_TYPE	VARCHAR2	(30)	Yes	Indicates the type of the forecast item. Valid values are: A for Assignment R for Requirement U for Unassigned Time.
PROJECT_ORG_ID	NUMBER		Yes	Identifier of the project operating unit.
EXPENDITURE_ORG_ID	NUMBER		Yes	Identifier of the expenditure operating unit. The value of this column is, derived from the assignment for open assignments and from the resource for staffed assignments.
EXPENDITURE_ORGANIZATION_ID	NUMBER			Identifier of the expenditure organization. The value for this column is, derived from the assignment for open assignments and from the resource for staffed assignments.
PROJECT_ORGANIZATION_ID	NUMBER			Identifier of the project organization.
PROJECT_ID	NUMBER		Yes	Identifier of the project
PROJECT_TYPE_CLASS	VARCHAR2	(30)	Yes	The project type classification of the project assignment
PERSON_ID	NUMBER			Identifier of the Person (for Staffed and Unassigned Time only)
RESOURCE_ID	NUMBER			Resource ID
BORROWED_FLAG	VARCHAR2	(1)	Yes	Indicates if a borrowed resource is used for this assignment
ASSIGNMENT_ID	NUMBER			The identifier of the assignment (for Forecast Item Type = U , this column is null)
ITEM_DATE	DATE		Yes	The date of the forecast item
ITEM_UOM	VARCHAR2	(30)	Yes	The Unit of Measure for the item
ITEM_QUANTITY	NUMBER		Yes	The quantity for the item
PVDR_PERIOD_SET_NAME	VARCHAR2	(30)		The accounting calendar name corresponding to the provider ledger.
PVDR_PA_PERIOD_NAME	VARCHAR2	(30)		The item corresponding to the PA Period Name as per the calendar in the provider ledger.
PVDR_GL_PERIOD_NAME	VARCHAR2	(30)		The item corresponding to the PA Period Name as per the calendar in the provider ledger.
RCVR_PERIOD_SET_NAME	VARCHAR2	(30)		The period set corresponding to the receiver ledger.
RCVR_PA_PERIOD_NAME	VARCHAR2	(30)		The item corresponding to the PA Period Name as per the calendar in the provider ledger.
RCVR_GL_PERIOD_NAME	VARCHAR2	(30)		The item corresponding to the GL Period Name as per the calendar in the provider ledger.
GLOBAL_EXP_PERIOD_END_DATE	DATE			The week end date to which this item corresponds based global expenditure week defined at the site level
EXPENDITURE_TYPE	VARCHAR2	(30)	Yes	The expenditure type defined for the assignment
EXPENDITURE_TYPE_CLASS	VARCHAR2	(30)	Yes	The expenditure type class defined for the assignment
COST_REJECTION_CODE	VARCHAR2	(30)		The rejection code of error during the cost amount calculation
REV_REJECTION_CODE	VARCHAR2	(30)		The rejection code of error during the revenue amount calculation
TP_REJECTION_CODE	VARCHAR2	(30)		The rejection code of error during the transfer price amount calculation
BURDEN_REJECTION_CODE	VARCHAR2	(30)		The rejection code of error during the burden amount calculation.
OTHER_REJECTION_CODE	VARCHAR2	(30)		The rejection code of error for other than amount calculation
DELETE_FLAG	VARCHAR2	(1)	Yes	If the item is reversed , this flag indicates that it can be deleted once the amount details have been processed for summarization
ERROR_FLAG	VARCHAR2	(1)	Yes	Indicates the forecast item generation error
PROVISIONAL_FLAG	VARCHAR2	(1)	Yes	Indicates whether the assignment is Provisional
CREATION_DATE	DATE		Yes	Standard Who column
CREATED_BY	NUMBER		Yes	Standard who column
LAST_UPDATE_DATE	DATE		Yes	Standard who column
LAST_UPDATED_BY	NUMBER		Yes	Standard who column
LAST_UPDATE_LOGIN	NUMBER			Standard who column
REQUEST_ID	NUMBER			Concurrent program Who column
PROGRAM_APPLICATION_ID	NUMBER			Concurrent program Who column
PROGRAM_ID	NUMBER			Concurrent program Who column
PROGRAM_UPDATE_DATE	DATE			Concurrent program Who column
ASGMT_SYS_STATUS_CODE	VARCHAR2	(30)		The system status of the assignment on the date of the item (item_date). This column is NULL for records with a forecast item type of 'U'.
CAPACITY_QUANTITY	NUMBER			This column is NULL for records with a forecast item type of 'A' or 'R'.
OVERCOMMITMENT_QUANTITY	NUMBER			This quantity does not include provisional assignment hours. This column is NULL for records with a forecast item type of 'A' or 'R'.
AVAILABILITY_QUANTITY	NUMBER			The total number of hours the resource is available on the date of the item (item_date). This quantity is derived by subtracting the total number of confirmed hours from the capacity, and therefore, may include provisional hours. This column is NULL for records with a forecast item type of 'A' or 'R'.
OVERCOMMITMENT_FLAG	VARCHAR2	(1)		A value of 'Y' in this column indicates if the resource is overcommitted on the date of the item (item_date). This column is NULL for all other records, and for records with a forecast item type of 'A' or 'R'. This column ignores provisional assignments.
AVAILABILITY_FLAG	VARCHAR2	(1)		A value of 'Y' in this column indicates if the resource is available on the date of the item (item_date). This column is NULL for all other records, and for records with a forecast item type of 'A' or 'R'. This column ignores provisional assignments.
TP_AMOUNT_TYPE	VARCHAR2	(30)		Stores the transfer price amount type
FORECAST_AMT_CALC_FLAG	VARCHAR2	(1)		Indicates whether amount calculation has been done for the forecast item.
COST_TXN_CURRENCY_CODE	VARCHAR2	(15)		The cost transaction currency code of the transaction
TXN_RAW_COST	NUMBER			The raw cost in transaction currency of the forecast item
TXN_BURDENED_COST	NUMBER			The burdened cost in transaction currency of the forecast item
REVENUE_TXN_CURRENCY_CODE	VARCHAR2	(15)		The revenue currency code of the transaction
TXN_REVENUE	NUMBER			The revenue in transaction currency of the forecast item
TP_TXN_CURRENCY_CODE	VARCHAR2	(15)		Stores the transfer price currency code for the transaction
TXN_TRANSFER_PRICE	NUMBER			The transfer price in transaction currency of the forecast item
PROJECT_CURRENCY_CODE	VARCHAR2	(15)		The project currency code of the forecast item
PROJECT_RAW_COST	NUMBER			The raw cost in project currency of the forecast item
PROJECT_BURDENED_COST	NUMBER			The burdened cost in project currency of the forecast item
PROJECT_REVENUE	NUMBER			The revenue in project currency of the forecast item
PROJECT_TRANSFER_PRICE	NUMBER			The transfer price in project currency of the forecast item
PROJFUNC_CURRENCY_CODE	VARCHAR2	(15)		The project functional currency code of the forecast item
PROJFUNC_RAW_COST	NUMBER			The raw cost in project functional currency of the forecast item
PROJFUNC_BURDENED_COST	NUMBER			The burdened cost in project functional currency of the forecast item
PROJFUNC_REVENUE	NUMBER			The revenue in project functional currency of the forecast item
PROJFUNC_TRANSFER_PRICE	NUMBER			The transfer price in project functional currency of the forecast item
EXPFUNC_CURRENCY_CODE	VARCHAR2	(15)		The expenditure functional currency code of the forecast item
EXPFUNC_RAW_COST	NUMBER			The raw cost in expenditure functional currency of the forecast item
EXPFUNC_BURDENED_COST	NUMBER			The burdened cost in expenditure functional currency of the forecast item
EXPFUNC_TRANSFER_PRICE	NUMBER			The transfer price in expenditure functional currency of the forecast item
OVERPROVISIONAL_QTY	NUMBER			The total number of hours the resource is overcommitted using only provisional assignment hours on the date of the item (item_date). This quantity does not include confirmed assignment hours. This column is NULL for records with a forecast item type of 'A' or 'R' and for records with a forecast item type of 'U' if the amount is zero
OVER_PROV_CONF_QTY	NUMBER			The total number of hours the resource is overcommitted using provisional and confirmed assignment hours on the date of the item (item_date). This column is NULL for records with a forecast item type of 'A' or 'R' and for records with a forecast item type of 'U' if the amount is zero
CONFIRMED_QTY	NUMBER			The total number of hours the resource is confirmed on the date of the item (item_date). This column is NULL for records with a forecast item type of 'A' or 'R' and for records with a forecast item type of 'U' if the amount is zero
PROVISIONAL_QTY	NUMBER			The total number of hours the resource is provisionally assigned on the date of the item (item_date). This column is NULL for records with a forecast item type of 'A' or 'R' and for records with a forecast item type of 'U' if the amount is zero
JOB_ID	NUMBER			Identifier of the job

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT FORECAST_ITEM_ID
,      FORECAST_ITEM_TYPE
,      PROJECT_ORG_ID
,      EXPENDITURE_ORG_ID
,      EXPENDITURE_ORGANIZATION_ID
,      PROJECT_ORGANIZATION_ID
,      PROJECT_ID
,      PROJECT_TYPE_CLASS
,      PERSON_ID
,      RESOURCE_ID
,      BORROWED_FLAG
,      ASSIGNMENT_ID
,      ITEM_DATE
,      ITEM_UOM
,      ITEM_QUANTITY
,      PVDR_PERIOD_SET_NAME
,      PVDR_PA_PERIOD_NAME
,      PVDR_GL_PERIOD_NAME
,      RCVR_PERIOD_SET_NAME
,      RCVR_PA_PERIOD_NAME
,      RCVR_GL_PERIOD_NAME
,      GLOBAL_EXP_PERIOD_END_DATE
,      EXPENDITURE_TYPE
,      EXPENDITURE_TYPE_CLASS
,      COST_REJECTION_CODE
,      REV_REJECTION_CODE
,      TP_REJECTION_CODE
,      BURDEN_REJECTION_CODE
,      OTHER_REJECTION_CODE
,      DELETE_FLAG
,      ERROR_FLAG
,      PROVISIONAL_FLAG
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      ASGMT_SYS_STATUS_CODE
,      CAPACITY_QUANTITY
,      OVERCOMMITMENT_QUANTITY
,      AVAILABILITY_QUANTITY
,      OVERCOMMITMENT_FLAG
,      AVAILABILITY_FLAG
,      TP_AMOUNT_TYPE
,      FORECAST_AMT_CALC_FLAG
,      COST_TXN_CURRENCY_CODE
,      TXN_RAW_COST
,      TXN_BURDENED_COST
,      REVENUE_TXN_CURRENCY_CODE
,      TXN_REVENUE
,      TP_TXN_CURRENCY_CODE
,      TXN_TRANSFER_PRICE
,      PROJECT_CURRENCY_CODE
,      PROJECT_RAW_COST
,      PROJECT_BURDENED_COST
,      PROJECT_REVENUE
,      PROJECT_TRANSFER_PRICE
,      PROJFUNC_CURRENCY_CODE
,      PROJFUNC_RAW_COST
,      PROJFUNC_BURDENED_COST
,      PROJFUNC_REVENUE
,      PROJFUNC_TRANSFER_PRICE
,      EXPFUNC_CURRENCY_CODE
,      EXPFUNC_RAW_COST
,      EXPFUNC_BURDENED_COST
,      EXPFUNC_TRANSFER_PRICE
,      OVERPROVISIONAL_QTY
,      OVER_PROV_CONF_QTY
,      CONFIRMED_QTY
,      PROVISIONAL_QTY
,      JOB_ID
FROM PA.PA_FORECAST_ITEMS;

Dependencies

[top of page]

PA.PA_FORECAST_ITEMS does not reference any database object

PA.PA_FORECAST_ITEMS is referenced by following:

PA: PA_FORECAST_ITEMS#