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_ORG_FCST_ELEMENTS

Object Details

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

This table stores denormalized header information for Organization Forecasts. It contains information about the provider and receiver organizations, the resources involved and the projects that they are working on.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PA_ORG_FCST_ELEMENTS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	FORECAST_ELEMENT_ID
PA_ORG_FCST_ELEMENTS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BUDGET_VERSION_ID PROJECT_ID

Columns

Name	Datatype	Length	Mandatory	Comments
FORECAST_ELEMENT_ID	NUMBER	(15)	Yes	The system generated number that uniquely identifies the forecast element
RECORD_VERSION_NUMBER	NUMBER		Yes	Internally generated number used for record locking
ORGANIZATION_ID	NUMBER	(15)	Yes	The identifier of the Forecast Organization
ORG_ID	NUMBER	(15)	Yes	The identifier of the Forecast Operating Unit
BUDGET_VERSION_ID	NUMBER	(15)	Yes	The identifier of the Plan Version to which this forecast header information belongs to
PROJECT_ID	NUMBER	(15)	Yes	The identifier of the Project that holds the plan version amounts
TASK_ID	NUMBER	(15)	Yes	The identifier of the task
PROVIDER_RECEIVER_CODE	VARCHAR2	(1)	Yes	Code that indicates whether the Forecast Organization is a Provider or Receiver Organization. Valid values are P for Provider and R for Receiver organization.
OTHER_ORGANIZATION_ID	NUMBER	(15)	Yes	The identifier of the Provider/Receiver Organization. Identifies the Receiver organization if Provider_Receiver_Code is 'P' and the Provider organization if Provider_Receiver_Code is 'R'
OTHER_ORG_ID	NUMBER	(15)	Yes	The identifier of the Provider/Receiver Operating Unit. Identifies the Receiver Operating Unit if Provider_Receiver_Code is 'P' and the Provider Operating Unit if Provider_Receiver_Code is 'R'
TXN_PROJECT_ID	NUMBER	(15)	Yes	Identifier of the project to which the resource is assigned to
ASSIGNMENT_ID	NUMBER			The identifier of the project assignment
RESOURCE_ID	NUMBER	(15)		The identifier of the resource
LAST_UPDATE_DATE	DATE		Yes	Standard Who Column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who Column
CREATION_DATE	DATE		Yes	Standard Who Column
CREATED_BY	NUMBER	(15)	Yes	Standard Who Column
LAST_UPDATE_LOGIN	NUMBER	(15)	Yes	Standard Who Column

Query Text

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


SELECT FORECAST_ELEMENT_ID
,      RECORD_VERSION_NUMBER
,      ORGANIZATION_ID
,      ORG_ID
,      BUDGET_VERSION_ID
,      PROJECT_ID
,      TASK_ID
,      PROVIDER_RECEIVER_CODE
,      OTHER_ORGANIZATION_ID
,      OTHER_ORG_ID
,      TXN_PROJECT_ID
,      ASSIGNMENT_ID
,      RESOURCE_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
FROM PA.PA_ORG_FCST_ELEMENTS;

Dependencies

[top of page]

PA.PA_ORG_FCST_ELEMENTS does not reference any database object

PA.PA_ORG_FCST_ELEMENTS is referenced by following:

PA: PA_ORG_FCST_ELEMENTS#