[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | PJI_FM_EXTR_PLAN_LINES |
|---|---|
| Object Type: | TABLE |
| Owner: | PJI |
| FND Design Data: |  PJI.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
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| 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 |
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
FROM PJI.PJI_FM_EXTR_PLAN_LINES;
PJI.PJI_FM_EXTR_PLAN_LINES does not reference any database object
PJI.PJI_FM_EXTR_PLAN_LINES is referenced by following:
APPS
PJI_FM_EXTR_PLAN_LINES
|
|
|
|