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]

TABLE: PJI.PJI_FM_XBS_ACCUM_TMP1

Object Details

Object Name:	PJI_FM_XBS_ACCUM_TMP1
Object Type:	TABLE
Owner:	PJI
Subobject Name:
Status:	VALID

Temporary Table Details

PJI.PJI_FM_XBS_ACCUM_TMP1 is a global temporary table. The current session is able see data that it placed in the table but other sessions cannot. Data in the table is temporary. It has a data duration of SYS$SESSION. Data is removed at the end of this period.

Storage Details

Tablespace:
PCT Free:	10
PCT Used:	40

Indexes

Index	Type	Uniqueness	Tablespace	Column
PJI_FM_XBS_ACCUM_TMP1_N1	NORMAL	NONUNIQUE		PROJECT_ID PROJECT_ELEMENT_ID

Columns

Name	Datatype	Length	Comments
PROJECT_ID	NUMBER	(15)
STRUCT_VERSION_ID	NUMBER	(15)
PROJECT_ELEMENT_ID	NUMBER	(15)
CALENDAR_TYPE	VARCHAR2	(1)
PERIOD_NAME	VARCHAR2	(20)
PLAN_VERSION_ID	NUMBER	(15)
RES_LIST_MEMBER_ID	NUMBER	(15)
QUANTITY	NUMBER
TXN_CURRENCY_CODE	VARCHAR2	(30)
TXN_RAW_COST	NUMBER
TXN_BRDN_COST	NUMBER
TXN_REVENUE	NUMBER
TXN_LABOR_RAW_COST	NUMBER
TXN_LABOR_BRDN_COST	NUMBER
TXN_EQUIP_RAW_COST	NUMBER
TXN_EQUIP_BRDN_COST	NUMBER
TXN_BASE_RAW_COST	NUMBER
TXN_BASE_BRDN_COST	NUMBER
TXN_BASE_LABOR_RAW_COST	NUMBER
TXN_BASE_LABOR_BRDN_COST	NUMBER
TXN_BASE_EQUIP_RAW_COST	NUMBER
TXN_BASE_EQUIP_BRDN_COST	NUMBER
PRJ_RAW_COST	NUMBER
PRJ_BRDN_COST	NUMBER
PRJ_REVENUE	NUMBER
PRJ_LABOR_RAW_COST	NUMBER
PRJ_LABOR_BRDN_COST	NUMBER
PRJ_EQUIP_RAW_COST	NUMBER
PRJ_EQUIP_BRDN_COST	NUMBER
PRJ_BASE_RAW_COST	NUMBER
PRJ_BASE_BRDN_COST	NUMBER
PRJ_BASE_LABOR_RAW_COST	NUMBER
PRJ_BASE_LABOR_BRDN_COST	NUMBER
PRJ_BASE_EQUIP_RAW_COST	NUMBER
PRJ_BASE_EQUIP_BRDN_COST	NUMBER
POU_RAW_COST	NUMBER
POU_BRDN_COST	NUMBER
POU_REVENUE	NUMBER
POU_LABOR_RAW_COST	NUMBER
POU_LABOR_BRDN_COST	NUMBER
POU_EQUIP_RAW_COST	NUMBER
POU_EQUIP_BRDN_COST	NUMBER
POU_BASE_RAW_COST	NUMBER
POU_BASE_BRDN_COST	NUMBER
POU_BASE_LABOR_RAW_COST	NUMBER
POU_BASE_LABOR_BRDN_COST	NUMBER
POU_BASE_EQUIP_RAW_COST	NUMBER
POU_BASE_EQUIP_BRDN_COST	NUMBER
LABOR_HOURS	NUMBER
EQUIPMENT_HOURS	NUMBER
BASE_LABOR_HOURS	NUMBER
BASE_EQUIP_HOURS	NUMBER
SOURCE_ID	NUMBER
ACT_LABOR_HRS	NUMBER		Actual Labor Hours
ACT_EQUIP_HRS	NUMBER		Actual Equipment Hours
ACT_TXN_LABOR_BRDN_COST	NUMBER		Actual Transaction Labor Burdened Cost
ACT_TXN_EQUIP_BRDN_COST	NUMBER		Actual Transaction Equipment Burdened Cost
ACT_TXN_BRDN_COST	NUMBER		Actual Transaction Burdened Cost
ACT_PRJ_LABOR_BRDN_COST	NUMBER		Actual Project Labor Burdened Cost
ACT_PRJ_EQUIP_BRDN_COST	NUMBER		Actual Project Equipment Burdened Cost
ACT_PRJ_BRDN_COST	NUMBER		Actual Project Burdened Cost
ACT_PFC_LABOR_BRDN_COST	NUMBER
ACT_PFC_EQUIP_BRDN_COST	NUMBER
ACT_PFC_BRDN_COST	NUMBER
ETC_LABOR_HRS	NUMBER		ETC Labor Hours
ETC_EQUIP_HRS	NUMBER		ETC Equipment Hours
ETC_TXNLABOR_BRDN_COST	NUMBER
ETC_TXN_EQUIP_BRDN_COST	NUMBER		ETC Transaction Equipment Burdened Cost
ETC_TXN_BRDN_COST	NUMBER		ETC Transaction Burdened Cost
ETC_PRJ_LABOR_BRDN_COST	NUMBER		ETC Project Labor Burdened Cost
ETC_PRJ_EQUIP_BRDN_COST	NUMBER		ETC Project Equipment Burdened Cost
ETC_PRJ_BRDN_COST	NUMBER		ETC Project Burdened Cost
ETC_POU_LABOR_BRDN_COST	NUMBER		ETC Project Functional Labor Burdened Cost
ETC_POU_EQUIP_BRDN_COST	NUMBER		ETC Project Functional Equipment Burdened Cost
ETC_POU_BRDN_COST	NUMBER		ETC Project Functional Burdened Cost
ACT_TXN_RAW_COST	NUMBER		Actual Transaction Raw Cost
ACT_PRJ_RAW_COST	NUMBER		Actual Project Raw Cost
ACT_POU_RAW_COST	NUMBER		Actual Project Functional Raw Cost
ETC_TXN_RAW_COST	NUMBER		ETC Transaction Raw Cost
ETC_PRJ_RAW_COST	NUMBER		ETC Project Raw Cost
ETC_POU_RAW_COST	NUMBER		ETC Project Functional Raw Cost
ACT_TXN_LABOR_RAW_COST	NUMBER		Actual Transaction Labor Raw Cost
ACT_TXN_EQUIP_RAW_COST	NUMBER		Actual Transaction Equipment Raw Cost
ACT_PRJ_LABOR_RAW_COST	NUMBER		Actual Project Labor Raw Cost
ACT_PRJ_EQUIP_RAW_COST	NUMBER		Actual Project Equipment Raw Cost
ACT_POU_LABOR_RAW_COST	NUMBER		Actual Project Functional Labor Raw Cost
ACT_POU_EQUIP_RAW_COST	NUMBER		Actual Project Functional Equipment Raw Cost
ETC_TXN_LABOR_RAW_COST	NUMBER		ETC Transaction Labor Raw Cost
ETC_TXN_EQUIP_RAW_COST	NUMBER		ETC Transaction Equipment Raw Cost
ETC_PRJ_LABOR_RAW_COST	NUMBER		ETC Project Labor Raw Cost
ETC_PRJ_EQUIP_RAW_COST	NUMBER		ETC Project Equipment Raw Cost
ETC_POU_LABOR_RAW_COST	NUMBER		ETC Project Functional Labor Raw Cost
ETC_POU_EQUIP_RAW_COST	NUMBER		ETC Project Functional Equipment Raw Cost
ACT_POU_LABOR_BRDN_COST	NUMBER		Actual Project Functional Labor Burdened Cost
ACT_POU_EQUIP_BRDN_COST	NUMBER		Actual Project Functional Equipment Burdened Cost
ACT_POU_BRDN_COST	NUMBER		Actual Project Functional Burdened Cost
ETC_TXN_LABOR_BRDN_COST	NUMBER		ETC Transaction Labor Burdened Cost
TXN_LPB_RAW_COST	NUMBER		Latest Published Raw Cost in Transaction currency
TXN_LPB_BRDN_COST	NUMBER		Latest published Burdened Cost in Transaction
TXN_LPB_LABOR_RAW_COST	NUMBER		Latest published Labor Raw Cost in Transaction
TXN_LPB_LABOR_BRDN_COST	NUMBER		Latest published Labor Burdened Cost in Transaction
TXN_LPB_EQUIP_RAW_COST	NUMBER		Latest published Equipment Raw Cost in Transaction
TXN_LPB_EQUIP_BRDN_COST	NUMBER		Latest published Equipment Burdened Cost in Transaction currency
PRJ_LPB_RAW_COST	NUMBER		Latest published Raw Cost in Project currency
PRJ_LPB_BRDN_COST	NUMBER		Latest published Burdened Cost in Project currency
PRJ_LPB_LABOR_RAW_COST	NUMBER		Latest published Labor Raw Cost in Project currency
PRJ_LPB_LABOR_BRDN_COST	NUMBER		Latest published Labor Burdened Cost in Project currency
PRJ_LPB_EQUIP_RAW_COST	NUMBER		Latest published Equipment Raw Cost in Project currency
PRJ_LPB_EQUIP_BRDN_COST	NUMBER		Latest published Equipment Burdened Cost in Project currency
POU_LPB_RAW_COST	NUMBER		Latest published Raw Cost in Project functional currency
POU_LPB_BRDN_COST	NUMBER		Latest published Burdened Cost in Project functional currency
POU_LPB_LABOR_RAW_COST	NUMBER		Latest published Labor Raw Cost in Project functional currency
POU_LPB_LABOR_BRDN_COST	NUMBER		Latest published Labor Burdened Cost in Project functional currency
POU_LPB_EQUIP_RAW_COST	NUMBER		Latest published Equipment Raw Cost in Project functional currency
POU_LPB_EQUIP_BRDN_COST	NUMBER		Latest published Equipment Burdened Cost in Project functional currency
LPB_LABOR_HOURS	NUMBER		Latest published Labor Hours
LPB_EQUIP_HOURS	NUMBER		Latest published Equipment Hours
PERIOD_FLAG	VARCHAR2	(1)	Identify whether periodic data or ITD data for workplan
MIN_START_DATE	DATE
MAX_END_DATE	DATE
P_RAW_COST	NUMBER
P_BRDN_COST	NUMBER
P_REVENUE	NUMBER
P_LBR_RAW_COST	NUMBER
P_LBR_BRDN_COST	NUMBER
P_EQP_RAW_COST	NUMBER
P_EQP_BRDN_COST	NUMBER
P_BASE_RAW_COST	NUMBER
P_BASE_BRDN_COST	NUMBER
P_BASE_LBR_RAW_COST	NUMBER
P_BASE_LBR_BRDN_COST	NUMBER
P_BASE_EQP_RAW_COST	NUMBER
P_BASE_EQP_BRDN_COST	NUMBER
P_LPB_RAW_COST	NUMBER
P_LPB_BRDN_COST	NUMBER
P_LPB_LBR_RAW_COST	NUMBER
P_LPB_LBR_BRDN_COST	NUMBER
P_LPB_EQP_RAW_COST	NUMBER
P_LPB_EQP_BRDN_COST	NUMBER
P_LBR_HOURS	NUMBER
P_EQP_HOURS	NUMBER
P_BASE_LBR_HOURS	NUMBER
P_BASE_EQP_HOURS	NUMBER
P_LPB_LBR_HOURS	NUMBER
P_LPB_EQP_HOURS	NUMBER
P_ACT_LBR_HOURS	NUMBER
P_ACT_EQP_HOURS	NUMBER
P_ACT_LBR_BRDN_COST	NUMBER
P_ACT_EQP_BRDN_COST	NUMBER
P_ACT_RAW_COST	NUMBER
P_ACT_BRDN_COST	NUMBER
P_ACT_LBR_RAW_COST	NUMBER
P_ACT_EQP_RAW_COST	NUMBER
P_ETC_EQP_HOURS	NUMBER
P_ETC_LBR_HOURS	NUMBER
P_ETC_RAW_COST	NUMBER
P_ETC_BRDN_COST	NUMBER
P_ETC_LBR_BRDN_COST	NUMBER
P_ETC_EQP_BRDN_COST	NUMBER
P_ETC_LBR_RAW_COST	NUMBER
P_ETC_EQP_RAW_COST	NUMBER

