[Home] [Help] [Dependency Information]

TABLE: PA.PA_FP_SPREAD_CALC_TMP1

Object Details

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_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
PA_FP_SPREAD_CALC_TMP1_N1	NORMAL	NONUNIQUE		RESOURCE_ASSIGNMENT_ID TXN_CURRENCY_CODE START_DATE
PA_FP_SPREAD_CALC_TMP1_N2	NORMAL	NONUNIQUE		BUDGET_VERSION_ID BUDGET_LINE_ID

Columns

Query Text

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

SELECT PROJECT_ID
,      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
,      PROJECT_RAW_COST
,      PROJECT_BURDENED_COST
,      PROJECT_REVENUE
,      PROJFUNC_RAW_COST
,      PROJFUNC_BURDENED_COST
,      PROJFUNC_REVENUE
,      COST_REJECTION_CODE
,      BURDEN_REJECTION_CODE
,      REVENUE_REJECTION_CODE
,      PC_CUR_CONV_REJECTION_CODE
,      PFC_CUR_CONV_REJECTION_CODE
,      COST_IND_COMPILED_SET_ID
,      ETC_START_DATE
,      OLD_BL_START_DATE
,      OLD_BL_END_DATE
,      OLD_PLAN_START_DATE
,      OLD_PLAN_END_DATE
,      NEW_PLAN_START_DATE
,      NEW_PLAN_END_DATE
,      OLD_SP_FIX_DATE
,      NEW_SP_FIX_DATE
,      OLD_SPREAD_CURVE_ID
,      NEW_SPREAD_CURVE_ID
,      OLD_MFC_COST_TYPE_ID
,      NEW_MFC_COST_TYPE_ID
,      OLD_TIME_PHASE_CODE
,      NEW_TIME_PHASE_CODE
,      SPREAD_AMTS_FLAG
,      RE_SPREAD_AMTS_FLAG
,      DELETE_BL_FLAG
,      REFRESH_COST_FLAG
,      REFRESH_RATES_FLAG
,      CALLING_CONTEXT
,      TXN_CURR_CODE_OVERRIDE
,      APPLY_PROGRESS_FLAG
,      SP_CURVE_CHANGE_FLAG
,      SP_FIX_DATE_CHANGE_FLAG
,      MFC_COST_CHANGE_FLAG
,      PLAN_DATES_CHANGE_FLAG
,      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
,      CHANGE_REASON_CODE
,      DESCRIPTION
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      RAW_COST_SOURCE
,      BURDENED_COST_SOURCE
,      QUANTITY_SOURCE
,      REVENUE_SOURCE
,      PM_PRODUCT_CODE
,      PM_BUDGET_LINE_REFERENCE
,      CODE_COMBINATION_ID
,      CCID_GEN_STATUS_CODE
,      CCID_GEN_REJ_MESSAGE
,      BORROWED_REVENUE
,      TP_REVENUE_IN
,      TP_REVENUE_OUT
,      REVENUE_ADJ
,      LENT_RESOURCE_COST
,      TP_COST_IN
,      TP_COST_OUT
,      COST_ADJ
,      UNASSIGNED_TIME_COST
,      UTILIZATION_PERCENT
,      UTILIZATION_HOURS
,      UTILIZATION_ADJ
,      CAPACITY
,      HEAD_COUNT
,      HEAD_COUNT_ADJ
,      BUCKETING_PERIOD_CODE
,      TXN_DISCOUNT_PERCENTAGE
,      TRANSFER_PRICE_RATE
,      PROCESSED_FLAG
,      SKIP_RECORD_FLAG
,      PLAN_START_DATE_SHRUNK_FLAG
,      PLAN_END_DATE_SHRUNK_FLAG
,      BL_CREATED_BY
,      BL_CREATION_DATE
,      BILLABLE_FLAG
,      BURDEN_MULTIPLIER
,      REVENUE_MULTIPLIER
,      TASK_ID
,      RESOURCE_NAME
,      TASK_NAME
,      RATE_BASED_FLAG
FROM PA.PA_FP_SPREAD_CALC_TMP1;

Dependencies

[top of page]

PA.PA_FP_SPREAD_CALC_TMP1 does not reference any database object

PA.PA_FP_SPREAD_CALC_TMP1 is referenced by following:

APPS

PA_FP_SPREAD_CALC_TMP1