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

TABLE: PJI.PJI_MT_MEASURE_SETS_B

Object Details
Object Name: PJI_MT_MEASURE_SETS_B
Object Type: TABLE
Owner: PJI
FND Design Data: TablePJI.PJI_MT_MEASURE_SETS_B
Subobject Name:
Status: VALID


This table stores information about measure sets used for reporting in Oracle Projects.


Storage Details
Tablespace: TablespaceAPPS_TS_SEED
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
PJI_MT_MEASURE_SETS_B_U1 NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnMEASURE_SET_CODE
Columns
Name Datatype Length Mandatory Comments
MEASURE_SET_CODE VARCHAR2 (30) Yes Measure Set Identifier
MEASURE_SET_TYPE VARCHAR2 (30) Yes Measure Set Type
MEASURE_FORMAT VARCHAR2 (30)
Measure Format
DB_COLUMN_NAME VARCHAR2 (80)
Column in which this measure is stored. This is applicable only for Stored Measures only
OBJECT_VERSION_NUMBER NUMBER (15) Yes Object Version Number
CREATION_DATE DATE
Yes Standard Who Column
LAST_UPDATE_DATE DATE
Yes Standard Who Column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who Column
CREATED_BY NUMBER (15) Yes Standard Who Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who Column
MEASURE_FORMULA VARCHAR2 (2000)
Measure Formula
MEASURE_SOURCE VARCHAR2 (2)
Measure Source (FP/AC)
Query Text

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


SELECT MEASURE_SET_CODE
,      MEASURE_SET_TYPE
,      MEASURE_FORMAT
,      DB_COLUMN_NAME
,      OBJECT_VERSION_NUMBER
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      MEASURE_FORMULA
,      MEASURE_SOURCE
FROM PJI.PJI_MT_MEASURE_SETS_B;

Dependencies

[top of page]

PJI.PJI_MT_MEASURE_SETS_B does not reference any database object

PJI.PJI_MT_MEASURE_SETS_B is referenced by following:

SchemaAPPS
SynonymPJI_MT_MEASURE_SETS_B