eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: PA.PA_FP_RES_ASSIGNMENTS_TMP

Object Details

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

Temporary Table Details

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.

Storage Details

Tablespace:
PCT Free:	10
PCT Used:	40

Indexes

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

Columns

Name	Datatype	Length	Mandatory
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)

Query Text

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;

Dependencies

[top of page]

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