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

TABLE: FII.EDW_PROJECT_M

Object Details
Object Name: EDW_PROJECT_M
Object Type: TABLE
Owner: FII
FND Design Data: TableFII.EDW_PROJECT_M
Subobject Name:
Status: VALID


This is the denormalized star table for the Project dimension. It contains records for the lowest level of the Project dimension and its parentage up to the top level, across all hierarchies.


Storage Details
Tablespace: TablespaceAPPS_TS_SUMMARY
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
EDW_PROJECT_M_U1 NORMAL UNIQUE TablespaceAPPS_TS_SUMMARY ColumnTASK_TASK_PK
ColumnTASK_TASK_PK_KEY
EDW_PROJECT_M_U2 NORMAL UNIQUE TablespaceAPPS_TS_SUMMARY ColumnTASK_TASK_PK_KEY
EDW_PROJECT_M_N1 BITMAP NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPTYP_NAME
Columns
Name Datatype Length Mandatory Comments
PTYP_PRJ_TYP_PK_KEY NUMBER

System generated unique identifier for Project Type level
PRJ_PROJECT_PK_KEY NUMBER

System generated unique identifier for Project level
TASK_TASK_PK_KEY NUMBER
Yes System generated unique identifier for Task level
TTSK_TOP_TASK_PK_KEY NUMBER

System generated unique identifier for Top Task level
ALL_ALL_PK_KEY NUMBER

System generated unique identifier for All level
CLS1_PROJ_CLS1_PK_KEY NUMBER

System generated unique identifier for Project Class 1 level
CLS2_PROJ_CLS2_PK_KEY NUMBER

System generated unique identifier for Project Class 2 level
CLS3_PROJ_CLS3_PK_KEY NUMBER

System generated unique identifier for Project Class 3 level
CLS4_PROJ_CLS4_PK_KEY NUMBER

System generated unique identifier for Project Class 4 level
CLS5_PROJ_CLS5_PK_KEY NUMBER

System generated unique identifier for Project Class 5 level
CLS6_PROJ_CLS6_PK_KEY NUMBER

System generated unique identifier for Project Class 6 level
CLS7_PROJ_CLS7_PK_KEY NUMBER

System generated unique identifier for Project Class 7 level
CTG1_PROJ_CATEG1_PK_KEY NUMBER

System generated unique identifier for Project Category 1 level
CTG2_PROJ_CATEG2_PK_KEY NUMBER

System generated unique identifier for Project Category 2 level
CTG3_PROJ_CATEG3_PK_KEY NUMBER

System generated unique identifier for Project Category 3 level
CTG4_PROJ_CATEG4_PK_KEY NUMBER

System generated unique identifier for Project Category 4 level
CTG5_PROJ_CATEG5_PK_KEY NUMBER

System generated unique identifier for Project category 5 level
CTG6_PROJ_CATEG6_PK_KEY NUMBER

System generated unique identifier for Project Category 6 level
CTG7_PROJ_CATEG7_PK_KEY NUMBER

