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_FRCST_ITEM_DTLS_AR

Object Details

Object Name:	PA_FRCST_ITEM_DTLS_AR
Object Type:	TABLE
Owner:	PA
FND Design Data:	PA.PA_FRCST_ITEM_DTLS_AR
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_FRCST_ITEM_DTLS_AR_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PURGE_PROJECT_ID

Columns

Name	Datatype	Length	Mandatory	Comments
AMOUNT_TYPE_ID	NUMBER			Identifier of the amount type , such as Cost , Revenue , and Quantity .
BILLABLE_FLAG	VARCHAR2	(1)		The flag which indicates whether the associated work type is billable
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
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 n
CREATED_BY	NUMBER	(15)	Yes	Standard who column
CREATION_DATE	DATE		Yes	Standard Who column
DENOM_AMOUNT	NUMBER			The amount in Transaction currency
DENOM_CURRENCY_CODE	VARCHAR2	(15)		The Transaction currency code
EXPENDITURE_ORGANIZATION_ID	NUMBER			Identifier of the expenditure organization
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.
FORECAST_ITEM_ID	NUMBER			The identifier of the forecast item.
FORECAST_SUMMARIZED_CODE	VARCHAR2	(30)		Indicates the forecast summarization status,. Valid values are: N - Not Summarized, Y - Summarized, E - Error, X - Summarization Not Required
ITEM_DATE	DATE			The date of the forecast item
ITEM_QUANTITY	NUMBER			The quantity for the item
ITEM_UOM	VARCHAR2	(30)		The Unit of Measure for the item
JOB_ID	NUMBER			Identifier of the job
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column
LAST_UPDATE_DATE	DATE		Yes	Standard who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column
LINE_NUM	NUMBER			A unique system -generated record number for an amount type and a forecast item.
LINE_NUM_REVERSED	NUMBER			The line number that is reversed by this line
NET_ZERO_FLAG	VARCHAR2	(1)		Indicates whether the current and reversing line net out each other and, therefore, both can be deleted after summarization
ORG_UTIL_CATEGORY_ID	NUMBER			Identifier of utilization category derived from the work type from the organization perspective
ORG_UTIL_WEIGHTED	NUMBER			Organization utilization weighted
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 recor
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 reco
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
PERSON_BILLABLE_FLAG	VARCHAR2	(1)		New value of billability for a resource B- Billable, N - Non-- Billable
PJI_SUMMARIZED_FLAG	VARCHAR2	(1)		Indicates the PJI summarization status,. Valid values are: N - Not Summarized, null - Summarized, X - Summarization Not Required
PROGRAM_APPLICATION_ID	NUMBER			Concurrent program Who column
PROGRAM_ID	NUMBER			Concurrent program Who column
PROGRAM_UPDATE_DATE	DATE			Concurrent program Who column
PROJECT_ID	NUMBER			Identifier of the project
PROJECT_ORG_ID	NUMBER			Identifier of the project operating unit.
PROJ_AMOUNT	NUMBER			The amount in project currency
PROJ_CURRENCY_CODE	VARCHAR2	(15)		The project currency code
PROVISIONAL_FLAG	VARCHAR2	(1)		Indicates whether the assignment is Provisional
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'
PURGE_BATCH_ID	NUMBER	(15)	Yes	Purge batch Id
PURGE_PROJECT_ID	NUMBER	(15)	Yes	Purged project Id
PURGE_RELEASE	VARCHAR2	(50)	Yes	Purge release version
PVDR_ACCT_AMOUNT	NUMBER			The amount in expenditure functional currency
PVDR_ACCT_CURR_CODE	VARCHAR2	(15)		The expenditure functional currency code.
RCVR_ACCT_AMOUNT	NUMBER			The amount in project functional currency
RCVR_ACCT_CURR_CODE	VARCHAR2	(15)		The project functional currency code
REDUCE_CAPACITY_FLAG	VARCHAR2	(1)		Indicates reduce capacity flag for Resource
REQUEST_ID	NUMBER			Concurrent program Who column
RESOURCE_ID	NUMBER			Identifier of the resource
RESOURCE_TYPE_CODE	VARCHAR2	(30)		The new value for the type of resource E - Employee , C - Contractor
RESOURCE_UTIL_CATEGORY_ID	NUMBER			Identifier of utilization category derived from the work type from the resource perspective
RESOURCE_UTIL_WEIGHTED	NUMBER			Resource utilization weighted
REVERSED_FLAG	VARCHAR2	(1)		Indicates whether the current line is reversed by another line
TP_AMOUNT_TYPE	VARCHAR2	(30)		The transfer price amount type, only valid for the transfer price amount type
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			Identifier of the work type of the assignment.

Query Text

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


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

Dependencies

[top of page]

PA.PA_FRCST_ITEM_DTLS_AR does not reference any database object

PA.PA_FRCST_ITEM_DTLS_AR is referenced by following:

APPS: PA_FRCST_ITEM_DTLS_AR