eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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:	PJI.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:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PJI_FP_XBS_ACCUM_F_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PROJECT_ID PLAN_VERSION_ID PROJECT_ELEMENT_ID TIME_ID RBS_VERSION_ID
PJI_FP_XBS_ACCUM_F_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PROJECT_ID PROJECT_ELEMENT_ID RBS_ELEMENT_ID RBS_VERSION_ID TIME_ID PERIOD_TYPE_ID PLAN_VERSION_ID

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:

APPS: PJI_FP_XBS_ACCUM_F