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]

VIEW: APPS.PA_FP_CI_AMOUNTS_V

Object Details

Object Name:	PA_FP_CI_AMOUNTS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PA.PA_FP_CI_AMOUNTS_V
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
CI_ID	NUMBER	(15)		Internal identifier of the Control Item
PROJECT_ID	NUMBER	(15)	Yes	Internal identifier of the Project
EST_QUANTITY	NUMBER			Estimated Quantity
LABOR_QUANTITY	NUMBER			Planned Quantity
EST_PROJECT_RAW_COST	NUMBER			Estimated raw cost in project currency
TOTAL_PROJECT_RAW_COST	NUMBER			Total planned raw cost in project currency
EST_PROJECT_BURDENED_COST	NUMBER			Estimated burdened cost in project currency
TOTAL_PROJECT_BURDENED_COST	NUMBER			Total planned burdened cost in project currency
EST_PROJECT_REVENUE	NUMBER			Estimated revenue in project currency
TOTAL_PROJECT_REVENUE	NUMBER			Total planned revenue in project currency
EST_PROJECT_COST	NUMBER			Estimated cost in project currency
TOTAL_PROJECT_COST	NUMBER			Total planned cost in project currency
DERIVED_QUANTITY	NUMBER			Quantity derived from planned or estmated quantity
DERIVED_COST	NUMBER			Cost derived from planned or estimated cost, raw or burdened depending on plan setup, in project currency
DERIVED_REVENUE	NUMBER			Revenue derived from planned or estimated revenue in project currency
EST_MARGIN	VARCHAR2	(40)		Margin derived from estimated revenue and estimated cost
EST_MARGIN_PERCENTAGE	VARCHAR2	(40)		Margin Percentage derived from estimated revenue and estimated cost
PLANNED_MARGIN	NUMBER			Margin derived from planned revenue and planned cost
PLANNED_MARGIN_PERCENTAGE	VARCHAR2	(40)		Margin Percentage derived from planned revenue and planned cost
DERIVED_MARGIN	VARCHAR2	(40)		Margin derived from derived revenue and derived cost
DERIVED_MARGIN_PERCENTAGE	VARCHAR2	(40)		Margin Percentage derived from derived revenue and derived cost

Query Text

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


SELECT CI_ID
,      PROJECT_ID
,      EST_QUANTITY
,      LABOR_QUANTITY
,      EST_PROJECT_RAW_COST
,      TOTAL_PROJECT_RAW_COST
,      EST_PROJECT_BURDENED_COST
,      TOTAL_PROJECT_BURDENED_COST
,      EST_PROJECT_REVENUE
,      TOTAL_PROJECT_REVENUE
,      EST_PROJECT_COST
,      TOTAL_PROJECT_COST
,      DERIVED_QUANTITY
,      DERIVED_COST
,      DERIVED_REVENUE
,      EST_MARGIN
,      EST_MARGIN_PERCENTAGE
,      PLANNED_MARGIN
,      PLANNED_MARGIN_PERCENTAGE
,      DERIVED_MARGIN
,      DERIVED_MARGIN_PERCENTAGE
FROM APPS.PA_FP_CI_AMOUNTS_V;

Dependencies

[top of page]

APPS.PA_FP_CI_AMOUNTS_V references the following:

APPS: PA_BUDGET_VERSIONS; PA_CI_TYPES_W_FINPLAN_V; PA_CONTROL_ITEMS; PA_PROJ_FP_OPTIONS

APPS.PA_FP_CI_AMOUNTS_V is referenced by following:

APPS: PA_CI_CRPRJ_LIST_V; PA_CI_LIST_V