[Home] [Help] [Dependency Information]
Object Name: | PJI_FP_AGGR_PJP0# |
---|---|
Object Type: | VIEW |
Owner: | PJI |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
WORKER_ID | NUMBER | (15) | Yes | |
TXN_ACCUM_HEADER_ID | NUMBER | (15) | Yes | |
PROJECT_ID | NUMBER | (15) | Yes | |
PROJECT_ORG_ID | NUMBER | (15) | Yes | |
PROJECT_ORGANIZATION_ID | NUMBER | (15) | Yes | |
PROJECT_ELEMENT_ID | NUMBER | (15) | Yes | |
TIME_ID | NUMBER | (15) | Yes | |
PERIOD_TYPE_ID | NUMBER | (15) | Yes | |
CALENDAR_TYPE | VARCHAR2 | (1) | Yes | |
RBS_AGGR_LEVEL | VARCHAR2 | (1) | Yes | |
WBS_ROLLUP_FLAG | VARCHAR2 | (1) | Yes | |
PRG_ROLLUP_FLAG | VARCHAR2 | (1) | Yes | |
CURR_RECORD_TYPE_ID | NUMBER | (15) | Yes | |
CURRENCY_CODE | VARCHAR2 | (30) | Yes | |
RBS_ELEMENT_ID | NUMBER | (15) | ||
RBS_VERSION_ID | NUMBER | (15) | ||
PLAN_VERSION_ID | NUMBER | (15) | Yes | |
PLAN_TYPE_ID | NUMBER | (15) | Yes | |
RAW_COST | NUMBER | |||
BRDN_COST | NUMBER | |||
REVENUE | NUMBER | |||
BILL_RAW_COST | NUMBER | |||
BILL_BRDN_COST | NUMBER | |||
BILL_LABOR_RAW_COST | NUMBER | |||
BILL_LABOR_BRDN_COST | NUMBER | |||
BILL_LABOR_HRS | NUMBER | |||
EQUIPMENT_RAW_COST | NUMBER | |||
EQUIPMENT_BRDN_COST | NUMBER | |||
CAPITALIZABLE_RAW_COST | NUMBER | |||
CAPITALIZABLE_BRDN_COST | NUMBER | |||
LABOR_RAW_COST | NUMBER | |||
LABOR_BRDN_COST | NUMBER | |||
LABOR_HRS | NUMBER | |||
LABOR_REVENUE | NUMBER | |||
EQUIPMENT_HOURS | NUMBER | |||
BILLABLE_EQUIPMENT_HOURS | NUMBER | |||
SUP_INV_COMMITTED_COST | NUMBER | |||
PO_COMMITTED_COST | NUMBER | |||
PR_COMMITTED_COST | NUMBER | |||
OTH_COMMITTED_COST | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT WORKER_ID
, TXN_ACCUM_HEADER_ID
, PROJECT_ID
, PROJECT_ORG_ID
, PROJECT_ORGANIZATION_ID
, PROJECT_ELEMENT_ID
, TIME_ID
, PERIOD_TYPE_ID
, CALENDAR_TYPE
, RBS_AGGR_LEVEL
, WBS_ROLLUP_FLAG
, PRG_ROLLUP_FLAG
, CURR_RECORD_TYPE_ID
, CURRENCY_CODE
, RBS_ELEMENT_ID
, RBS_VERSION_ID
, PLAN_VERSION_ID
, PLAN_TYPE_ID
, RAW_COST
, BRDN_COST
, REVENUE
, BILL_RAW_COST
, BILL_BRDN_COST
, BILL_LABOR_RAW_COST
, BILL_LABOR_BRDN_COST
, BILL_LABOR_HRS
, EQUIPMENT_RAW_COST
, EQUIPMENT_BRDN_COST
, CAPITALIZABLE_RAW_COST
, CAPITALIZABLE_BRDN_COST
, LABOR_RAW_COST
, LABOR_BRDN_COST
, LABOR_HRS
, LABOR_REVENUE
, EQUIPMENT_HOURS
, BILLABLE_EQUIPMENT_HOURS
, SUP_INV_COMMITTED_COST
, PO_COMMITTED_COST
, PR_COMMITTED_COST
, OTH_COMMITTED_COST
FROM PJI.PJI_FP_AGGR_PJP0#;
|
|
|