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

TABLE: PJI.PJI_FM_EXTR_PLAN_LINES

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


This table stores changes to financial plan data. This table will be used by project performance API's to populate PA_FP_XBS_ACCUM_F


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
PJI_FM_EXTR_PALN_LINES_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPROJECT_ID
ColumnPLAN_VERSION_ID
ColumnPLAN_TYPE_ID
PJI_FM_EXTR_PLAN_LINES_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPROJECT_ID
ColumnPLAN_VERSION_ID
Columns
Name Datatype Length Mandatory Comments
PROJECT_ID NUMBER (15) Yes Identifier for the Project
PROJECT_ORG_ID NUMBER (15) Yes Identifier for the Project Operating Unit
PROJECT_ELEMENT_ID NUMBER (15) Yes Identifier for the WBS node
STRUCT_VER_ID NUMBER (15) Yes Identifier for the element structure version
PERIOD_NAME VARCHAR2 (20)
Period name
CALENDAR_TYPE VARCHAR2 (2) Yes P - PA, G - GL, N - Non-Time phased
START_DATE DATE

Start date of plan
END_DATE DATE

End date of plan
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 Identifier for the plan (budget) version
PLAN_TYPE_ID NUMBER (15)
Identifier for the plan type
WP_VERSION_FLAG VARCHAR2 (1)
Indicates if plan version is workplan or financial plan
ROLLUP_TYPE VARCHAR2 (1) Yes W - includes working, B - includes baselined
TXN_CURRENCY_CODE VARCHAR2 (15)
Transaction Currency Code
TXN_RAW_COST NUMBER

Transaction Raw Cost
TXN_BURDENED_COST NUMBER

Transaction Burdened Cost
TXN_REVENUE NUMBER

Transaction Revenue
PRJ_CURRENCY_CODE VARCHAR2 (15)
Project Currency Code
PRJ_RAW_COST NUMBER

Project Raw Cost
PRJ_BURDENED_COST NUMBER

Project Burdened Cost
PRJ_REVENUE NUMBER

Project Revenue
PFC_CURRENCY_CODE VARCHAR2 (15)
Project Functional Currency Code
PFC_RAW_COST NUMBER

Project Functional Raw Cost
PFC_BURDENED_COST NUMBER

Project Functional Burdened Cost
PFC_REVENUE NUMBER

Project Functional Revenue
QUANTITY NUMBER

Quantity
RESOURCE_CLASS_CODE VARCHAR2 (30) Yes Resource Class Identifier
RATE_BASED_FLAG VARCHAR2 (1)
Identifies if transaction is billable or not
ACT_QUANTITY NUMBER

Actual Quantity
ACT_TXN_BURDENED_COST NUMBER

Actual Transaction Burdened Cost
ACT_PRJ_BURDENED_COST NUMBER

Actual Project Burdened Cost
ACT_PFC_BURDENED_COST NUMBER

Actual Project Functional Burdened Cost
ACT_TXN_RAW_COST NUMBER

Actual Transaction Raw Cost
ACT_PRJ_RAW_COST NUMBER

Actual Project Raw Cost
ACT_PFC_RAW_COST NUMBER

Actual Project Functional Raw Cost
ACT_TXN_REVENUE NUMBER

Actual Transaction Revenue
ACT_PRJ_REVENUE NUMBER

Actual Project Raw Revenue
ACT_PFC_REVENUE NUMBER

Actual Project Functional Raw Revenue
ETC_QUANTITY NUMBER

ETC Quantity
ETC_TXN_BURDENED_COST NUMBER

ETC Transaction Burdened Cost
ETC_PRJ_BURDENED_COST NUMBER

ETC Project Burdened Cost
ETC_PFC_BURDENED_COST NUMBER

ETC Project Functional Burdened Cost
ETC_TXN_RAW_COST NUMBER

ETC Transaction Burdened Cost
ETC_PRJ_RAW_COST NUMBER

ETC Raw Cost
ETC_PFC_RAW_COST NUMBER

ETC Raw Cost
CBS_ELEMENT_ID NUMBER (15)
This is the unique identifier of the cost code element.
Query Text

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


SELECT PROJECT_ID
,      PROJECT_ORG_ID
,      PROJECT_ELEMENT_ID
,      STRUCT_VER_ID
,      PERIOD_NAME
,      CALENDAR_TYPE
,      START_DATE
,      END_DATE
,      RBS_ELEMENT_ID
,      RBS_VERSION_ID
,      PLAN_VERSION_ID
,      PLAN_TYPE_ID
,      WP_VERSION_FLAG
,      ROLLUP_TYPE
,      TXN_CURRENCY_CODE
,      TXN_RAW_COST
,      TXN_BURDENED_COST
,      TXN_REVENUE
,      PRJ_CURRENCY_CODE
,      PRJ_RAW_COST
,      PRJ_BURDENED_COST
,      PRJ_REVENUE
,      PFC_CURRENCY_CODE
,      PFC_RAW_COST
,      PFC_BURDENED_COST
,      PFC_REVENUE
,      QUANTITY
,      RESOURCE_CLASS_CODE
,      RATE_BASED_FLAG
,      ACT_QUANTITY
,      ACT_TXN_BURDENED_COST
,      ACT_PRJ_BURDENED_COST
,      ACT_PFC_BURDENED_COST
,      ACT_TXN_RAW_COST
,      ACT_PRJ_RAW_COST
,      ACT_PFC_RAW_COST
,      ACT_TXN_REVENUE
,      ACT_PRJ_REVENUE
,      ACT_PFC_REVENUE
,      ETC_QUANTITY
,      ETC_TXN_BURDENED_COST
,      ETC_PRJ_BURDENED_COST
,      ETC_PFC_BURDENED_COST
,      ETC_TXN_RAW_COST
,      ETC_PRJ_RAW_COST
,      ETC_PFC_RAW_COST
,      CBS_ELEMENT_ID
FROM PJI.PJI_FM_EXTR_PLAN_LINES;

Dependencies

[top of page]

PJI.PJI_FM_EXTR_PLAN_LINES does not reference any database object

PJI.PJI_FM_EXTR_PLAN_LINES is referenced by following:

SchemaPJI
ViewPJI_FM_EXTR_PLAN_LINES#