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

TABLE: PJI.PJI_FP_XBS_ACCUM_F

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


This table stores summarized cost, revenue, commitments measures for project performance by work breakdown, resource breakdown and program hierarchies. It also stores data by for different calendars and currencies


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
PJI_FP_XBS_ACCUM_F_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPROJECT_ID
ColumnPLAN_VERSION_ID
ColumnPROJECT_ELEMENT_ID
ColumnTIME_ID
ColumnRBS_VERSION_ID
PJI_FP_XBS_ACCUM_F_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPROJECT_ID
ColumnPROJECT_ELEMENT_ID
ColumnRBS_ELEMENT_ID
ColumnRBS_VERSION_ID
ColumnTIME_ID
ColumnPERIOD_TYPE_ID
ColumnPLAN_VERSION_ID
PJI_FP_XBS_ACCUM_F_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPROJECT_ID
ColumnPLAN_VERSION_ID
ColumnPROJECT_ELEMENT_ID
ColumnTIME_ID
ColumnRBS_VERSION_ID
ColumnRBS_ELEMENT_ID
ColumnPROJECT_ORGANIZATION_ID
PJI_FP_XBS_ACCUM_F_N4 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPROJECT_ID
ColumnPERIOD_TYPE_ID
ColumnRBS_AGGR_LEVEL
ColumnWBS_ROLLUP_FLAG
ColumnPRG_ROLLUP_FLAG
PJI_FP_XBS_ACCUM_F_N5 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPROJECT_ID
ColumnCALENDAR_TYPE
ColumnRBS_AGGR_LEVEL
ColumnPRG_ROLLUP_FLAG
ColumnPLAN_VERSION_ID
ColumnPROJECT_ELEMENT_ID
PJI_FP_XBS_ACCUM_F_N6 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPROJECT_ID
ColumnPLAN_VERSION_ID
ColumnPROJECT_ELEMENT_ID
ColumnTIME_ID
ColumnRBS_VERSION_ID
ColumnRBS_ELEMENT_ID
ColumnPROJECT_ORGANIZATION_ID
ColumnPLAN_TYPE_ID
ColumnPLAN_TYPE_CODE
ColumnPROJECT_ORG_ID
ColumnPERIOD_TYPE_ID
ColumnCALENDAR_TYPE
ColumnRBS_AGGR_LEVEL
ColumnWBS_ROLLUP_FLAG
ColumnPRG_ROLLUP_FLAG
ColumnCURR_RECORD_TYPE_ID
ColumnCURRENCY_CODE
Columns
Name Datatype Length Mandatory Comments
PROJECT_ID NUMBER (15) Yes Identifier for the project
PROJECT_ORG_ID NUMBER (15) Yes Identifier of 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. L = Lowest (data extracted from the transaction system) R = Rollup (date rollup up by RBS)T = Top (Common amount that is the sum total of a given RBS structure for the current task.)
WBS_ROLLUP_FLAG VARCHAR2 (1) Yes Indicates, for the given project structure version, whether the amounts are rolled up by WBS or not.N = No (Task self amounts.) Y = Yes (Task amounts rolled up by WBS. Rolled up amounts do not include self amounts.)
PRG_ROLLUP_FLAG VARCHAR2 (1) Yes Indicates whether the amounts are rolled up by Project Hierarchy or not. N = No (Amounts within a given project.) Y = Yes (Project structure version amounts rolled up by Project Hierarchy. Rolled up amounts do not include self amounts.)
CURR_RECORD_TYPE_ID NUMBER (15) Yes Bitmask Identifier for the Currency record type. 1- Global Secondary, 2 - Global Primary, 4 - Project, 8 - Project Functional, 16 - Transaction
CURRENCY_CODE VARCHAR2 (30) Yes Currency Code
RBS_ELEMENT_ID NUMBER (15) Yes 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
LAST_UPDATE_DATE DATE
Yes Standard Who Column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who Column
CREATION_DATE DATE

Standard Who Column
CREATED_BY NUMBER (15)
Standard Who Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who Column
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
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 Equipment Raw Cost
ETC_LABOR_RAW_COST NUMBER

ETC Labor Raw Cost
ETC_EQUIP_RAW_COST NUMBER

ETC Equipment Raw Cost
PLAN_TYPE_CODE VARCHAR2 (1)
Identifier for the plan type code. A - actuals or Cost and Revenue together, C - Cost, R - Revenue
Query Text

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


SELECT 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
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      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
,      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_XBS_ACCUM_F;

Dependencies

[top of page]

PJI.PJI_FP_XBS_ACCUM_F does not reference any database object

PJI.PJI_FP_XBS_ACCUM_F is referenced by following:

SchemaPJI
ViewPJI_FP_XBS_ACCUM_F#