[Home] [Help] [Dependency Information]

TABLE: PA.PA_FP_CALC_AMT_TMP1_1

Object Details

Object Name:	PA_FP_CALC_AMT_TMP1_1
Object Type:	TABLE
Owner:	PA
FND Design Data:	PA.PA_FP_CALC_AMT_TMP1_1
Subobject Name:
Status:	VALID

Temporary Table Details

PA.PA_FP_CALC_AMT_TMP1_1 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$TRANSACTION. 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_CALC_AMT_TMP1_N1	NORMAL	NONUNIQUE		TARGET_RES_ASG_ID
PA_FP_CALC_AMT_TMP1_N2	NORMAL	NONUNIQUE		RESOURCE_ASSIGNMENT_ID
PA_FP_CALC_AMT_TMP1_N3	NORMAL	NONUNIQUE		MAPPED_FIN_TASK_ID TARGET_RLM_ID

Columns

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
,      TRACK_AS_LABOR_FLAG
,      RESOURCE_ASSIGNMENT_TYPE
,      PLANNING_START_DATE
,      PLANNING_END_DATE
,      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
,      PROJECT_ROLE_ID
,      PERSON_TYPE_CODE
,      NON_LABOR_RESOURCE
,      BOM_RESOURCE_ID
,      INVENTORY_ITEM_ID
,      ITEM_CATEGORY_ID
,      COST_IND_COMPILED_SET_ID
,      BILLABLE_PERCENT
,      TRANSACTION_SOURCE_CODE
,      MFC_COST_TYPE_ID
,      PROCURE_RESOURCE_FLAG
,      INCURRED_BY_RES_FLAG
,      RATE_JOB_ID
,      RATE_ORGANIZATION_ID
,      RATE_EXPENDITURE_TYPE
,      TA_DISPLAY_FLAG
,      RATE_BASED_FLAG
,      USE_TASK_SCHEDULE_FLAG
,      RATE_EXP_FUNC_CURR_CODE
,      RATE_INCURRED_BY_ORGANZ_ID
,      RATE_OVERRIDE_TO_ORGANZ_ID
,      RATE_EXPENDITURE_ORG_ID
,      INCUR_BY_RES_CLASS_CODE
,      INCUR_BY_ROLE_ID
,      RESOURCE_CLASS_FLAG
,      NAMED_ROLE
,      ETC_METHOD_CODE
,      TARGET_RLM_ID
,      TARGET_RES_ASG_ID
,      TOP_TASK_ID
,      MAPPED_FIN_TASK_ID
,      CBS_ELEMENT_ID
FROM PA.PA_FP_CALC_AMT_TMP1_1;

Dependencies

[top of page]

PA.PA_FP_CALC_AMT_TMP1_1 does not reference any database object

PA.PA_FP_CALC_AMT_TMP1_1 is referenced by following:

APPS

PA_FP_CALC_AMT_TMP1_1