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

TABLE: PA.PA_FP_CALC_AMT_TMP1

Object Details
Object Name: PA_FP_CALC_AMT_TMP1
Object Type: TABLE
Owner: PA
Subobject Name:
Status: VALID

Temporary Table Details

PA.PA_FP_CALC_AMT_TMP1 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: Tablespace
PCT Free: 10
PCT Used: 40
Indexes
Index Type Uniqueness Tablespace Column
PA_FP_CALC_AMT_TMP1_N1 NORMAL NONUNIQUE Tablespace ColumnTARGET_RES_ASG_ID
PA_FP_CALC_AMT_TMP1_N2 NORMAL NONUNIQUE Tablespace ColumnRESOURCE_ASSIGNMENT_ID
PA_FP_CALC_AMT_TMP1_N3 NORMAL NONUNIQUE Tablespace ColumnMAPPED_FIN_TASK_ID
ColumnTARGET_RLM_ID
Columns
Name Datatype Length Mandatory Comments
RESOURCE_ASSIGNMENT_ID NUMBER (15)
BUDGET_VERSION_ID NUMBER (15)
PROJECT_ID NUMBER (15)
TASK_ID NUMBER (15)
RESOURCE_LIST_MEMBER_ID NUMBER (15)
UNIT_OF_MEASURE VARCHAR2 (30)
TRACK_AS_LABOR_FLAG VARCHAR2 (1)
RESOURCE_ASSIGNMENT_TYPE VARCHAR2 (30)
PLANNING_START_DATE DATE

PLANNING_END_DATE DATE

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)
PROJECT_ROLE_ID NUMBER (15)
PERSON_TYPE_CODE VARCHAR2 (30)
NON_LABOR_RESOURCE VARCHAR2 (20)
BOM_RESOURCE_ID NUMBER (15)
INVENTORY_ITEM_ID NUMBER (15)
ITEM_CATEGORY_ID NUMBER (15)
COST_IND_COMPILED_SET_ID NUMBER (15)
BILLABLE_PERCENT NUMBER

TRANSACTION_SOURCE_CODE VARCHAR2 (30)
MFC_COST_TYPE_ID NUMBER (15)
PROCURE_RESOURCE_FLAG VARCHAR2 (1)
INCURRED_BY_RES_FLAG VARCHAR2 (1)
RATE_JOB_ID NUMBER (15)
RATE_ORGANIZATION_ID NUMBER (15)
RATE_EXPENDITURE_TYPE VARCHAR2 (30)
TA_DISPLAY_FLAG VARCHAR2 (1)
RATE_BASED_FLAG VARCHAR2 (1)
USE_TASK_SCHEDULE_FLAG VARCHAR2 (1)
RATE_EXP_FUNC_CURR_CODE VARCHAR2 (30)
RATE_INCURRED_BY_ORGANZ_ID NUMBER (15)
RATE_OVERRIDE_TO_ORGANZ_ID NUMBER (15)
RATE_EXPENDITURE_ORG_ID NUMBER (15)
INCUR_BY_RES_CLASS_CODE VARCHAR2 (30)
INCUR_BY_ROLE_ID NUMBER (15)
RESOURCE_CLASS_FLAG VARCHAR2 (1)
NAMED_ROLE VARCHAR2 (80)
ETC_METHOD_CODE VARCHAR2 (30)
TARGET_RLM_ID NUMBER (15)
TARGET_RES_ASG_ID NUMBER (15)
TOP_TASK_ID NUMBER (15)
MAPPED_FIN_TASK_ID NUMBER (15)
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
FROM PA.PA_FP_CALC_AMT_TMP1;

Dependencies

[top of page]

PA.PA_FP_CALC_AMT_TMP1 does not reference any database object

PA.PA_FP_CALC_AMT_TMP1 is referenced by following:

SchemaAPPS
SynonymPA_FP_CALC_AMT_TMP1