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

TABLE: PA.PA_WORK_PATTERN_TEMP_TABLE

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

This is an internal table that is used to store temporary data required for PJR Weekly Schedule

Temporary Table Details

PA.PA_WORK_PATTERN_TEMP_TABLE 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
Columns
Name Datatype Length Mandatory Comments
PROJECT_ID NUMBER (15)
PROJECT_NAME VARCHAR2 (30)
ASSIGNMENT_NAME VARCHAR2 (80)
START_DATE DATE

END_DATE DATE

STATUS_NAME VARCHAR2 (80)
ASSIGNMENT_ID NUMBER (15)
RESOURCE_ID NUMBER (15)
STATUS_CODE VARCHAR2 (30)
RECORD_VERSION_NUMBER NUMBER (15)
ASSIGNMENT_TYPE VARCHAR2 (30)
CALENDAR_ID NUMBER (15)
CALENDAR_TYPE VARCHAR2 (30)
PROJECT_ROLE_NAME VARCHAR2 (80)
APPRVL_STATUS_NAME VARCHAR2 (80)
ASSIGNMENT_EFFORT NUMBER

ASSIGNMENT_DURATION NUMBER

PROJECT_SYSTEM_STATUS_CODE VARCHAR2 (30)
DAY1 DATE

DAY2 DATE

DAY3 DATE

DAY4 DATE

DAY5 DATE

DAY6 DATE

DAY7 DATE

DAY8 DATE

DAY9 DATE

DAY10 DATE

DAY11 DATE

DAY12 DATE

DAY13 DATE

DAY14 DATE

QTY1 NUMBER

QTY2 NUMBER

QTY3 NUMBER

QTY4 NUMBER

QTY5 NUMBER

QTY6 NUMBER

QTY7 NUMBER

QTY8 NUMBER

QTY9 NUMBER

QTY10 NUMBER

QTY11 NUMBER

QTY12 NUMBER

QTY13 NUMBER

QTY14 NUMBER

ROW_TYPE_CODE NUMBER

READ_ONLY_FLAG NUMBER

Query Text

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


SELECT PROJECT_ID
,      PROJECT_NAME
,      ASSIGNMENT_NAME
,      START_DATE
,      END_DATE
,      STATUS_NAME
,      ASSIGNMENT_ID
,      RESOURCE_ID
,      STATUS_CODE
,      RECORD_VERSION_NUMBER
,      ASSIGNMENT_TYPE
,      CALENDAR_ID
,      CALENDAR_TYPE
,      PROJECT_ROLE_NAME
,      APPRVL_STATUS_NAME
,      ASSIGNMENT_EFFORT
,      ASSIGNMENT_DURATION
,      PROJECT_SYSTEM_STATUS_CODE
,      DAY1
,      DAY2
,      DAY3
,      DAY4
,      DAY5
,      DAY6
,      DAY7
,      DAY8
,      DAY9
,      DAY10
,      DAY11
,      DAY12
,      DAY13
,      DAY14
,      QTY1
,      QTY2
,      QTY3
,      QTY4
,      QTY5
,      QTY6
,      QTY7
,      QTY8
,      QTY9
,      QTY10
,      QTY11
,      QTY12
,      QTY13
,      QTY14
,      ROW_TYPE_CODE
,      READ_ONLY_FLAG
FROM PA.PA_WORK_PATTERN_TEMP_TABLE;

Dependencies

[top of page]

PA.PA_WORK_PATTERN_TEMP_TABLE does not reference any database object

PA.PA_WORK_PATTERN_TEMP_TABLE is referenced by following:

SchemaAPPS
SynonymPA_WORK_PATTERN_TEMP_TABLE