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

TABLE: PJI.PJI_FP_TXN_ACCUM

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


This table stores summarized cost and revenue measures at project, task and periodic levels for project performance. This table contains the lowest level of summary amounts and does not include summaries by task and resource hierarchies


Storage Details
Tablespace: TablespaceAPPS_TS_SUMMARY
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
PJI_FP_TXN_ACCUM_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_SUMMARY ColumnTXN_ACCUM_HEADER_ID
ColumnRECVR_PERIOD_TYPE
ColumnRECVR_PERIOD_ID
PJI_FP_TXN_ACCUM_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_SUMMARY ColumnPROJECT_ID
Columns
Name Datatype Length Mandatory Comments
TXN_ACCUM_HEADER_ID NUMBER (15) Yes Accum header Identifier
PRJ_RAW_COST NUMBER

Project Raw Cost
POU_RAW_COST NUMBER

Project Functional Raw Cost
EOU_RAW_COST NUMBER

Expenditure Functional Raw Cost
PRJ_BILL_RAW_COST NUMBER

Project Billable Raw Cost
POU_BILL_RAW_COST NUMBER

Project Functional Billable Raw Cost
EOU_BILL_RAW_COST NUMBER

Expenditure Functional Billable Raw Cost
PRJ_BURDENED_COST NUMBER

POU_BURDENED_COST NUMBER

EOU_BURDENED_COST NUMBER

PRJ_BILL_BURDENED_COST NUMBER

POU_BILL_BURDENED_COST NUMBER

EOU_BILL_BURDENED_COST NUMBER

PRJ_REVENUE NUMBER

Project Revenue
POU_REVENUE NUMBER

Project Functional Revenue
POU_UBR NUMBER

POU_UER NUMBER

QUANTITY NUMBER

Quantity
BILL_QUANTITY NUMBER

Billable Quantity
RECVR_PERIOD_TYPE VARCHAR2 (15)
Receiver Period Type
RECVR_PERIOD_NAME VARCHAR2 (15)
LAST_UPDATE_DATE DATE
Yes Standard Who Column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who Column
CREATION_DATE DATE
Yes Standard Who Column
CREATED_BY NUMBER (15) Yes Standard Who Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who Column
RESOURCE_CLASS_ID NUMBER (15)
Resource Class Identifier
PROJECT_ID NUMBER (15)
Project Identifier
PROJECT_ORG_ID NUMBER (15)
Project Operating Unit Identifier
PROJECT_ORGANIZATION_ID NUMBER (15)
Project Organization Identifier
PROJECT_TYPE_CLASS VARCHAR2 (1)
Project Type Class identifier
TASK_ID NUMBER (15)
Task Identifier
RECVR_PERIOD_ID NUMBER (15)
Receiver Period Identifier
TXN_CURRENCY_CODE VARCHAR2 (30)
Transaction Currency Code
TXN_RAW_COST NUMBER

Transaction Raw Cost
TXN_BILL_RAW_COST NUMBER

Transaction Billable Raw Cost
TXN_BRDN_COST NUMBER

Transaction Burdened Cost
TXN_BILL_BRDN_COST NUMBER

Transaction Burdened Billable Cost
TXN_REVENUE NUMBER

Transaction Revenue
PRJ_BRDN_COST NUMBER

Project Burdened Cost
PRJ_BILL_BRDN_COST NUMBER

Project Burdened Billable Cost
POU_BRDN_COST NUMBER

Project Functional Burdened Cost
POU_BILL_BRDN_COST NUMBER

Project Functional Burdened Billable Cost
EOU_BRDN_COST NUMBER

Expenditure Functional Burdened Cost
EOU_BILL_BRDN_COST NUMBER

Expenditure Functional Burdened Billable Cost
G1_RAW_COST NUMBER

Global primary Raw Cost
G1_BILL_RAW_COST NUMBER

Global primary Billable Raw Cost
G1_BRDN_COST NUMBER

Global primary Burdened Cost
G1_BILL_BRDN_COST NUMBER

Global primary Burdened Billable Cost
G1_REVENUE NUMBER

Global Primary Revenue
G2_RAW_COST NUMBER

Global Secondary Raw Cost
G2_BILL_RAW_COST NUMBER

Global Secondary Billable Raw Cost
G2_BRDN_COST NUMBER

Global Secondary Burdened Cost
G2_BILL_BRDN_COST NUMBER

Global Secondary Burdened Billable Cost
G2_REVENUE NUMBER

Global Secondary Revenue
ASSIGNMENT_ID NUMBER (15)
Assignment Idenifier of the Resource
NAMED_ROLE VARCHAR2 (80)
Named Role associated with the Resource
Query Text

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


SELECT TXN_ACCUM_HEADER_ID
,      PRJ_RAW_COST
,      POU_RAW_COST
,      EOU_RAW_COST
,      PRJ_BILL_RAW_COST
,      POU_BILL_RAW_COST
,      EOU_BILL_RAW_COST
,      PRJ_BURDENED_COST
,      POU_BURDENED_COST
,      EOU_BURDENED_COST
,      PRJ_BILL_BURDENED_COST
,      POU_BILL_BURDENED_COST
,      EOU_BILL_BURDENED_COST
,      PRJ_REVENUE
,      POU_REVENUE
,      POU_UBR
,      POU_UER
,      QUANTITY
,      BILL_QUANTITY
,      RECVR_PERIOD_TYPE
,      RECVR_PERIOD_NAME
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      RESOURCE_CLASS_ID
,      PROJECT_ID
,      PROJECT_ORG_ID
,      PROJECT_ORGANIZATION_ID
,      PROJECT_TYPE_CLASS
,      TASK_ID
,      RECVR_PERIOD_ID
,      TXN_CURRENCY_CODE
,      TXN_RAW_COST
,      TXN_BILL_RAW_COST
,      TXN_BRDN_COST
,      TXN_BILL_BRDN_COST
,      TXN_REVENUE
,      PRJ_BRDN_COST
,      PRJ_BILL_BRDN_COST
,      POU_BRDN_COST
,      POU_BILL_BRDN_COST
,      EOU_BRDN_COST
,      EOU_BILL_BRDN_COST
,      G1_RAW_COST
,      G1_BILL_RAW_COST
,      G1_BRDN_COST
,      G1_BILL_BRDN_COST
,      G1_REVENUE
,      G2_RAW_COST
,      G2_BILL_RAW_COST
,      G2_BRDN_COST
,      G2_BILL_BRDN_COST
,      G2_REVENUE
,      ASSIGNMENT_ID
,      NAMED_ROLE
FROM PJI.PJI_FP_TXN_ACCUM;

Dependencies

[top of page]

PJI.PJI_FP_TXN_ACCUM does not reference any database object

PJI.PJI_FP_TXN_ACCUM is referenced by following:

SchemaAPPS
SynonymPJI_FP_TXN_ACCUM