DBA Data[Home] [Help] [Dependency Information]

TABLE: PJI.PJI_FP_AGGR_PJP0

Object Details
Object Name: PJI_FP_AGGR_PJP0
Object Type: TABLE
Owner: PJI
FND Design Data: TablePJI.PJI_FP_AGGR_PJP0
Subobject Name:
Status: VALID

This table is a mirror of PJI_FP_XBS_ACCUM_FROM used during summarization

Storage Details
Tablespace: Tablespace
PCT Free:
PCT Used:
Columns
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.
Query Text

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;

Dependencies

[top of page]

PJI.PJI_FP_AGGR_PJP0 does not reference any database object

PJI.PJI_FP_AGGR_PJP0 is referenced by following:

SchemaPJI
ViewPJI_FP_AGGR_PJP0#