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_SPREAD_CALC_TMP2

Object Details

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

This is an internal table that is used to store temporary data required for calculate and spread api internal processing. This is a global temporary table.

Temporary Table Details

PA.PA_FP_SPREAD_CALC_TMP2 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
PA_FP_SPREAD_CALC_TMP2_N1	NORMAL	NONUNIQUE		RESOURCE_ASSIGNMENT_ID TXN_CURRENCY_CODE START_DATE
PA_FP_SPREAD_CALC_TMP2_N2	NORMAL	NONUNIQUE		BUDGET_VERSION_ID

Columns

Name	Datatype	Length
BUDGET_VERSION_ID	NUMBER	(15)
BUDGET_VERSION_TYPE	VARCHAR2	(30)
BUDGET_LINE_ID	NUMBER	(15)
RESOURCE_ASSIGNMENT_ID	NUMBER	(15)
TXN_CURRENCY_CODE	VARCHAR2	(15)
START_DATE	DATE
END_DATE	DATE
PERIOD_NAME	VARCHAR2	(50)
PROJECT_CURRENCY_CODE	VARCHAR2	(15)
PROJFUNC_CURRENCY_CODE	VARCHAR2	(15)
PROJECT_COST_RATE_TYPE	VARCHAR2	(30)
PROJECT_COST_EXCHANGE_RATE	NUMBER
PROJECT_COST_RATE_DATE_TYPE	VARCHAR2	(30)
PROJECT_COST_RATE_DATE	DATE
PROJECT_REV_RATE_TYPE	VARCHAR2	(30)
PROJECT_REV_EXCHANGE_RATE	NUMBER
PROJECT_REV_RATE_DATE_TYPE	VARCHAR2	(30)
PROJECT_REV_RATE_DATE	DATE
PROJFUNC_COST_RATE_TYPE	VARCHAR2	(30)
PROJFUNC_COST_EXCHANGE_RATE	NUMBER
PROJFUNC_COST_RATE_DATE_TYPE	VARCHAR2	(30)
PROJFUNC_COST_RATE_DATE	DATE
PROJFUNC_REV_RATE_TYPE	VARCHAR2	(30)
PROJFUNC_REV_EXCHANGE_RATE	NUMBER
PROJFUNC_REV_RATE_DATE_TYPE	VARCHAR2	(30)
PROJFUNC_REV_RATE_DATE	DATE
TXN_RAW_COST	NUMBER
TXN_BURDENED_COST	NUMBER
TXN_REVENUE	NUMBER
QUANTITY	NUMBER
TXN_INIT_RAW_COST	NUMBER
TXN_INIT_BURDENED_COST	NUMBER
TXN_INIT_REVENUE	NUMBER
INIT_QUANTITY	NUMBER
COST_RATE	NUMBER
COST_RATE_OVERRIDE	NUMBER
BURDEN_COST_RATE	NUMBER
BURDEN_COST_RATE_OVERRIDE	NUMBER
BILL_RATE	NUMBER
BILL_RATE_OVERRIDE	NUMBER
BILL_MARKUP_PERCENTAGE	NUMBER
BILL_MARKUP_PERCENT_OVR	NUMBER
SYSTEM_REFERENCE_NUM1	NUMBER
SYSTEM_REFERENCE_NUM2	NUMBER
SYSTEM_REFERENCE_NUM3	NUMBER
SYSTEM_REFERENCE_NUM4	NUMBER
SYSTEM_REFERENCE_NUM5	NUMBER
SYSTEM_REFERENCE_NUM6	NUMBER
SYSTEM_REFERENCE_VAR1	VARCHAR2	(100)
SYSTEM_REFERENCE_VAR2	VARCHAR2	(100)
SYSTEM_REFERENCE_VAR3	VARCHAR2	(100)
SYSTEM_REFERENCE_VAR4	VARCHAR2	(100)
SYSTEM_REFERENCE_VAR5	VARCHAR2	(100)
SYSTEM_REFERENCE_VAR6	VARCHAR2	(100)
SYSTEM_REFERENCE_DAT1	DATE
SYSTEM_REFERENCE_DAT2	DATE
SYSTEM_REFERENCE_DAT3	DATE
SYSTEM_REFERENCE_DAT4	DATE
SYSTEM_REFERENCE_DAT5	DATE
SYSTEM_REFERENCE_DAT6	DATE
AVG_COST_RATE_OVERRIDE	NUMBER
AVG_BURDEN_RATE_OVERRIDE	NUMBER
AVG_BILL_RATE_OVERRIDE	NUMBER
BILLABLE_FLAG	VARCHAR2	(1)
TASK_ID	NUMBER	(15)
RESOURCE_NAME	VARCHAR2	(250)
TASK_NAME	VARCHAR2	(250)
RATE_BASED_FLAG	VARCHAR2	(1)
OLD_TXN_RAW_COST	NUMBER
OLD_TXN_BURDENED_COST	NUMBER
OLD_TXN_REVENUE	NUMBER
OLD_QUANTITY	NUMBER
OLD_TXN_INIT_RAW_COST	NUMBER
OLD_TXN_INIT_BURDENED_COST	NUMBER
OLD_TXN_INIT_REVENUE	NUMBER
OLD_INIT_QUANTITY	NUMBER

