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

TABLE: BIC.BIC_MEASURES_ALL

Object Details
Object Name: BIC_MEASURES_ALL
Object Type: TABLE
Owner: BIC
FND Design Data: TableBIC.BIC_MEASURES_ALL
Subobject Name:
Status: VALID


The list of measures will be seeded. The user cannot add to or delete from this list. The measures will be seeded for each operating unit


Storage Details
Tablespace: TablespaceAPPS_TS_SEED
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
BIC_MEASURES_U1 NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnMEASURE_ID
ColumnZD_EDITION_NAME
BIC_MEASURES_U2 NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnMEASURE_CODE
ColumnORG_ID
ColumnZD_EDITION_NAME
Columns
Name Datatype Length Mandatory Comments
MEASURE_ID NUMBER
Yes Measure Identifier
MEASURE_CODE VARCHAR2 (30) Yes Internal code
NAME VARCHAR2 (60) Yes Measure name
ORG_ID NUMBER

Organization identifier
ENABLED_FLAG VARCHAR2 (1) Yes If the user does not want to use this measure, the enable_flag can be set to 'N'
DESCRIPTION VARCHAR2 (240)
Description of Measure
WEIGHT NUMBER

The user can specify the weight for each measure
TIME_UNIT_CODE VARCHAR2 (30)
The time unit code indicates the period (month, quarter etc ) for which the value for this measure is stored in the customer summary table. This will be the same unit for the value range in the measure_buckets table. This is from cs_lookups for lookup_type='BIC_TIME_CODE'
LAST_UPDATE_DATE DATE
Yes Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER
Yes Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Yes Standard who column - date when this row was created.
CREATED_BY NUMBER
Yes Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN NUMBER

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
SECURITY_GROUP_ID NUMBER (15)
Security Group Id
ZD_EDITION_NAME VARCHAR2 (30) Yes
Query Text

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


SELECT MEASURE_ID
,      MEASURE_CODE
,      NAME
,      ORG_ID
,      ENABLED_FLAG
,      DESCRIPTION
,      WEIGHT
,      TIME_UNIT_CODE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      SECURITY_GROUP_ID
,      ZD_EDITION_NAME
FROM BIC.BIC_MEASURES_ALL;

Dependencies

[top of page]

BIC.BIC_MEASURES_ALL does not reference any database object

BIC.BIC_MEASURES_ALL is referenced by following:

SchemaBIC
ViewBIC_MEASURES_ALL#