System generated unique identifier for Project Category 7 level
PTYP_INSTANCE VARCHAR2 (40)
Instance identifier
PTYP_NAME VARCHAR2 (2000)
Project Type Name
PTYP_PRJ_TYP_PK VARCHAR2 (80)
The unique identifier for Project Type level
PTYP_PROJECT_TYPE VARCHAR2 (80)
Project Type
PTYP_USER_ATTRIBUTE1 VARCHAR2 (240)
User defined attribute
PTYP_USER_ATTRIBUTE2 VARCHAR2 (240)
User defined attribute
PTYP_USER_ATTRIBUTE3 VARCHAR2 (240)
User defined attribute
PTYP_USER_ATTRIBUTE4 VARCHAR2 (240)
User defined attribute
PTYP_USER_ATTRIBUTE5 VARCHAR2 (240)
User defined attribute
PRJ_DISTRIBUTION_RULE VARCHAR2 (30)
Project Distribution Rule
PRJ_INSTANCE VARCHAR2 (40)
Instance identifier
PRJ_NAME VARCHAR2 (2000)
Project Name
PRJ_PROJECT VARCHAR2 (80)
Project
PRJ_PROJECT_MANAGER VARCHAR2 (80)
Project Manager Name
PRJ_PROJECT_PK VARCHAR2 (80)
The unique identifier for Project level
PRJ_PROJECT_STATUS_CODE VARCHAR2 (30)
Project Status Code
PRJ_USER_ATTRIBUTE1 VARCHAR2 (240)
User defined attribute
PRJ_USER_ATTRIBUTE2 VARCHAR2 (240)
User defined attribute
PRJ_USER_ATTRIBUTE3 VARCHAR2 (240)
User defined attribute
PRJ_USER_ATTRIBUTE4 VARCHAR2 (240)
User defined attribute
PRJ_USER_ATTRIBUTE5 VARCHAR2 (240)
User defined attribute
TASK_INSTANCE VARCHAR2 (240)
Instance identifier
TASK_NAME VARCHAR2 (2000)
Task Name
TASK_SERVICE_TYPE_CODE VARCHAR2 (40)
Task Service Type Code
TASK_TASK VARCHAR2 (80)
Task
TASK_TASK_PK VARCHAR2 (120)
The unique identifier for Task level
TASK_USER_ATTRIBUTE1 VARCHAR2 (240)
User defined attribute
TASK_USER_ATTRIBUTE2 VARCHAR2 (240)
User defined attribute
TASK_USER_ATTRIBUTE3 VARCHAR2 (240)
User defined attribute
TASK_USER_ATTRIBUTE4 VARCHAR2 (240)
User defined attribute
TASK_USER_ATTRIBUTE5 VARCHAR2 (240)
User defined attribute
TTSK_INSTANCE VARCHAR2 (40)
Instance identifier
TTSK_LABOR_COST_MULT VARCHAR2 (40)
Top task labor cost multiplier
TTSK_NAME VARCHAR2 (2000)
Top Task Name
TTSK_SERVICE_TYPE_CODE VARCHAR2 (40)
Top Task Service Type Code
TTSK_TOP_TASK VARCHAR2 (80)
Top Task
TTSK_TOP_TASK_PK VARCHAR2 (120)
The unique identifier for Top Task level
TTSK_USER_ATTRIBUTE1 VARCHAR2 (240)
User defined attribute
TTSK_USER_ATTRIBUTE2 VARCHAR2 (240)
User defined attribute
TTSK_USER_ATTRIBUTE3 VARCHAR2 (240)
User defined attribute
TTSK_USER_ATTRIBUTE4 VARCHAR2 (240)
User defined attribute
TTSK_USER_ATTRIBUTE5 VARCHAR2 (240)
User defined attribute
ALL_ALL_PK VARCHAR2 (40)
The unique identifier for All level
ALL_NAME VARCHAR2 (80)
All level name
CLS1_INSTANCE VARCHAR2 (40)
Instance identifier
CLS1_NAME VARCHAR2 (2000)
Project Class 1 Name
CLS1_PROJECT_CLASS1 VARCHAR2 (80)
Project Class 1
CLS1_PROJ_CLS1_PK VARCHAR2 (120)
The unique identifier for Project Class 1 level
CLS1_USER_ATTRIBUTE1 VARCHAR2 (240)
User defined attribute
CLS1_USER_ATTRIBUTE2 VARCHAR2 (240)
User defined attribute
CLS1_USER_ATTRIBUTE3 VARCHAR2 (240)
User defined attribute
CLS1_USER_ATTRIBUTE4 VARCHAR2 (240)
User defined attribute
CLS1_USER_ATTRIBUTE5 VARCHAR2 (240)
User defined attribute
CLS2_INSTANCE VARCHAR2 (40)
Instance identifier
CLS2_NAME VARCHAR2 (2000)
Project Class 2 Name
CLS2_PROJECT_CLASS2 VARCHAR2 (80)
Project Class 2
CLS2_PROJ_CLS2_PK VARCHAR2 (120)
The unique identifier for Project Class 2 level
CLS2_USER_ATTRIBUTE1 VARCHAR2 (240)
User defined attribute
CLS2_USER_ATTRIBUTE2 VARCHAR2 (240)
User defined attribute
CLS2_USER_ATTRIBUTE3 VARCHAR2 (240)
User defined attribute
CLS2_USER_ATTRIBUTE4 VARCHAR2 (240)
User defined attribute
CLS2_USER_ATTRIBUTE5 VARCHAR2 (240)
User defined attribute
CLS3_INSTANCE VARCHAR2 (40)
Instance identifier
CLS3_NAME VARCHAR2 (2000)
Project Class 3 Name
CLS3_PROJECT_CLASS3 VARCHAR2 (80)
Project Class 3
CLS3_PROJ_CLS3_PK VARCHAR2 (120)
The unique identifier for Project Class 3 level
CLS3_USER_ATTRIBUTE1 VARCHAR2 (240)
User defined attribute
CLS3_USER_ATTRIBUTE2 VARCHAR2 (240)
User defined attribute
CLS3_USER_ATTRIBUTE3 VARCHAR2 (240)
User defined attribute
CLS3_USER_ATTRIBUTE4 VARCHAR2 (240)
User defined attribute
CLS3_USER_ATTRIBUTE5 VARCHAR2 (240)
User defined attribute
CLS4_INSTANCE VARCHAR2 (40)
Instance identifier
CLS4_NAME VARCHAR2 (2000)
Project Class 4 Name
CLS4_PROJECT_CLASS4 VARCHAR2 (80)
Project Class 4
CLS4_PROJ_CLS4_PK VARCHAR2 (120)
The unique identifier for Project Class 4 level
CLS4_USER_ATTRIBUTE1 VARCHAR2 (240)
User defined attribute
CLS4_USER_ATTRIBUTE2 VARCHAR2 (240)
User defined attribute
CLS4_USER_ATTRIBUTE3 VARCHAR2 (240)
User defined attribute
CLS4_USER_ATTRIBUTE4 VARCHAR2 (240)
User defined attribute
CLS4_USER_ATTRIBUTE5 VARCHAR2 (240)
User defined attribute
CLS5_INSTANCE VARCHAR2 (40)
Instance identifier
CLS5_NAME VARCHAR2 (2000)
Project Class 5 Name
CLS5_PROJECT_CLASS5 VARCHAR2 (80)
Project Class 5
CLS5_PROJ_CLS5_PK VARCHAR2 (120)
The unique identifier for Project Class 5 level
CLS5_USER_ATTRIBUTE1 VARCHAR2 (240)
User defined attribute
CLS5_USER_ATTRIBUTE2 VARCHAR2 (240)
User defined attribute
CLS5_USER_ATTRIBUTE3 VARCHAR2 (240)
User defined attribute
CLS5_USER_ATTRIBUTE4 VARCHAR2 (240)
User defined attribute
CLS5_USER_ATTRIBUTE5 VARCHAR2 (240)
User defined attribute
CLS6_INSTANCE VARCHAR2 (40)
Instance identifier
CLS6_NAME VARCHAR2 (2000)
Project Class 6 Name
CLS6_PROJECT_CLASS6 VARCHAR2 (80)
Project Class 6
CLS6_PROJ_CLS6_PK VARCHAR2 (120)
The unique identifier for Project Class 6 level
CLS6_USER_ATTRIBUTE1 VARCHAR2 (240)
User defined attribute
CLS6_USER_ATTRIBUTE2 VARCHAR2 (240)
User defined attribute
CLS6_USER_ATTRIBUTE3 VARCHAR2 (240)
User defined attribute
CLS6_USER_ATTRIBUTE4 VARCHAR2 (240)
User defined attribute
CLS6_USER_ATTRIBUTE5 VARCHAR2 (240)
User defined attribute
CLS7_INSTANCE VARCHAR2 (40)
Instance identifier
CLS7_NAME VARCHAR2 (2000)
Project Class 7 Name
CLS7_PROJECT_CLASS7 VARCHAR2 (80)
Project Class 7
CLS7_PROJ_CLS7_PK VARCHAR2 (120)
The unique identifier for Project Class 7 level
CLS7_USER_ATTRIBUTE1 VARCHAR2 (240)
User defined attribute
CLS7_USER_ATTRIBUTE2 VARCHAR2 (240)
User defined attribute
CLS7_USER_ATTRIBUTE3 VARCHAR2 (240)
User defined attribute
CLS7_USER_ATTRIBUTE4 VARCHAR2 (240)
User defined attribute
CLS7_USER_ATTRIBUTE5 VARCHAR2 (240)
User defined attribute
CTG1_INSTANCE VARCHAR2 (40)
Instance identifier
CTG1_NAME VARCHAR2 (2000)
Project Category 1 Name
CTG1_PROJECT_CATEGORY1 VARCHAR2 (80)
Project Category 1
CTG1_PROJ_CATEG1_PK VARCHAR2 (120)
The unique identifier for Project Category 1 level
CTG1_USER_ATTRIBUTE1 VARCHAR2 (240)
User defined attribute
CTG1_USER_ATTRIBUTE2 VARCHAR2 (240)
User defined attribute
CTG1_USER_ATTRIBUTE3 VARCHAR2 (240)
User defined attribute
CTG1_USER_ATTRIBUTE4 VARCHAR2 (240)
User defined attribute
CTG1_USER_ATTRIBUTE5 VARCHAR2 (240)
User defined attribute
CTG2_INSTANCE VARCHAR2 (40)
Instance identifier
CTG2_NAME VARCHAR2 (2000)
Project Category 2 Name
CTG2_PROJECT_CATEGORY2 VARCHAR2 (80)
Project Category 2
CTG2_PROJ_CATEG2_PK VARCHAR2 (120)
The unique identifier for Project Category 2 level
CTG2_USER_ATTRIBUTE1 VARCHAR2 (240)
User defined attribute
CTG2_USER_ATTRIBUTE2 VARCHAR2 (240)
User defined attribute
CTG2_USER_ATTRIBUTE3 VARCHAR2 (240)
User defined attribute
CTG2_USER_ATTRIBUTE4 VARCHAR2 (240)
User defined attribute
CTG2_USER_ATTRIBUTE5 VARCHAR2 (240)
User defined attribute
CTG3_INSTANCE VARCHAR2 (40)
Instance identifier
CTG3_NAME VARCHAR2 (2000)
Project Category 3 Name
CTG3_PROJECT_CATEGORY3 VARCHAR2 (80)
Project Category 3
CTG3_PROJ_CATEG3_PK VARCHAR2 (120)
The unique identifier for Project Category 3 level
CTG3_USER_ATTRIBUTE1 VARCHAR2 (240)
User defined attribute
CTG3_USER_ATTRIBUTE2 VARCHAR2 (240)
User defined attribute
CTG3_USER_ATTRIBUTE3 VARCHAR2 (240)
User defined attribute
CTG3_USER_ATTRIBUTE4 VARCHAR2 (240)
User defined attribute
CTG3_USER_ATTRIBUTE5 VARCHAR2 (240)
User defined attribute
CTG4_INSTANCE VARCHAR2 (40)
Instance identifier
CTG4_NAME VARCHAR2 (2000)
Project Category 4 Name
CTG4_PROJECT_CATEGORY4 VARCHAR2 (80)
Project Category 4
CTG4_PROJ_CATEG4_PK VARCHAR2 (120)
The unique identifier for Project Category 4 level
CTG4_USER_ATTRIBUTE1 VARCHAR2 (240)
User defined attribute
CTG4_USER_ATTRIBUTE2 VARCHAR2 (240)
User defined attribute
CTG4_USER_ATTRIBUTE3 VARCHAR2 (240)
User defined attribute
CTG4_USER_ATTRIBUTE4 VARCHAR2 (240)
User defined attribute
CTG4_USER_ATTRIBUTE5 VARCHAR2 (240)
User defined attribute
CTG5_INSTANCE VARCHAR2 (40)
Instance identifier
CTG5_NAME VARCHAR2 (2000)
Project Category 5 Name
CTG5_PROJECT_CATEGORY5 VARCHAR2 (80)
Project Category 5
CTG5_PROJ_CATEG5_PK VARCHAR2 (120)
The unique identifier for Project Category 5 level
CTG5_USER_ATTRIBUTE1 VARCHAR2 (240)
User defined attribute
CTG5_USER_ATTRIBUTE2 VARCHAR2 (240)
User defined attribute
CTG5_USER_ATTRIBUTE3 VARCHAR2 (240)
User defined attribute
CTG5_USER_ATTRIBUTE4 VARCHAR2 (240)
User defined attribute
CTG5_USER_ATTRIBUTE5 VARCHAR2 (240)
User defined attribute
CTG6_INSTANCE VARCHAR2 (40)
Instance identifier
CTG6_NAME VARCHAR2 (2000)
Project Category 6 Name
CTG6_PROJECT_CATEGORY6 VARCHAR2 (80)
Project Category 6
CTG6_PROJ_CATEG6_PK VARCHAR2 (120)
The unique identifier Project Category 6 level
CTG6_USER_ATTRIBUTE1 VARCHAR2 (240)
User defined attribute
CTG6_USER_ATTRIBUTE2 VARCHAR2 (240)
User defined attribute
CTG6_USER_ATTRIBUTE3 VARCHAR2 (240)
User defined attribute
CTG6_USER_ATTRIBUTE4 VARCHAR2 (240)
User defined attribute
CTG6_USER_ATTRIBUTE5 VARCHAR2 (240)
User defined attribute
CTG7_INSTANCE VARCHAR2 (40)
Instance identifier
CTG7_NAME VARCHAR2 (2000)
Project Category 7 Name
CTG7_PROJECT_CATEGORY7 VARCHAR2 (80)
Project Category 7
CTG7_PROJ_CATEG7_PK VARCHAR2 (120)
The unique identifier for Project Category 7 level
CTG7_USER_ATTRIBUTE1 VARCHAR2 (240)
User defined attribute
CTG7_USER_ATTRIBUTE2 VARCHAR2 (240)
User defined attribute
CTG7_USER_ATTRIBUTE3 VARCHAR2 (240)
User defined attribute
CTG7_USER_ATTRIBUTE4 VARCHAR2 (240)
User defined attribute
CTG7_USER_ATTRIBUTE5 VARCHAR2 (240)
User defined attribute
TASK_TASK_END_DATE DATE

