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_FP_MERGED_CTRL_ITEMS

Object Details

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

This table stores information about the change documents that have been merged into a financial plan version. The financial impact of a change document is stored as a separate plan version, in the PA_BUDGET_VERSIONS table. Whenever such financial impact is merged into a working version of the project's financial plan, a record is created in this table. Each row contains references to two plan versions. PLAN_VERSION_ID indicates the project's financial plan version into which the financial impact of a change document has been merged. CI_PLAN_VERSION_ID indicates the plan version of the change document that contains such financial impact.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PA_FP_MERGED_CTRL_ITEMS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	PROJECT_ID PLAN_VERSION_ID CI_ID CI_PLAN_VERSION_ID VERSION_TYPE
PA_FP_MERGED_CTRL_ITEMS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	INCLUDED_BY_PERSON_ID

Columns

Name	Datatype	Length	Mandatory	Comments
PROJECT_ID	NUMBER	(15)	Yes	Unique identifier of the project
PLAN_VERSION_ID	NUMBER	(15)	Yes	Unique identifier of the plan version into which the financial plan impact of the change document has been merged
CI_ID	NUMBER	(15)	Yes	Unique identifier of the change document
CI_PLAN_VERSION_ID	NUMBER	(15)	Yes	Unique identifier of the change document''s plan version which has been merged into this plan version
RECORD_VERSION_NUMBER	NUMBER	(15)	Yes	Internally generated number used for record locking
CREATION_DATE	DATE		Yes	Standard Who Column
CREATED_BY	NUMBER	(15)	Yes	Standard Who Column
LAST_UPDATE_LOGIN	NUMBER	(15)	Yes	Standard Who Column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who Column
LAST_UPDATE_DATE	DATE		Yes	Standard Who Column
INCLUSION_METHOD_CODE	VARCHAR2	(30)		This stores the inclusion method of this change document into this plan version. Lookup PA_FP_CI_INCLUSION_METHOD is associated with this column.
INCLUDED_BY_PERSON_ID	NUMBER	(15)		This stores the owner who merged this change document into this plan version
VERSION_TYPE	VARCHAR2	(30)		This column indicates if the COST portion of the Cl was implemented or REVENUE portion of the Cl was implemented or ALL (both cost and revenue of the Cl) was implemented into the current working version of the plan type.
IMPL_PROJ_FUNC_RAW_COST	NUMBER			Indicates the implemented raw cost for project functional currency.
IMPL_PROJ_FUNC_BURDENED_COST	NUMBER			Indicates the implemented burdened cost for project functional currency.
IMPL_PROJ_FUNC_REVENUE	NUMBER			Indicates the implemented revenue for project functional currency.
IMPL_PROJ_RAW_COST	NUMBER			Indicates the implemented raw cost for project currency.
IMPL_PROJ_BURDENED_COST	NUMBER			Indicates the implemented burdened cost for project currency.
IMPL_PROJ_REVENUE	NUMBER			Indicates the implemented revenue for project currency.
IMPL_QUANTITY	NUMBER			Indicates the implemented quantity.
IMPL_EQUIPMENT_QUANTITY	NUMBER			Indicates the implemented quantity for equipment resources.
IMPL_AGR_REVENUE	NUMBER			Indicates the implemented revenue in agreement currency.

Query Text

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


SELECT PROJECT_ID
,      PLAN_VERSION_ID
,      CI_ID
,      CI_PLAN_VERSION_ID
,      RECORD_VERSION_NUMBER
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      INCLUSION_METHOD_CODE
,      INCLUDED_BY_PERSON_ID
,      VERSION_TYPE
,      IMPL_PROJ_FUNC_RAW_COST
,      IMPL_PROJ_FUNC_BURDENED_COST
,      IMPL_PROJ_FUNC_REVENUE
,      IMPL_PROJ_RAW_COST
,      IMPL_PROJ_BURDENED_COST
,      IMPL_PROJ_REVENUE
,      IMPL_QUANTITY
,      IMPL_EQUIPMENT_QUANTITY
,      IMPL_AGR_REVENUE
FROM PA.PA_FP_MERGED_CTRL_ITEMS;

Dependencies

[top of page]

PA.PA_FP_MERGED_CTRL_ITEMS does not reference any database object

PA.PA_FP_MERGED_CTRL_ITEMS is referenced by following:

PA: PA_FP_MERGED_CTRL_ITEMS#