[Home] [Help] [Dependency Information]

TABLE: PA.PA_FP_SPREAD_CALC_TMP

Object Details

Object Name:	PA_FP_SPREAD_CALC_TMP
Object Type:	TABLE
Owner:	PA
FND Design Data:	PA.PA_FP_SPREAD_CALC_TMP
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_TMP 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_TMP_N1	NORMAL	NONUNIQUE		RESOURCE_ASSIGNMENT_ID TXN_CURRENCY_CODE START_DATE
PA_FP_SPREAD_CALC_TMP_N2	NORMAL	NONUNIQUE		BUDGET_VERSION_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_RATES_FLAG
,      REFRESH_CONV_RATES_FLAG
,      MASS_ADJUST_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
,      PROCESSED_FLAG
,      SKIP_RECORD_FLAG
,      PLAN_START_DATE_SHRUNK_FLAG
,      PLAN_END_DATE_SHRUNK_FLAG
,      G_WPRABL_CURRENCY_CODE
,      QUANTITY_CHANGED_FLAG
,      COST_RATE_CHANGED_FLAG
,      BURDEN_RATE_CHANGED_FLAG
,      BILL_RATE_CHANGED_FLAG
,      RAW_COST_CHANGED_FLAG
,      BURDEN_COST_CHANGED_FLAG
,      REVENUE_CHANGED_FLAG
,      RLM_ID_CHANGE_FLAG
,      MFC_COST_REFRESH_FLAG
,      RA_RATES_ONLY_CHANGE_FLAG
,      BL_QUANTITY
,      BL_TXN_RAW_COST
,      BL_TXN_BURDENED_COST
,      BL_TXN_REVENUE
,      BL_TXN_INIT_RAW_COST
,      BL_TXN_INIT_BURDENED_COST
,      BL_TXN_INIT_REVENUE
,      BL_INIT_QUANTITY
,      BL_COST_RATE
,      BL_COST_RATE_OVERRIDE
,      BL_BURDEN_COST_RATE
,      BL_BURDEN_COST_RATE_OVERRIDE
,      BL_BILL_RATE
,      BL_BILL_RATE_OVERRIDE
,      OLD_TXN_CURRENCY_CODE
,      BILLABLE_FLAG
,      RESOURCE_NAME
,      TASK_ID
,      TASK_NAME
,      RA_IN_MULTI_CUR_FLAG
,      RATE_BASED_FLAG
,      DISPLAY_QUANTITY
,      RESOURCE_UOM
,      RESOURCE_RATE_BASED_FLAG
,      COST_RATE_G_MISS_NUM_FLAG
,      BURDEN_RATE_G_MISS_NUM_FLAG
,      BILL_RATE_G_MISS_NUM_FLAG
,      REVENUE_ONLY_ENTERED_FLAG
,      QUANTITY_G_MISS_NUM_FLAG
,      BURDEN_COST_G_MISS_NUM_FLAG
,      RAW_COST_G_MISS_NUM_FLAG
,      REVENUE_G_MISS_NUM_FLAG
,      BURDEN_ONLY_ENTERED_FLAG
,      NEG_QUANTITY_CHANGE_FLAG
,      NEG_RAWCOST_CHANGE_FLAG
,      NEG_BURDEN_CHANGE_FALG
,      NEG_REVENUE_CHANGE_FLAG
FROM PA.PA_FP_SPREAD_CALC_TMP;

Dependencies

[top of page]

PA.PA_FP_SPREAD_CALC_TMP does not reference any database object

PA.PA_FP_SPREAD_CALC_TMP is referenced by following:

APPS

PA_FP_SPREAD_CALC_TMP