[Home] [Help] [Dependency Information]

TABLE: FII.EDW_PROJECT_M_TEMP

Object Details

Temporary Table Details

FII.EDW_PROJECT_M_TEMP 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

Columns

Query Text

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

SELECT PTYP_PRJ_TYP_PK_KEY
,      PRJ_PROJECT_PK_KEY
,      TASK_TASK_PK_KEY
,      TTSK_TOP_TASK_PK_KEY
,      ALL_ALL_PK_KEY
,      CLS1_PROJ_CLS1_PK_KEY
,      CLS2_PROJ_CLS2_PK_KEY
,      CLS3_PROJ_CLS3_PK_KEY
,      CLS4_PROJ_CLS4_PK_KEY
,      CLS5_PROJ_CLS5_PK_KEY
,      CLS6_PROJ_CLS6_PK_KEY
,      CLS7_PROJ_CLS7_PK_KEY
,      CTG1_PROJ_CATEG1_PK_KEY
,      CTG2_PROJ_CATEG2_PK_KEY
,      CTG3_PROJ_CATEG3_PK_KEY
,      CTG4_PROJ_CATEG4_PK_KEY
,      CTG5_PROJ_CATEG5_PK_KEY
,      CTG6_PROJ_CATEG6_PK_KEY
,      CTG7_PROJ_CATEG7_PK_KEY
,      PTYP_INSTANCE
,      PTYP_NAME
,      PTYP_PRJ_TYP_PK
,      PTYP_PROJECT_TYPE
,      PTYP_USER_ATTRIBUTE1
,      PTYP_USER_ATTRIBUTE2
,      PTYP_USER_ATTRIBUTE3
,      PTYP_USER_ATTRIBUTE4
,      PTYP_USER_ATTRIBUTE5
,      PRJ_DISTRIBUTION_RULE
,      PRJ_INSTANCE
,      PRJ_NAME
,      PRJ_PROJECT
,      PRJ_PROJECT_MANAGER
,      PRJ_PROJECT_PK
,      PRJ_PROJECT_STATUS_CODE
,      PRJ_PROJECT_NUMBER
,      PRJ_USER_ATTRIBUTE1
,      PRJ_USER_ATTRIBUTE2
,      PRJ_USER_ATTRIBUTE3
,      PRJ_USER_ATTRIBUTE4
,      PRJ_USER_ATTRIBUTE5
,      TASK_INSTANCE
,      TASK_NAME
,      TASK_TASK_NUMBER
,      TASK_SERVICE_TYPE_CODE
,      TASK_TASK
,      TASK_TASK_PK
,      TASK_USER_ATTRIBUTE1
,      TASK_USER_ATTRIBUTE2
,      TASK_USER_ATTRIBUTE3
,      TASK_USER_ATTRIBUTE4
,      TASK_USER_ATTRIBUTE5
,      TTSK_INSTANCE
,      TTSK_LABOR_COST_MULT
,      TTSK_NAME
,      TTSK_TASK_NUMBER
,      TTSK_SERVICE_TYPE_CODE
,      TTSK_TOP_TASK
,      TTSK_TOP_TASK_PK
,      TTSK_USER_ATTRIBUTE1
,      TTSK_USER_ATTRIBUTE2
,      TTSK_USER_ATTRIBUTE3
,      TTSK_USER_ATTRIBUTE4
,      TTSK_USER_ATTRIBUTE5
,      ALL_ALL_PK
,      ALL_NAME
,      CLS1_INSTANCE
,      CLS1_NAME
,      CLS1_PROJECT_CLASS1
,      CLS1_PROJ_CLS1_PK
,      CLS1_USER_ATTRIBUTE1
,      CLS1_USER_ATTRIBUTE2
,      CLS1_USER_ATTRIBUTE3
,      CLS1_USER_ATTRIBUTE4
,      CLS1_USER_ATTRIBUTE5
,      CLS2_INSTANCE
,      CLS2_NAME
,      CLS2_PROJECT_CLASS2
,      CLS2_PROJ_CLS2_PK
,      CLS2_USER_ATTRIBUTE1
,      CLS2_USER_ATTRIBUTE2
,      CLS2_USER_ATTRIBUTE3
,      CLS2_USER_ATTRIBUTE4
,      CLS2_USER_ATTRIBUTE5
,      CLS3_INSTANCE
,      CLS3_NAME
,      CLS3_PROJECT_CLASS3
,      CLS3_PROJ_CLS3_PK
,      CLS3_USER_ATTRIBUTE1
,      CLS3_USER_ATTRIBUTE2
,      CLS3_USER_ATTRIBUTE3
,      CLS3_USER_ATTRIBUTE4
,      CLS3_USER_ATTRIBUTE5
,      CLS4_INSTANCE
,      CLS4_NAME
,      CLS4_PROJECT_CLASS4
,      CLS4_PROJ_CLS4_PK
,      CLS4_USER_ATTRIBUTE1
,      CLS4_USER_ATTRIBUTE2
,      CLS4_USER_ATTRIBUTE3
,      CLS4_USER_ATTRIBUTE4
,      CLS4_USER_ATTRIBUTE5
,      CLS5_INSTANCE
,      CLS5_NAME
,      CLS5_PROJECT_CLASS5
,      CLS5_PROJ_CLS5_PK
,      CLS5_USER_ATTRIBUTE1
,      CLS5_USER_ATTRIBUTE2
,      CLS5_USER_ATTRIBUTE3
,      CLS5_USER_ATTRIBUTE4
,      CLS5_USER_ATTRIBUTE5
,      CLS6_INSTANCE
,      CLS6_NAME
,      CLS6_PROJECT_CLASS6
,      CLS6_PROJ_CLS6_PK
,      CLS6_USER_ATTRIBUTE1
,      CLS6_USER_ATTRIBUTE2
,      CLS6_USER_ATTRIBUTE3
,      CLS6_USER_ATTRIBUTE4
,      CLS6_USER_ATTRIBUTE5
,      CLS7_INSTANCE
,      CLS7_NAME
,      CLS7_PROJECT_CLASS7
,      CLS7_PROJ_CLS7_PK
,      CLS7_USER_ATTRIBUTE1
,      CLS7_USER_ATTRIBUTE2
,      CLS7_USER_ATTRIBUTE3
,      CLS7_USER_ATTRIBUTE4
,      CLS7_USER_ATTRIBUTE5
,      CTG1_INSTANCE
,      CTG1_NAME
,      CTG1_PROJECT_CATEGORY1
,      CTG1_PROJ_CATEG1_PK
,      CTG1_USER_ATTRIBUTE1
,      CTG1_USER_ATTRIBUTE2
,      CTG1_USER_ATTRIBUTE3
,      CTG1_USER_ATTRIBUTE4
,      CTG1_USER_ATTRIBUTE5
,      CTG2_INSTANCE
,      CTG2_NAME
,      CTG2_PROJECT_CATEGORY2
,      CTG2_PROJ_CATEG2_PK
,      CTG2_USER_ATTRIBUTE1
,      CTG2_USER_ATTRIBUTE2
,      CTG2_USER_ATTRIBUTE3
,      CTG2_USER_ATTRIBUTE4
,      CTG2_USER_ATTRIBUTE5
,      CTG3_INSTANCE
,      CTG3_NAME
,      CTG3_PROJECT_CATEGORY3
,      CTG3_PROJ_CATEG3_PK
,      CTG3_USER_ATTRIBUTE1
,      CTG3_USER_ATTRIBUTE2
,      CTG3_USER_ATTRIBUTE3
,      CTG3_USER_ATTRIBUTE4
,      CTG3_USER_ATTRIBUTE5
,      CTG4_INSTANCE
,      CTG4_USER_ATTRIBUTE1
,      CTG4_USER_ATTRIBUTE2
,      CTG4_USER_ATTRIBUTE3
,      CTG4_USER_ATTRIBUTE4
,      CTG4_USER_ATTRIBUTE5
,      CTG4_NAME
,      CTG4_PROJ_CATEG4_PK
,      CTG4_PROJECT_CATEGORY4
,      CTG5_INSTANCE
,      CTG5_NAME
,      CTG5_PROJECT_CATEGORY5
,      CTG5_PROJ_CATEG5_PK
,      CTG5_USER_ATTRIBUTE1
,      CTG5_USER_ATTRIBUTE2
,      CTG5_USER_ATTRIBUTE3
,      CTG5_USER_ATTRIBUTE4
,      CTG5_USER_ATTRIBUTE5
,      CTG6_INSTANCE
,      CTG6_NAME
,      CTG6_PROJECT_CATEGORY6
,      CTG6_PROJ_CATEG6_PK
,      CTG6_USER_ATTRIBUTE1
,      CTG6_USER_ATTRIBUTE2
,      CTG6_USER_ATTRIBUTE3
,      CTG6_USER_ATTRIBUTE4
,      CTG6_USER_ATTRIBUTE5
,      CTG7_INSTANCE
,      CTG7_NAME
,      CTG7_PROJECT_CATEGORY7
,      CTG7_PROJ_CATEG7_PK
,      CTG7_USER_ATTRIBUTE1
,      CTG7_USER_ATTRIBUTE2
,      CTG7_USER_ATTRIBUTE3
,      CTG7_USER_ATTRIBUTE4
,      CTG7_USER_ATTRIBUTE5
,      TASK_TASK_END_DATE
,      TASK_TASK_START_DATE
,      TTSK_TASK_END_DATE
,      TTSK_TASK_START_DATE
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      ROW_ID1
,      ROW_ID2
,      OPERATION_CODE1
,      OPERATION_CODE2
FROM FII.EDW_PROJECT_M_TEMP;

Dependencies

[top of page]

FII.EDW_PROJECT_M_TEMP does not reference any database object

FII.EDW_PROJECT_M_TEMP is referenced by following:

APPS

EDW_PROJECT_M_TEMP