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: PA.PA_FP_FCST_GEN_TMP1

Object Details

Object Name:	PA_FP_FCST_GEN_TMP1
Object Type:	TABLE
Owner:	PA
Subobject Name:
Status:	VALID

Temporary Table Details

PA.PA_FP_FCST_GEN_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$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
PA_FP_FCST_GEN_TMP1_N1	NORMAL	NONUNIQUE		PROJECT_ELEMENT_ID RES_LIST_MEMBER_ID DATA_TYPE_CODE

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
SOURCE_ID	NUMBER	(15)
DATA_TYPE_CODE	VARCHAR2	(10)

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
,      SOURCE_ID
,      DATA_TYPE_CODE
FROM PA.PA_FP_FCST_GEN_TMP1;

Dependencies

[top of page]

PA.PA_FP_FCST_GEN_TMP1 does not reference any database object

PA.PA_FP_FCST_GEN_TMP1 is referenced by following:

APPS: PA_FP_FCST_GEN_TMP1