[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 |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
RESOURCE_ASSIGNMENT_ID | NUMBER | (15) | Yes | |
BUDGET_VERSION_ID | NUMBER | (15) | Yes | |
PROJECT_ID | NUMBER | (15) | Yes | |
TASK_ID | NUMBER | (15) | ||
RESOURCE_LIST_MEMBER_ID | NUMBER | (15) | Yes | |
UNIT_OF_MEASURE | VARCHAR2 | (30) | ||
STANDARD_BILL_RATE | NUMBER | |||
WBS_ELEMENT_VERSION_ID | NUMBER | (15) | ||
RBS_ELEMENT_ID | NUMBER | (15) | ||
PLANNING_START_DATE | DATE | |||
PLANNING_END_DATE | DATE | |||
SPREAD_CURVE_ID | NUMBER | (15) | ||
ETC_METHOD_CODE | VARCHAR2 | (30) | ||
RES_TYPE_CODE | VARCHAR2 | (30) | ||
FC_RES_TYPE_CODE | VARCHAR2 | (30) | ||
RESOURCE_CLASS_CODE | VARCHAR2 | (30) | ||
ORGANIZATION_ID | NUMBER | (15) | ||
JOB_ID | NUMBER | (15) | ||
PERSON_ID | NUMBER | (15) | ||
EXPENDITURE_TYPE | VARCHAR2 | (30) | ||
EXPENDITURE_CATEGORY | VARCHAR2 | (30) | ||
REVENUE_CATEGORY_CODE | VARCHAR2 | (30) | ||
EVENT_TYPE | VARCHAR2 | (30) | ||
SUPPLIER_ID | NUMBER | (15) | ||
NON_LABOR_RESOURCE | VARCHAR2 | (20) | ||
BOM_RESOURCE_ID | NUMBER | (15) | ||
INVENTORY_ITEM_ID | NUMBER | (15) | ||
ITEM_CATEGORY_ID | NUMBER | (15) | ||
BILLABLE_PERCENT | NUMBER | |||
MFC_COST_TYPE_ID | NUMBER | (15) | ||
INCURRED_BY_RES_FLAG | VARCHAR2 | (1) | ||
RATE_JOB_ID | NUMBER | (15) | ||
RATE_EXPENDITURE_TYPE | VARCHAR2 | (30) | ||
SP_FIXED_DATE | DATE | |||
PERSON_TYPE_CODE | VARCHAR2 | (30) | ||
RATE_BASED_FLAG | VARCHAR2 | (1) | ||
RATE_EXP_FUNC_CURR_CODE | VARCHAR2 | (30) | ||
RATE_EXPENDITURE_ORG_ID | NUMBER | (15) | ||
INCUR_BY_RES_CLASS_CODE | VARCHAR2 | (30) | ||
INCUR_BY_ROLE_ID | NUMBER | (15) | ||
PROJECT_ROLE_ID | NUMBER | (15) | ||
RESOURCE_CLASS_FLAG | VARCHAR2 | (1) | ||
NAMED_ROLE | VARCHAR2 | (80) | ||
TXN_CURRENCY_CODE | VARCHAR2 | (30) | ||
TXN_REVENUE | NUMBER | |||
TXN_REVENUE_ADDL | NUMBER | |||
TXN_RAW_COST | NUMBER | |||
TXN_RAW_COST_ADDL | NUMBER | |||
TXN_BURDENED_COST | NUMBER | |||
TXN_BURDENED_COST_ADDL | NUMBER | |||
TXN_PLAN_QUANTITY | NUMBER | |||
TXN_PLAN_QUANTITY_ADDL | NUMBER | |||
TXN_CURRENCY_CODE_OVERRIDE | VARCHAR2 | (30) | ||
TXN_INIT_REVENUE | NUMBER | |||
TXN_INIT_REVENUE_ADDL | NUMBER | |||
TXN_INIT_RAW_COST | NUMBER | |||
TXN_INIT_RAW_COST_ADDL | NUMBER | |||
TXN_INIT_BURDENED_COST | NUMBER | |||
TXN_INIT_BURDENED_COST_ADDL | NUMBER | |||
INIT_QUANTITY | NUMBER | |||
INIT_QUANTITY_ADDL | NUMBER | |||
LINE_START_DATE | DATE | |||
LINE_END_DATE | DATE | |||
SOURCE_CONTEXT | VARCHAR2 | (30) | ||
SPREAD_AMOUNTS_FLAG | VARCHAR2 | (1) | ||
RAW_COST_RATE | NUMBER | |||
RW_COST_RATE_OVERRIDE | NUMBER | |||
BURDEN_COST_RATE | NUMBER | |||
BURDEN_COST_RATE_OVERRIDE | NUMBER | |||
BILL_RATE | NUMBER | |||
BILL_RATE_OVERRIDE | NUMBER | |||
RES_CLASS_BILL_RATE_SCH_ID | NUMBER | (15) | ||
RES_CLASS_COST_SCH_ID | NUMBER | (15) | ||
USE_PLANNING_RATES_FLAG | VARCHAR2 | (1) | ||
REV_JOB_RATE_SCH_ID | NUMBER | (15) | ||
COST_JOB_RATE_SCH_ID | NUMBER | (15) | ||
REV_EMP_RATE_SCH_ID | NUMBER | (15) | ||
COST_EMP_RATE_SCH_ID | NUMBER | (15) | ||
REV_NON_LABOR_RES_RATE_SCH_ID | NUMBER | (15) | ||
COST_NON_LABOR_RES_RATE_SCH_ID | NUMBER | (15) | ||
ASSIGN_PRECEDES_TASK | VARCHAR2 | (1) | ||
BILL_JOB_GROUP_ID | NUMBER | (15) | ||
CARRYING_OUT_ORGANIZATION_ID | NUMBER | (15) | ||
MULTI_CURRENCY_BILLING_FLAG | VARCHAR2 | (1) | ||
ORG_ID | NUMBER | (15) | ||
PROJECT_BILL_RATE_ORG_ID | NUMBER | (15) | ||
PROJECT_CURRENCY_CODE | VARCHAR2 | (15) | ||
PROJECT_SCH_DISCOUNT | NUMBER | (7) | ||
PROJECT_SCH_DATE | DATE | |||
PROJECT_STD_BILL_RATE_SCH | VARCHAR2 | (30) | ||
PROJECT_TYPE | VARCHAR2 | (20) | ||
PROJFUNC_CURRENCY_CODE | VARCHAR2 | (15) | ||
TASK_BILL_RATE_ORG_ID | NUMBER | (15) | ||
TASK_SCH_DISCOUNT | NUMBER | (7) | ||
TASK_SCH_DATE | DATE | |||
TASK_STD_BILL_RATE_SCH | VARCHAR2 | (30) | ||
TOP_TASK_ID | NUMBER | (15) | ||
EMP_BILL_RATE_SCHEDULE_ID | NUMBER | |||
JOB_BILL_RATE_SCHEDULE_ID | NUMBER | |||
LABOR_BILL_RATE_ORG_ID | NUMBER | (15) | ||
LABOR_SCH_TYPE | VARCHAR2 | (1) | ||
NON_LABOR_SCH_TYPE | VARCHAR2 | (1) | ||
OLD_TXN_CURRENCY_CODE | VARCHAR2 | (30) | ||
BILLABLE_FLAG | VARCHAR2 | (1) | ||
RESOURCE_NAME | VARCHAR2 | (250) | ||
TASK_NAME | VARCHAR2 | (250) | ||
DISPLAY_QUANTITY | NUMBER | |||
RESOURCE_UOM | VARCHAR2 | (30) | ||
RESOURCE_RATE_BASED_FLAG | VARCHAR2 | (1) | ||
NEG_QUANTITY_CHANGE_FLAG | VARCHAR2 | (1) | ||
NEG_RAWCOST_CHANGE_FLAG | VARCHAR2 | (1) | ||
NEG_BURDEN_CHANGE_FALG | VARCHAR2 | (1) | ||
NEG_REVENUE_CHANGE_FLAG | VARCHAR2 | (1) |
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:
|
|
|