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.PJI_XBS_PLANS_PRJ_V

Object Details

Object Name:	PJI_XBS_PLANS_PRJ_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PJI.PJI_XBS_PLANS_PRJ_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
PROJECT_ID	NUMBER	(15)	Yes	Identifier for the project
PLAN_VERSION_ID	NUMBER	(15)	Yes	Same as Budget version identifier. >0 = version id, -1 = Actuals, -2 = Progress Actuals, -3 = Current Baselined, -4 = Current Original Baselined
STRUCTURE_VERSION_ID	NUMBER	(15)		WBS structure version associated with the project and plan version
PROJ_ELEMENT_ID	NUMBER	(15)	Yes	This is the WBS element id and consists of projects and tasks.
STRUCTURE_TYPE	VARCHAR2	(9)
LABOR_EFFORT	NUMBER
EQUIPMENT_EFFORT	NUMBER
RAW_COST	NUMBER
BRDN_COST	NUMBER
REVENUE	NUMBER
LABOR_RAW_COST	NUMBER
LABOR_BRDN_COST	NUMBER
LABOR_REVENUE	NUMBER
EQUIPMENT_HOURS	NUMBER
ACT_LABOR_HRS	NUMBER
ACT_EQUIP_HRS	NUMBER
ACT_LABOR_BRDN_COST	NUMBER
ACT_EQUIP_BRDN_COST	NUMBER
ACT_BRDN_COST	NUMBER
ACT_RAW_COST	NUMBER
ACT_REVENUE	NUMBER
ETC_LABOR_HRS	NUMBER
ETC_EQUIP_HRS	NUMBER
ETC_LABOR_BRDN_COST	NUMBER
ETC_EQUIP_BRDN_COST	NUMBER
ETC_BRDN_COST	NUMBER
ETC_RAW_COST	NUMBER
ACT_LABOR_RAW_COST	NUMBER
ACT_EQUIP_RAW_COST	NUMBER
ETC_LABOR_RAW_COST	NUMBER
ETC_EQUIP_RAW_COST	NUMBER

Query Text

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


SELECT PROJECT_ID
,      PLAN_VERSION_ID
,      STRUCTURE_VERSION_ID
,      PROJ_ELEMENT_ID
,      STRUCTURE_TYPE
,      LABOR_EFFORT
,      EQUIPMENT_EFFORT
,      RAW_COST
,      BRDN_COST
,      REVENUE
,      LABOR_RAW_COST
,      LABOR_BRDN_COST
,      LABOR_REVENUE
,      EQUIPMENT_HOURS
,      ACT_LABOR_HRS
,      ACT_EQUIP_HRS
,      ACT_LABOR_BRDN_COST
,      ACT_EQUIP_BRDN_COST
,      ACT_BRDN_COST
,      ACT_RAW_COST
,      ACT_REVENUE
,      ETC_LABOR_HRS
,      ETC_EQUIP_HRS
,      ETC_LABOR_BRDN_COST
,      ETC_EQUIP_BRDN_COST
,      ETC_BRDN_COST
,      ETC_RAW_COST
,      ACT_LABOR_RAW_COST
,      ACT_EQUIP_RAW_COST
,      ETC_LABOR_RAW_COST
,      ETC_EQUIP_RAW_COST
FROM APPS.PJI_XBS_PLANS_PRJ_V;

Dependencies

[top of page]

APPS.PJI_XBS_PLANS_PRJ_V references the following:

APPS: PJI_FP_XBS_ACCUM_F; PJI_PJP_WBS_HEADER

APPS.PJI_XBS_PLANS_PRJ_V is referenced by following:

APPS: PA_STRUCT_TASKS_AMG_V