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_ITEM_DETAILS

Object Details

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

This table stores the detailed amount information for each forecast item. An example of the amounts stored is labor hours.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PA_FORECAST_ITEM_DETAILS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	FORECAST_ITEM_ID ITEM_DATE LINE_NUM
PA_FORECAST_ITEM_DETAILS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	EXPENDITURE_ORGANIZATION_ID PJI_SUMMARIZED_FLAG

Columns

Name	Datatype	Length	Mandatory	Comments
FORECAST_ITEM_ID	NUMBER		Yes	The identifier of the forecast item.
AMOUNT_TYPE_ID	NUMBER		Yes	Identifier of the amount type , such as Cost , Revenue , and Quantity .
LINE_NUM	NUMBER		Yes	A unique system -generated record number for an amount type and a forecast item.
RESOURCE_TYPE_CODE	VARCHAR2	(30)	Yes	The new value for the type of resource E - Employee , C - Contractor
PERSON_BILLABLE_FLAG	VARCHAR2	(1)	Yes	New value of billability for a resource B- Billable, N - Non-- Billable
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
EXPENDITURE_ORG_ID	NUMBER			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.
PROJECT_ORG_ID	NUMBER			Identifier of the project operating unit.
PVDR_ACCT_CURR_CODE	VARCHAR2	(15)		The expenditure functional currency code.
PVDR_ACCT_AMOUNT	NUMBER			The amount in expenditure functional currency
RCVR_ACCT_CURR_CODE	VARCHAR2	(15)		The project functional currency code
RCVR_ACCT_AMOUNT	NUMBER			The amount in project functional currency
PROJ_CURRENCY_CODE	VARCHAR2	(15)		The project currency code
PROJ_AMOUNT	NUMBER			The amount in project currency
DENOM_CURRENCY_CODE	VARCHAR2	(15)		The Transaction currency code
DENOM_AMOUNT	NUMBER			The amount in Transaction currency
TP_AMOUNT_TYPE	VARCHAR2	(30)		The transfer price amount type, only valid for the transfer price amount type
BILLABLE_FLAG	VARCHAR2	(1)	Yes	The flag which indicates whether the associated work type is billable
FORECAST_SUMMARIZED_CODE	VARCHAR2	(30)	Yes	Indicates the forecast summarization status,. Valid values are: N - Not Summarized, Y - Summarized, E - Error, X - Summarization Not Required
UTIL_SUMMARIZED_CODE	VARCHAR2	(30)		Indicates the utilization summarization status,. Valid values are: N - Not Summarized, Y - Summarized, E - Error ,X - Summarization Not Required
WORK_TYPE_ID	NUMBER		Yes	Identifier of the work type of the assignment.
RESOURCE_UTIL_CATEGORY_ID	NUMBER			Identifier of utilization category derived from the work type from the resource perspective
ORG_UTIL_CATEGORY_ID	NUMBER			Identifier of utilization category derived from the work type from the organization perspective
RESOURCE_UTIL_WEIGHTED	NUMBER			Resource utilization weighted
ORG_UTIL_WEIGHTED	NUMBER			Organization utilization weighted
PROVISIONAL_FLAG	VARCHAR2	(1)	Yes	Indicates whether the assignment is Provisional
REVERSED_FLAG	VARCHAR2	(1)	Yes	Indicates whether the current line is reversed by another line
NET_ZERO_FLAG	VARCHAR2	(1)	Yes	Indicates whether the current and reversing line net out each other and, therefore, both can be deleted after summarization
REDUCE_CAPACITY_FLAG	VARCHAR2	(1)	Yes	Indicates reduce capacity flag for Resource
LINE_NUM_REVERSED	NUMBER			The line number that is reversed by this line
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
CAPACITY_QUANTITY	NUMBER			The change in capacity hours for the resource 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 there is no quantity change
OVERCOMMITMENT_QTY	NUMBER			The change in the number of hours that the resource is overcommitted using only confirmed assignment hours on the date of the item (item_date). This quantity does not include provisional 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 there is no quantity change
OVERPROVISIONAL_QTY	NUMBER			The change in the number of hours that 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 there is no quantity change
OVER_PROV_CONF_QTY	NUMBER			The change in the number of hours that 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 there is no quantity change
CONFIRMED_QTY	NUMBER			The change in the number of hours that 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 there is no quantity change
PROVISIONAL_QTY	NUMBER			The change in the number of hours that 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 there is no quantity change
JOB_ID	NUMBER			Identifier of the job
PROJECT_ID	NUMBER			Identifier of the project
RESOURCE_ID	NUMBER			Identifier of the resource
EXPENDITURE_ORGANIZATION_ID	NUMBER			Identifier of the expenditure organization
PJI_SUMMARIZED_FLAG	VARCHAR2	(1)		Indicates the PJI summarization status,. Valid values are: N - Not Summarized, null - Summarized, X - Summarization Not Required

Query Text

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


SELECT FORECAST_ITEM_ID
,      AMOUNT_TYPE_ID
,      LINE_NUM
,      RESOURCE_TYPE_CODE
,      PERSON_BILLABLE_FLAG
,      ITEM_DATE
,      ITEM_UOM
,      ITEM_QUANTITY
,      EXPENDITURE_ORG_ID
,      PROJECT_ORG_ID
,      PVDR_ACCT_CURR_CODE
,      PVDR_ACCT_AMOUNT
,      RCVR_ACCT_CURR_CODE
,      RCVR_ACCT_AMOUNT
,      PROJ_CURRENCY_CODE
,      PROJ_AMOUNT
,      DENOM_CURRENCY_CODE
,      DENOM_AMOUNT
,      TP_AMOUNT_TYPE
,      BILLABLE_FLAG
,      FORECAST_SUMMARIZED_CODE
,      UTIL_SUMMARIZED_CODE
,      WORK_TYPE_ID
,      RESOURCE_UTIL_CATEGORY_ID
,      ORG_UTIL_CATEGORY_ID
,      RESOURCE_UTIL_WEIGHTED
,      ORG_UTIL_WEIGHTED
,      PROVISIONAL_FLAG
,      REVERSED_FLAG
,      NET_ZERO_FLAG
,      REDUCE_CAPACITY_FLAG
,      LINE_NUM_REVERSED
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      CAPACITY_QUANTITY
,      OVERCOMMITMENT_QTY
,      OVERPROVISIONAL_QTY
,      OVER_PROV_CONF_QTY
,      CONFIRMED_QTY
,      PROVISIONAL_QTY
,      JOB_ID
,      PROJECT_ID
,      RESOURCE_ID
,      EXPENDITURE_ORGANIZATION_ID
,      PJI_SUMMARIZED_FLAG
FROM PA.PA_FORECAST_ITEM_DETAILS;

Dependencies

[top of page]

PA.PA_FORECAST_ITEM_DETAILS does not reference any database object

PA.PA_FORECAST_ITEM_DETAILS is referenced by following:

PA: PA_FORECAST_ITEM_DETAILS#