[Home] [Help] [Dependency Information]

TABLE: PA.PA_FP_ROLLUP_TMP

Object Details

This is an internal table that is used to store temporary data required for doing
the rollup of plan amounts across the Work Breakdown Structure. This is a global temporary
table.

Temporary Table Details

PA.PA_FP_ROLLUP_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_ROLLUP_TMP_N1	NORMAL	NONUNIQUE		RESOURCE_ASSIGNMENT_ID TXN_CURRENCY_CODE START_DATE BUCKETING_PERIOD_CODE
PA_FP_ROLLUP_TMP_N2	NORMAL	NONUNIQUE		BUDGET_LINE_ID
PA_FP_ROLLUP_TMP_N3	NORMAL	NONUNIQUE		BUDGET_VERSION_ID

Columns

Query Text

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

SELECT ROLLUP_ID
,      RESOURCE_ASSIGNMENT_ID
,      OLD_START_DATE
,      START_DATE
,      END_DATE
,      TXN_CURRENCY_CODE
,      PARENT_ASSIGNMENT_ID
,      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
,      OLD_PROJ_RAW_COST
,      OLD_PROJ_BURDENED_COST
,      OLD_PROJ_REVENUE
,      OLD_PROJFUNC_RAW_COST
,      OLD_PROJFUNC_BURDENED_COST
,      OLD_PROJFUNC_REVENUE
,      OLD_QUANTITY
,      OLD_TXN_RAW_COST
,      OLD_TXN_BURDENED_COST
,      OLD_TXN_REVENUE
,      PROJECT_RAW_COST
,      PROJECT_BURDENED_COST
,      PROJECT_REVENUE
,      PROJFUNC_RAW_COST
,      PROJFUNC_BURDENED_COST
,      PROJFUNC_REVENUE
,      TXN_RAW_COST
,      TXN_BURDENED_COST
,      TXN_REVENUE
,      QUANTITY
,      DELETE_FLAG
,      PERIOD_NAME
,      CHANGE_REASON_CODE
,      DESCRIPTION
,      BUCKETING_PERIOD_CODE
,      PM_PRODUCT_CODE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      BUDGET_LINE_ID
,      RAW_COST_SOURCE
,      BURDENED_COST_SOURCE
,      QUANTITY_SOURCE
,      REVENUE_SOURCE
,      PM_BUDGET_LINE_REFERENCE
,      SYSTEM_REFERENCE1
,      SYSTEM_REFERENCE2
,      SYSTEM_REFERENCE3
,      SYSTEM_REFERENCE4
,      SYSTEM_REFERENCE5
,      SYSTEM_REFERENCE6
,      INIT_TXN_PLAN_QUANTITY
,      INIT_TXN_RAW_COST
,      INIT_TXN_BURDENED_COST
,      INIT_TXN_REVENUE
,      RW_COST_RATE_OVERRIDE
,      B_MULTIPLIER_OVERRIDE
,      BILL_RATE_OVERRIDE
,      BILL_RATE
,      COST_RATE
,      BURDEN_COST_RATE
,      BURDEN_MULTIPLIER
,      BILL_MARKUP_PERCENTAGE
,      COST_REJECTION_CODE
,      BURDEN_REJECTION_CODE
,      REVENUE_REJECTION_CODE
,      COST_IND_COMPILED_SET_ID
,      TXN_CURRENCY_CODE_ORG
,      FINAL_TXN_CURR_CODE
,      COST_TXN_CURR_CODE
,      REV_TXN_CURR_CODE
,      BURDEN_TXN_CURR_CODE
,      SYSTEM_REFERENCE_DAT1
,      SYSTEM_REFERENCE_DAT2
,      SYSTEM_REFERENCE_DAT3
,      INIT_QUANTITY
,      TXN_INIT_RAW_COST
,      TXN_INIT_BURDENED_COST
,      TXN_INIT_REVENUE
,      INIT_RAW_COST
,      INIT_BURDENED_COST
,      INIT_REVENUE
,      PROJECT_INIT_RAW_COST
,      PROJECT_INIT_BURDENED_COST
,      PROJECT_INIT_REVENUE
,      BURDEN_COST_RATE_OVERRIDE
,      PC_CUR_CONV_REJECTION_CODE
,      PFC_CUR_CONV_REJECTION_CODE
,      BUDGET_VERSION_ID
,      PROCESSED_FLAG
,      PLAN_START_DATE_SHRUNK_FLAG
,      PLAN_END_DATE_SHRUNK_FLAG
,      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
,      TXN_DISCOUNT_PERCENTAGE
,      TRANSFER_PRICE_RATE
,      BL_CREATED_BY
,      BL_CREATION_DATE
,      OLD_TXN_CURRENCY_CODE
,      TXN_CURR_CODE_OVERRIDE
,      BILLABLE_FLAG
,      RESOURCE_NAME
,      TASK_NAME
,      REVENUE_MULTIPLIER
,      RATE_BASED_FLAG
FROM PA.PA_FP_ROLLUP_TMP;

Dependencies

[top of page]

PA.PA_FP_ROLLUP_TMP does not reference any database object

PA.PA_FP_ROLLUP_TMP is referenced by following:

APPS

PA_FP_ROLLUP_TMP