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

TABLE: PJI.PJI_FP_AGGR_PJP1_T

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

This table is a mirror of PJI_FP_XBS_ACCUM_FROM used during summarization

Temporary Table Details

PJI.PJI_FP_AGGR_PJP1_T is a global temporary table. The current session is able see data that it placed in the table but other sessions cannot. Data in the table is temporary. It has a data duration of SYS$SESSION. Data is removed at the end of this period.

Storage Details
Tablespace: Tablespace
PCT Free: 10
PCT Used: 40
Columns
Name Datatype Length Mandatory Comments
WORKER_ID NUMBER (15) Yes Partitioning column.
RECORD_TYPE VARCHAR2 (1)
Differentiate between rollup and non-rollup data.
PRG_LEVEL NUMBER (15)
Program hierarchy rollup level.
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.
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.
CUSTOM1 NUMBER

Custom measure1
CUSTOM2 NUMBER

Custom measure2
CUSTOM3 NUMBER

Custom measure3
CUSTOM4 NUMBER

Custom measure4
CUSTOM5 NUMBER

Custom measure5
CUSTOM6 NUMBER

Custom measure6
CUSTOM7 NUMBER

Custom measure7
CUSTOM8 NUMBER

Custom measure8
CUSTOM9 NUMBER

Custom measure9
CUSTOM10 NUMBER

Custom measure10
CUSTOM11 NUMBER

Custom measure11
CUSTOM12 NUMBER

Custom measure12
CUSTOM13 NUMBER

Custom measure13
CUSTOM14 NUMBER

Custom measure14
CUSTOM15 NUMBER

Custom measure15
LINE_TYPE VARCHAR2 (15)
Temp column to differentiate rows that are entered and rolled up slices.
RATE_DANGLING_FLAG VARCHAR2 (15)
Temp column to mark rows with rate dangling records.
TIME_DANGLING_FLAG VARCHAR2 (15)
Temp column to mark rows with time dangling records.
START_DATE DATE

For plan versions where the transaction entries are non-time phased based or date range based, this is the start date.
END_DATE DATE

For plan versions where the transaction entries are non-time phased based or date range based, this is the end date.
ACT_LABOR_HRS NUMBER

Actual Labor Hours
ACT_EQUIP_HRS NUMBER

Actual Equipment Hours
ACT_LABOR_BRDN_COST NUMBER

Actual Labor Burdened Cost
ACT_EQUIP_BRDN_COST NUMBER

Actual Equipment Burdened Cost
ACT_BRDN_COST NUMBER

Actual Burdened Cost
ACT_RAW_COST NUMBER

Actual Raw Cost
ACT_REVENUE NUMBER

Actual Revenue
ETC_LABOR_HRS NUMBER

ETC Labor Hours
ETC_EQUIP_HRS NUMBER

ETC Equipment Hours
ETC_LABOR_BRDN_COST NUMBER

ETC Labor Burdened Cost
ETC_EQUIP_BRDN_COST NUMBER

ETC Equipment Burdened Cost
ETC_BRDN_COST NUMBER

ETC Burdened Cost
ETC_RAW_COST NUMBER

ETC Raw Cost
ACT_LABOR_RAW_COST NUMBER

Actual Labor Raw Cost
ACT_EQUIP_RAW_COST NUMBER

Actual Equip Raw Cost
ETC_LABOR_RAW_COST NUMBER

ETC Labor Raw Cost
ETC_EQUIP_RAW_COST NUMBER

ETC Equip Raw Cost
PLAN_TYPE_CODE VARCHAR2 (1)
Query Text

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


SELECT WORKER_ID
,      RECORD_TYPE
,      PRG_LEVEL
,      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
,      CUSTOM1
,      CUSTOM2
,      CUSTOM3
,      CUSTOM4
,      CUSTOM5
,      CUSTOM6
,      CUSTOM7
,      CUSTOM8
,      CUSTOM9
,      CUSTOM10
,      CUSTOM11
,      CUSTOM12
,      CUSTOM13
,      CUSTOM14
,      CUSTOM15
,      LINE_TYPE
,      RATE_DANGLING_FLAG
,      TIME_DANGLING_FLAG
,      START_DATE
,      END_DATE
,      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
,      PLAN_TYPE_CODE
FROM PJI.PJI_FP_AGGR_PJP1_T;

Dependencies

[top of page]

PJI.PJI_FP_AGGR_PJP1_T does not reference any database object

PJI.PJI_FP_AGGR_PJP1_T is referenced by following:

SchemaAPPS
SynonymPJI_FP_AGGR_PJP1_T