Query Text

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


SELECT BUDGET_VERSION_ID
,      BUDGET_VERSION_TYPE
,      BUDGET_LINE_ID
,      RESOURCE_ASSIGNMENT_ID
,      TXN_CURRENCY_CODE
,      START_DATE
,      END_DATE
,      PERIOD_NAME
,      PROJECT_CURRENCY_CODE
,      PROJFUNC_CURRENCY_CODE
,      PROJECT_COST_RATE_TYPE
,      PROJECT_COST_EXCHANGE_RATE
,      PROJECT_COST_RATE_DATE_TYPE
,      PROJECT_COST_RATE_DATE
,      PROJECT_REV_RATE_TYPE
,      PROJECT_REV_EXCHANGE_RATE
,      PROJECT_REV_RATE_DATE_TYPE
,      PROJECT_REV_RATE_DATE
,      PROJFUNC_COST_RATE_TYPE
,      PROJFUNC_COST_EXCHANGE_RATE
,      PROJFUNC_COST_RATE_DATE_TYPE
,      PROJFUNC_COST_RATE_DATE
,      PROJFUNC_REV_RATE_TYPE
,      PROJFUNC_REV_EXCHANGE_RATE
,      PROJFUNC_REV_RATE_DATE_TYPE
,      PROJFUNC_REV_RATE_DATE
,      TXN_RAW_COST
,      TXN_BURDENED_COST
,      TXN_REVENUE
,      QUANTITY
,      TXN_INIT_RAW_COST
,      TXN_INIT_BURDENED_COST
,      TXN_INIT_REVENUE
,      INIT_QUANTITY
,      COST_RATE
,      COST_RATE_OVERRIDE
,      BURDEN_COST_RATE
,      BURDEN_COST_RATE_OVERRIDE
,      BILL_RATE
,      BILL_RATE_OVERRIDE
,      BILL_MARKUP_PERCENTAGE
,      BILL_MARKUP_PERCENT_OVR
,      SYSTEM_REFERENCE_NUM1
,      SYSTEM_REFERENCE_NUM2
,      SYSTEM_REFERENCE_NUM3
,      SYSTEM_REFERENCE_NUM4
,      SYSTEM_REFERENCE_NUM5
,      SYSTEM_REFERENCE_NUM6
,      SYSTEM_REFERENCE_VAR1
,      SYSTEM_REFERENCE_VAR2
,      SYSTEM_REFERENCE_VAR3
,      SYSTEM_REFERENCE_VAR4
,      SYSTEM_REFERENCE_VAR5
,      SYSTEM_REFERENCE_VAR6
,      SYSTEM_REFERENCE_DAT1
,      SYSTEM_REFERENCE_DAT2
,      SYSTEM_REFERENCE_DAT3
,      SYSTEM_REFERENCE_DAT4
,      SYSTEM_REFERENCE_DAT5
,      SYSTEM_REFERENCE_DAT6
,      AVG_COST_RATE_OVERRIDE
,      AVG_BURDEN_RATE_OVERRIDE
,      AVG_BILL_RATE_OVERRIDE
,      BILLABLE_FLAG
,      TASK_ID
,      RESOURCE_NAME
,      TASK_NAME
,      RATE_BASED_FLAG
,      OLD_TXN_RAW_COST
,      OLD_TXN_BURDENED_COST
,      OLD_TXN_REVENUE
,      OLD_QUANTITY
,      OLD_TXN_INIT_RAW_COST
,      OLD_TXN_INIT_BURDENED_COST
,      OLD_TXN_INIT_REVENUE
,      OLD_INIT_QUANTITY
FROM PA.PA_FP_SPREAD_CALC_TMP2;

Dependencies

[top of page]

PA.PA_FP_SPREAD_CALC_TMP2 does not reference any database object

PA.PA_FP_SPREAD_CALC_TMP2 is referenced by following:

APPS: PA_FP_SPREAD_CALC_TMP2