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_TMP4

Object Details

Object Name:	PJI_FM_XBS_ACCUM_TMP4
Object Type:	TABLE
Owner:	PJI
FND Design Data:	PJI.PJI_FM_XBS_ACCUM_TMP4
Subobject Name:
Status:	VALID

Temporary Table Details

PJI.PJI_FM_XBS_ACCUM_TMP4 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$TRANSACTION. 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
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
ACT_EQUIP_HRS	NUMBER
ACT_TXN_LABOR_BRDN_COST	NUMBER
ACT_TXN_EQUIP_BRDN_COST	NUMBER
ACT_TXN_BRDN_COST	NUMBER
ACT_PRJ_LABOR_BRDN_COST	NUMBER
ACT_PRJ_EQUIP_BRDN_COST	NUMBER
ACT_PRJ_BRDN_COST	NUMBER
ACT_PFC_LABOR_BRDN_COST	NUMBER
ACT_PFC_EQUIP_BRDN_COST	NUMBER
ACT_PFC_BRDN_COST	NUMBER
ETC_LABOR_HRS	NUMBER
ETC_EQUIP_HRS	NUMBER
ETC_TXNLABOR_BRDN_COST	NUMBER
ETC_TXN_EQUIP_BRDN_COST	NUMBER
ETC_TXN_BRDN_COST	NUMBER
ETC_PRJ_LABOR_BRDN_COST	NUMBER
ETC_PRJ_EQUIP_BRDN_COST	NUMBER
ETC_PRJ_BRDN_COST	NUMBER
ETC_POU_LABOR_BRDN_COST	NUMBER
ETC_POU_EQUIP_BRDN_COST	NUMBER
ETC_POU_BRDN_COST	NUMBER
ACT_TXN_RAW_COST	NUMBER
ACT_PRJ_RAW_COST	NUMBER
ACT_POU_RAW_COST	NUMBER
ETC_TXN_RAW_COST	NUMBER
ETC_PRJ_RAW_COST	NUMBER
ETC_POU_RAW_COST	NUMBER
ACT_TXN_LABOR_RAW_COST	NUMBER
ACT_TXN_EQUIP_RAW_COST	NUMBER
ACT_PRJ_LABOR_RAW_COST	NUMBER
ACT_PRJ_EQUIP_RAW_COST	NUMBER
ACT_POU_LABOR_RAW_COST	NUMBER
ACT_POU_EQUIP_RAW_COST	NUMBER
ETC_TXN_LABOR_RAW_COST	NUMBER
ETC_TXN_EQUIP_RAW_COST	NUMBER
ETC_PRJ_LABOR_RAW_COST	NUMBER
ETC_PRJ_EQUIP_RAW_COST	NUMBER
ETC_POU_LABOR_RAW_COST	NUMBER
ETC_POU_EQUIP_RAW_COST	NUMBER
ACT_POU_LABOR_BRDN_COST	NUMBER
ACT_POU_EQUIP_BRDN_COST	NUMBER
ACT_POU_BRDN_COST	NUMBER
ETC_TXN_LABOR_BRDN_COST	NUMBER
TXN_LPB_RAW_COST	NUMBER
TXN_LPB_BRDN_COST	NUMBER
TXN_LPB_LABOR_RAW_COST	NUMBER
TXN_LPB_LABOR_BRDN_COST	NUMBER
TXN_LPB_EQUIP_RAW_COST	NUMBER
TXN_LPB_EQUIP_BRDN_COST	NUMBER
PRJ_LPB_RAW_COST	NUMBER
PRJ_LPB_BRDN_COST	NUMBER
PRJ_LPB_LABOR_RAW_COST	NUMBER
PRJ_LPB_LABOR_BRDN_COST	NUMBER
PRJ_LPB_EQUIP_RAW_COST	NUMBER
PRJ_LPB_EQUIP_BRDN_COST	NUMBER
POU_LPB_RAW_COST	NUMBER
POU_LPB_BRDN_COST	NUMBER
POU_LPB_LABOR_RAW_COST	NUMBER
POU_LPB_LABOR_BRDN_COST	NUMBER
POU_LPB_EQUIP_RAW_COST	NUMBER
POU_LPB_EQUIP_BRDN_COST	NUMBER
LPB_LABOR_HOURS	NUMBER
LPB_EQUIP_HOURS	NUMBER
PERIOD_FLAG	VARCHAR2	(1)
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
CBS_ELEMENT_ID	NUMBER
CBS_VERSION_ID	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
,      CBS_ELEMENT_ID
,      CBS_VERSION_ID
FROM PJI.PJI_FM_XBS_ACCUM_TMP4;

Dependencies

[top of page]

PJI.PJI_FM_XBS_ACCUM_TMP4 does not reference any database object

PJI.PJI_FM_XBS_ACCUM_TMP4 is referenced by following:

APPS: PJI_FM_XBS_ACCUM_TMP4