Query Text

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


SELECT PROJECT_ID
,      STRUCT_VERSION_ID
,      PROJECT_ELEMENT_ID
,      CALENDAR_TYPE
,      PERIOD_NAME
,      PLAN_VERSION_ID
,      RES_LIST_MEMBER_ID
,      QUANTITY
,      TXN_CURRENCY_CODE
,      TXN_RAW_COST
,      TXN_BRDN_COST
,      TXN_REVENUE
,      TXN_LABOR_RAW_COST
,      TXN_LABOR_BRDN_COST
,      TXN_EQUIP_RAW_COST
,      TXN_EQUIP_BRDN_COST
,      TXN_BASE_RAW_COST
,      TXN_BASE_BRDN_COST
,      TXN_BASE_LABOR_RAW_COST
,      TXN_BASE_LABOR_BRDN_COST
,      TXN_BASE_EQUIP_RAW_COST
,      TXN_BASE_EQUIP_BRDN_COST
,      PRJ_RAW_COST
,      PRJ_BRDN_COST
,      PRJ_REVENUE
,      PRJ_LABOR_RAW_COST
,      PRJ_LABOR_BRDN_COST
,      PRJ_EQUIP_RAW_COST
,      PRJ_EQUIP_BRDN_COST
,      PRJ_BASE_RAW_COST
,      PRJ_BASE_BRDN_COST
,      PRJ_BASE_LABOR_RAW_COST
,      PRJ_BASE_LABOR_BRDN_COST
,      PRJ_BASE_EQUIP_RAW_COST
,      PRJ_BASE_EQUIP_BRDN_COST
,      POU_RAW_COST
,      POU_BRDN_COST
,      POU_REVENUE
,      POU_LABOR_RAW_COST
,      POU_LABOR_BRDN_COST
,      POU_EQUIP_RAW_COST
,      POU_EQUIP_BRDN_COST
,      POU_BASE_RAW_COST
,      POU_BASE_BRDN_COST
,      POU_BASE_LABOR_RAW_COST
,      POU_BASE_LABOR_BRDN_COST
,      POU_BASE_EQUIP_RAW_COST
,      POU_BASE_EQUIP_BRDN_COST
,      LABOR_HOURS
,      EQUIPMENT_HOURS
,      BASE_LABOR_HOURS
,      BASE_EQUIP_HOURS
,      SOURCE_ID
,      ACT_LABOR_HRS
,      ACT_EQUIP_HRS
,      ACT_TXN_LABOR_BRDN_COST
,      ACT_TXN_EQUIP_BRDN_COST
,      ACT_TXN_BRDN_COST
,      ACT_PRJ_LABOR_BRDN_COST
,      ACT_PRJ_EQUIP_BRDN_COST
,      ACT_PRJ_BRDN_COST
,      ACT_PFC_LABOR_BRDN_COST
,      ACT_PFC_EQUIP_BRDN_COST
,      ACT_PFC_BRDN_COST
,      ETC_LABOR_HRS
,      ETC_EQUIP_HRS
,      ETC_TXNLABOR_BRDN_COST
,      ETC_TXN_EQUIP_BRDN_COST
,      ETC_TXN_BRDN_COST
,      ETC_PRJ_LABOR_BRDN_COST
,      ETC_PRJ_EQUIP_BRDN_COST
,      ETC_PRJ_BRDN_COST
,      ETC_POU_LABOR_BRDN_COST
,      ETC_POU_EQUIP_BRDN_COST
,      ETC_POU_BRDN_COST
,      ACT_TXN_RAW_COST
,      ACT_PRJ_RAW_COST
,      ACT_POU_RAW_COST
,      ETC_TXN_RAW_COST
,      ETC_PRJ_RAW_COST
,      ETC_POU_RAW_COST
,      ACT_TXN_LABOR_RAW_COST
,      ACT_TXN_EQUIP_RAW_COST
,      ACT_PRJ_LABOR_RAW_COST
,      ACT_PRJ_EQUIP_RAW_COST
,      ACT_POU_LABOR_RAW_COST
,      ACT_POU_EQUIP_RAW_COST
,      ETC_TXN_LABOR_RAW_COST
,      ETC_TXN_EQUIP_RAW_COST
,      ETC_PRJ_LABOR_RAW_COST
,      ETC_PRJ_EQUIP_RAW_COST
,      ETC_POU_LABOR_RAW_COST
,      ETC_POU_EQUIP_RAW_COST
,      ACT_POU_LABOR_BRDN_COST
,      ACT_POU_EQUIP_BRDN_COST
,      ACT_POU_BRDN_COST
,      ETC_TXN_LABOR_BRDN_COST
,      TXN_LPB_RAW_COST
,      TXN_LPB_BRDN_COST
,      TXN_LPB_LABOR_RAW_COST
,      TXN_LPB_LABOR_BRDN_COST
,      TXN_LPB_EQUIP_RAW_COST
,      TXN_LPB_EQUIP_BRDN_COST
,      PRJ_LPB_RAW_COST
,      PRJ_LPB_BRDN_COST
,      PRJ_LPB_LABOR_RAW_COST
,      PRJ_LPB_LABOR_BRDN_COST
,      PRJ_LPB_EQUIP_RAW_COST
,      PRJ_LPB_EQUIP_BRDN_COST
,      POU_LPB_RAW_COST
,      POU_LPB_BRDN_COST
,      POU_LPB_LABOR_RAW_COST
,      POU_LPB_LABOR_BRDN_COST
,      POU_LPB_EQUIP_RAW_COST
,      POU_LPB_EQUIP_BRDN_COST
,      LPB_LABOR_HOURS
,      LPB_EQUIP_HOURS
,      PERIOD_FLAG
,      MIN_START_DATE
,      MAX_END_DATE
,      P_RAW_COST
,      P_BRDN_COST
,      P_REVENUE
,      P_LBR_RAW_COST
,      P_LBR_BRDN_COST
,      P_EQP_RAW_COST
,      P_EQP_BRDN_COST
,      P_BASE_RAW_COST
,      P_BASE_BRDN_COST
,      P_BASE_LBR_RAW_COST
,      P_BASE_LBR_BRDN_COST
,      P_BASE_EQP_RAW_COST
,      P_BASE_EQP_BRDN_COST
,      P_LPB_RAW_COST
,      P_LPB_BRDN_COST
,      P_LPB_LBR_RAW_COST
,      P_LPB_LBR_BRDN_COST
,      P_LPB_EQP_RAW_COST
,      P_LPB_EQP_BRDN_COST
,      P_LBR_HOURS
,      P_EQP_HOURS
,      P_BASE_LBR_HOURS
,      P_BASE_EQP_HOURS
,      P_LPB_LBR_HOURS
,      P_LPB_EQP_HOURS
,      P_ACT_LBR_HOURS
,      P_ACT_EQP_HOURS
,      P_ACT_LBR_BRDN_COST
,      P_ACT_EQP_BRDN_COST
,      P_ACT_RAW_COST
,      P_ACT_BRDN_COST
,      P_ACT_LBR_RAW_COST
,      P_ACT_EQP_RAW_COST
,      P_ETC_EQP_HOURS
,      P_ETC_LBR_HOURS
,      P_ETC_RAW_COST
,      P_ETC_BRDN_COST
,      P_ETC_LBR_BRDN_COST
,      P_ETC_EQP_BRDN_COST
,      P_ETC_LBR_RAW_COST
,      P_ETC_EQP_RAW_COST
FROM PJI.PJI_FM_XBS_ACCUM_TMP1;

Dependencies

[top of page]

PJI.PJI_FM_XBS_ACCUM_TMP1 does not reference any database object

PJI.PJI_FM_XBS_ACCUM_TMP1 is referenced by following:

APPS: PJI_FM_XBS_ACCUM_TMP1