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

TABLE: PA.PA_FP_RA_MAP_TMP

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

This is an internal table that is used to store temporary data required during copy actuals/copy from processing. This is a global temporary table.

Temporary Table Details

PA.PA_FP_RA_MAP_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: Tablespace
PCT Free: 10
PCT Used: 40
Columns
Name Datatype Length Mandatory Comments
SOURCE_RES_ASSIGNMENT_ID NUMBER (15)
TARGET_RES_ASSIGNMENT_ID NUMBER (15)
SOURCE_TASK_ID NUMBER (15)
TARGET_TASK_ID NUMBER (15)
RESOURCE_ASSIGNMENT_ID NUMBER (15)
PARENT_ASSIGNMENT_ID NUMBER (15)
UNIT_OF_MEASURE VARCHAR2 (30)
SYSTEM_REFERENCE1 NUMBER

SYSTEM_REFERENCE2 NUMBER

SYSTEM_REFERENCE3 NUMBER

PLANNING_START_DATE DATE

PLANNING_END_DATE DATE

SCHEDULE_START_DATE DATE

SCHEDULE_END_DATE DATE

SYSTEM_REFERENCE4 NUMBER

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT SOURCE_RES_ASSIGNMENT_ID
,      TARGET_RES_ASSIGNMENT_ID
,      SOURCE_TASK_ID
,      TARGET_TASK_ID
,      RESOURCE_ASSIGNMENT_ID
,      PARENT_ASSIGNMENT_ID
,      UNIT_OF_MEASURE
,      SYSTEM_REFERENCE1
,      SYSTEM_REFERENCE2
,      SYSTEM_REFERENCE3
,      PLANNING_START_DATE
,      PLANNING_END_DATE
,      SCHEDULE_START_DATE
,      SCHEDULE_END_DATE
,      SYSTEM_REFERENCE4
FROM PA.PA_FP_RA_MAP_TMP;

Dependencies

[top of page]

PA.PA_FP_RA_MAP_TMP does not reference any database object

PA.PA_FP_RA_MAP_TMP is referenced by following:

SchemaAPPS
SynonymPA_FP_RA_MAP_TMP