[Home] [Help] [Dependency Information]
Object Name: | PJI_FM_EXTR_PLAN_LINES_DEBUG# |
---|---|
Object Type: | VIEW |
Owner: | PJI |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PROJECT_ID | NUMBER | (15) | Yes | |
PROJECT_ORG_ID | NUMBER | (15) | Yes | |
PROJECT_ELEMENT_ID | NUMBER | (15) | Yes | |
STRUCT_VER_ID | NUMBER | (15) | Yes | |
PERIOD_NAME | VARCHAR2 | (20) | ||
CALENDAR_TYPE | VARCHAR2 | (2) | Yes | |
START_DATE | DATE | |||
END_DATE | DATE | |||
RBS_ELEMENT_ID | NUMBER | (15) | ||
RBS_VERSION_ID | NUMBER | (15) | ||
PLAN_VERSION_ID | NUMBER | (15) | Yes | |
PLAN_TYPE_ID | NUMBER | (15) | ||
WP_VERSION_FLAG | VARCHAR2 | (1) | ||
ROLLUP_TYPE | VARCHAR2 | (1) | Yes | |
TXN_CURRENCY_CODE | VARCHAR2 | (15) | ||
TXN_RAW_COST | NUMBER | |||
TXN_BURDENED_COST | NUMBER | |||
TXN_REVENUE | NUMBER | |||
PRJ_CURRENCY_CODE | VARCHAR2 | (15) | ||
PRJ_RAW_COST | NUMBER | |||
PRJ_BURDENED_COST | NUMBER | |||
PRJ_REVENUE | NUMBER | |||
PFC_CURRENCY_CODE | VARCHAR2 | (15) | ||
PFC_RAW_COST | NUMBER | |||
PFC_BURDENED_COST | NUMBER | |||
PFC_REVENUE | NUMBER | |||
QUANTITY | NUMBER | |||
RESOURCE_CLASS_CODE | VARCHAR2 | (30) | Yes | |
RATE_BASED_FLAG | VARCHAR2 | (1) | ||
ACT_QUANTITY | NUMBER | |||
ACT_TXN_BURDENED_COST | NUMBER | |||
ACT_PRJ_BURDENED_COST | NUMBER | |||
ACT_PFC_BURDENED_COST | NUMBER | |||
ACT_TXN_RAW_COST | NUMBER | |||
ACT_PRJ_RAW_COST | NUMBER | |||
ACT_PFC_RAW_COST | NUMBER | |||
ACT_TXN_REVENUE | NUMBER | |||
ACT_PRJ_REVENUE | NUMBER | |||
ACT_PFC_REVENUE | NUMBER | |||
ETC_QUANTITY | NUMBER | |||
ETC_TXN_BURDENED_COST | NUMBER | |||
ETC_PRJ_BURDENED_COST | NUMBER | |||
ETC_PFC_BURDENED_COST | NUMBER | |||
ETC_TXN_RAW_COST | NUMBER | |||
ETC_PRJ_RAW_COST | NUMBER | |||
ETC_PFC_RAW_COST | NUMBER | |||
CREATION_DATE | DATE |
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
, CREATION_DATE
FROM PJI.PJI_FM_EXTR_PLAN_LINES_DEBUG#;
|
|
|