Task End Date
TASK_TASK_START_DATE DATE

Task Start Date
TTSK_TASK_END_DATE DATE

Top Task End Date
TTSK_TASK_START_DATE DATE

Top Task Start Date
PRJ_PROJECT_NUMBER VARCHAR2 (60)
Project Number
TASK_TASK_NUMBER VARCHAR2 (60)
Task Number
TTSK_TASK_NUMBER VARCHAR2 (60)
Top Task Number
CREATION_DATE DATE
Yes Standard who column - date when this row was created.
LAST_UPDATE_DATE DATE
Yes Standard Who column - date when a user last updated this row.
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_USER_ATTRIBUTE1
,      PRJ_USER_ATTRIBUTE2
,      PRJ_USER_ATTRIBUTE3
,      PRJ_USER_ATTRIBUTE4
,      PRJ_USER_ATTRIBUTE5
,      TASK_INSTANCE
,      TASK_NAME
,      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_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_NAME
,      CTG4_PROJECT_CATEGORY4
,      CTG4_PROJ_CATEG4_PK
,      CTG4_USER_ATTRIBUTE1
,      CTG4_USER_ATTRIBUTE2
,      CTG4_USER_ATTRIBUTE3
,      CTG4_USER_ATTRIBUTE4
,      CTG4_USER_ATTRIBUTE5
,      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
,      PRJ_PROJECT_NUMBER
,      TASK_TASK_NUMBER
,      TTSK_TASK_NUMBER
,      CREATION_DATE
,      LAST_UPDATE_DATE
FROM FII.EDW_PROJECT_M;

Dependencies

[top of page]

FII.EDW_PROJECT_M does not reference any database object

FII.EDW_PROJECT_M is referenced by following:

SchemaAPPS
SynonymEDW_PROJECT_M