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_XBS_ACCUM_TMP1_DEBUG#

Object Details

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

[View Source]

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)
CREATION_DATE	DATE

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

Dependencies

[top of page]

PJI.PJI_FM_XBS_ACCUM_TMP1_DEBUG# references the following:

PJI: PJI_FM_XBS_ACCUM_TMP1_DEBUG

PJI.PJI_FM_XBS_ACCUM_TMP1_DEBUG# is referenced by following:

APPS: PJI_FM_XBS_ACCUM_TMP1_DEBUG