[Home] [Help] [Dependency Information]
Object Name: | PJI_FP_AGGR_PJP0 |
---|---|
Object Type: | TABLE |
Owner: | PJI |
FND Design Data: | PJI.PJI_FP_AGGR_PJP0 |
Subobject Name: | |
Status: | VALID |
This table is a mirror of PJI_FP_XBS_ACCUM_FROM used during summarization
Tablespace: | |
---|---|
PCT Free: | |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
WORKER_ID | NUMBER | (15) | Yes | Partitioning column. |
TXN_ACCUM_HEADER_ID | NUMBER | (15) | Yes | Transaction accum header |
PROJECT_ID | NUMBER | (15) | Yes | Identifier for the project |
PROJECT_ORG_ID | NUMBER | (15) | Yes | Identifier for the project operating unit |
PROJECT_ORGANIZATION_ID | NUMBER | (15) | Yes | Identifier of the Project Organization |
PROJECT_ELEMENT_ID | NUMBER | (15) | Yes | This is the WBS element id and consists of projects and tasks. |
TIME_ID | NUMBER | (15) | Yes | Numeric identifier for time |
PERIOD_TYPE_ID | NUMBER | (15) | Yes | Numeric identifier for the period type (period, quarter, year, weeks) |
CALENDAR_TYPE | VARCHAR2 | (1) | Yes | Specifies the calendar type (PA, GL, Enterprise) |
RBS_AGGR_LEVEL | VARCHAR2 | (1) | Yes | Indicates, for the current task, the type of RBS aggregation. |
WBS_ROLLUP_FLAG | VARCHAR2 | (1) | Yes | Indicates, for the given project structure version, whether the amounts are rolled up by WBS or not. |
PRG_ROLLUP_FLAG | VARCHAR2 | (1) | Yes | Indicates whether the amounts are rolled up by Project Hierarchy or not. |
CURR_RECORD_TYPE_ID | NUMBER | (15) | Yes | Identifier for the Currency record type |
CURRENCY_CODE | VARCHAR2 | (30) | Yes | Currency Code |
RBS_ELEMENT_ID | NUMBER | (15) | Identifier for the RBS | |
RBS_VERSION_ID | NUMBER | (15) | Identifier for the RBS version | |
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 |
PLAN_TYPE_ID | NUMBER | (15) | Yes | Identifier of the Plan Type |
RAW_COST | NUMBER | Transaction Raw Cost | ||
BRDN_COST | NUMBER | Transaction Burdened Cost | ||
REVENUE | NUMBER | Transaction Revenue | ||
BILL_RAW_COST | NUMBER | Billable Raw Cost | ||
BILL_BRDN_COST | NUMBER | Billable Burdened Cost | ||
BILL_LABOR_RAW_COST | NUMBER | Billable Labor Raw Cost | ||
BILL_LABOR_BRDN_COST | NUMBER | Billable Labor Burdened Cost | ||
BILL_LABOR_HRS | NUMBER | Billable Labor Hours | ||
EQUIPMENT_RAW_COST | NUMBER | Equipment Raw Cost | ||
EQUIPMENT_BRDN_COST | NUMBER | Equipment Burdened Cost | ||
CAPITALIZABLE_RAW_COST | NUMBER | Capitalizable Raw Cost | ||
CAPITALIZABLE_BRDN_COST | NUMBER | Capitalizable Burdened Cost | ||
LABOR_RAW_COST | NUMBER | Labor Raw Cost | ||
LABOR_BRDN_COST | NUMBER | Labor Burdened Cost | ||
LABOR_HRS | NUMBER | Labor Hours | ||
LABOR_REVENUE | NUMBER | Labor Revenue | ||
EQUIPMENT_HOURS | NUMBER | Equipment Hours | ||
BILLABLE_EQUIPMENT_HOURS | NUMBER | Billable Equipment Hours | ||
SUP_INV_COMMITTED_COST | NUMBER | Derived based on Commitments with Commitment Type = Supplier Invoice | ||
PO_COMMITTED_COST | NUMBER | Derived based on Commitments with Commitment Type = Purchase Order | ||
PR_COMMITTED_COST | NUMBER | Derived based on Commitments with Commitment Type = Purchase Requisition | ||
OTH_COMMITTED_COST | NUMBER | Commitments other than Supplier Invoices, Purchase Orders or Purchase Requisitions. |
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;
PJI.PJI_FP_AGGR_PJP0 does not reference any database object
PJI.PJI_FP_AGGR_PJP0 is referenced by following:
|
|
|