[Home] [Help] [Dependency Information]
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 |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
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 |
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;
|
|
|