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

TABLE: GHG.GHG_KPI_DEFINITIONS_ALL

Object Details
Object Name: GHG_KPI_DEFINITIONS_ALL
Object Type: TABLE
Owner: GHG
FND Design Data: TableGHG.GHG_KPI_DEFINITIONS_ALL
Subobject Name:
Status: VALID


This table stores the KPI definitions


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
KPI_ID NUMBER
Yes KPI Identifier
KPI_CODE VARCHAR2 (60) Yes KPI Code
DESCRIPTION VARCHAR2 (255)
Description
NUM_TYPE VARCHAR2 (50) Yes Numerator Type
NUM_FUNCTION VARCHAR2 (25) Yes Numerator Function
DEN_TYPE VARCHAR2 (50) Yes Denominator Type
DEN_FUNCTION VARCHAR2 (25) Yes Denominator Function
CREATED_BY NUMBER

Standard Who Column
CREATION_DATE DATE

Standard Who Column
LAST_UPDATED_BY NUMBER
Yes Standard Who Column
LAST_UPDATE_DATE DATE
Yes Standard Who Column
LAST_UPDATE_LOGIN NUMBER

Standard Who Column
ORG_ID NUMBER

Organization Identifier
NUM_UOM_CLASS_CODE#1 VARCHAR2 (100)
Numerator UOM Classification Code
DEN_UOM_CLASS_CODE#1 VARCHAR2 (100)
Denominator UOM Classification Code
Query Text

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


SELECT KPI_ID
,      KPI_CODE
,      DESCRIPTION
,      NUM_TYPE
,      NUM_FUNCTION
,      DEN_TYPE
,      DEN_FUNCTION
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      ORG_ID
,      NUM_UOM_CLASS_CODE#1
,      DEN_UOM_CLASS_CODE#1
FROM GHG.GHG_KPI_DEFINITIONS_ALL;

Dependencies

[top of page]

GHG.GHG_KPI_DEFINITIONS_ALL does not reference any database object

GHG.GHG_KPI_DEFINITIONS_ALL is referenced by following:

SchemaGHG
ViewGHG_KPI_DEFINITIONS_ALL#