[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | PA_FP_RES_ASSIGNMENTS_TMP |
|---|---|
| Object Type: | TABLE |
| Owner: | PA |
| FND Design Data: |  PA.PA_FP_RES_ASSIGNMENTS_TMP
|
| Subobject Name: | |
| Status: | VALID |
Stores the resource assignment level data for internal use of Oracle Projects
PA.PA_FP_RES_ASSIGNMENTS_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.
| Tablespace: |  |
|---|---|
| PCT Free: | 10 |
| PCT Used: | 40 |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| PA_FP_RES_ASSIGNMENTS_TMP_N1 | NORMAL | NONUNIQUE |
|
 RESOURCE_ASSIGNMENT_ID
TXN_CURRENCY_CODE
LINE_START_DATE
|
| PA_FP_RES_ASSIGNMENTS_TMP_N2 | NORMAL | NONUNIQUE |
|
BUDGET_VERSION_ID
|
Cut, paste (and edit) the following text to query this object:
SELECT RESOURCE_ASSIGNMENT_ID
, BUDGET_VERSION_ID
, PROJECT_ID
, TASK_ID
, RESOURCE_LIST_MEMBER_ID
, UNIT_OF_MEASURE
, STANDARD_BILL_RATE
, WBS_ELEMENT_VERSION_ID
, RBS_ELEMENT_ID
, PLANNING_START_DATE
, PLANNING_END_DATE
, SPREAD_CURVE_ID
, ETC_METHOD_CODE
, RES_TYPE_CODE
, FC_RES_TYPE_CODE
, RESOURCE_CLASS_CODE
, ORGANIZATION_ID
, JOB_ID
, PERSON_ID
, EXPENDITURE_TYPE
, EXPENDITURE_CATEGORY
, REVENUE_CATEGORY_CODE
, EVENT_TYPE
, SUPPLIER_ID
, NON_LABOR_RESOURCE
, BOM_RESOURCE_ID
, INVENTORY_ITEM_ID
, ITEM_CATEGORY_ID
, BILLABLE_PERCENT
, MFC_COST_TYPE_ID
, INCURRED_BY_RES_FLAG
, RATE_JOB_ID
, RATE_EXPENDITURE_TYPE
, SP_FIXED_DATE
, PERSON_TYPE_CODE
, RATE_BASED_FLAG
, RATE_EXP_FUNC_CURR_CODE
, RATE_EXPENDITURE_ORG_ID
, INCUR_BY_RES_CLASS_CODE
, INCUR_BY_ROLE_ID
, PROJECT_ROLE_ID
, RESOURCE_CLASS_FLAG
, NAMED_ROLE
, TXN_CURRENCY_CODE
, TXN_REVENUE
, TXN_REVENUE_ADDL
, TXN_RAW_COST
, TXN_RAW_COST_ADDL
, TXN_BURDENED_COST
, TXN_BURDENED_COST_ADDL
, TXN_PLAN_QUANTITY
, TXN_PLAN_QUANTITY_ADDL
, TXN_CURRENCY_CODE_OVERRIDE
, TXN_INIT_REVENUE
, TXN_INIT_REVENUE_ADDL
, TXN_INIT_RAW_COST
, TXN_INIT_RAW_COST_ADDL
, TXN_INIT_BURDENED_COST
, TXN_INIT_BURDENED_COST_ADDL
, INIT_QUANTITY
, INIT_QUANTITY_ADDL
, LINE_START_DATE
, LINE_END_DATE
, SOURCE_CONTEXT
, SPREAD_AMOUNTS_FLAG
, RAW_COST_RATE
, RW_COST_RATE_OVERRIDE
, BURDEN_COST_RATE
, BURDEN_COST_RATE_OVERRIDE
, BILL_RATE
, BILL_RATE_OVERRIDE
, RES_CLASS_BILL_RATE_SCH_ID
, RES_CLASS_COST_SCH_ID
, USE_PLANNING_RATES_FLAG
, REV_JOB_RATE_SCH_ID
, COST_JOB_RATE_SCH_ID
, REV_EMP_RATE_SCH_ID
, COST_EMP_RATE_SCH_ID
, REV_NON_LABOR_RES_RATE_SCH_ID
, COST_NON_LABOR_RES_RATE_SCH_ID
, ASSIGN_PRECEDES_TASK
, BILL_JOB_GROUP_ID
, CARRYING_OUT_ORGANIZATION_ID
, MULTI_CURRENCY_BILLING_FLAG
, ORG_ID
, PROJECT_BILL_RATE_ORG_ID
, PROJECT_CURRENCY_CODE
, PROJECT_SCH_DISCOUNT
, PROJECT_SCH_DATE
, PROJECT_STD_BILL_RATE_SCH
, PROJECT_TYPE
, PROJFUNC_CURRENCY_CODE
, TASK_BILL_RATE_ORG_ID
, TASK_SCH_DISCOUNT
, TASK_SCH_DATE
, TASK_STD_BILL_RATE_SCH
, TOP_TASK_ID
, EMP_BILL_RATE_SCHEDULE_ID
, JOB_BILL_RATE_SCHEDULE_ID
, LABOR_BILL_RATE_ORG_ID
, LABOR_SCH_TYPE
, NON_LABOR_SCH_TYPE
, OLD_TXN_CURRENCY_CODE
, BILLABLE_FLAG
, RESOURCE_NAME
, TASK_NAME
, DISPLAY_QUANTITY
, RESOURCE_UOM
, RESOURCE_RATE_BASED_FLAG
, NEG_QUANTITY_CHANGE_FLAG
, NEG_RAWCOST_CHANGE_FLAG
, NEG_BURDEN_CHANGE_FALG
, NEG_REVENUE_CHANGE_FLAG
FROM PA.PA_FP_RES_ASSIGNMENTS_TMP;
PA.PA_FP_RES_ASSIGNMENTS_TMP does not reference any database object
PA.PA_FP_RES_ASSIGNMENTS_TMP is referenced by following:
APPS
PA_FP_RES_ASSIGNMENTS_TMP
|
|
|
|