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]

VIEW: PJI.PJI_FM_EXTR_PLAN_LINES_DEBUG#

Object Details

Object Name:	PJI_FM_EXTR_PLAN_LINES_DEBUG#
Object Type:	VIEW
Owner:	PJI
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
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

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
,      CREATION_DATE
FROM PJI.PJI_FM_EXTR_PLAN_LINES_DEBUG#;

Dependencies

[top of page]

PJI.PJI_FM_EXTR_PLAN_LINES_DEBUG# references the following:

PJI: PJI_FM_EXTR_PLAN_LINES_DEBUG

PJI.PJI_FM_EXTR_PLAN_LINES_DEBUG# is referenced by following:

APPS: PJI_FM_EXTR_PLAN_LINES_DEBUG