[Home] [Help] [Dependency Information]
Object Name: | BIS_BUCKET |
---|---|
Object Type: | TABLE |
Owner: | BIS |
FND Design Data: | BIS.BIS_BUCKET |
Subobject Name: | |
Status: | VALID |
This table stores the bucket information.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
BIS_BUCKET_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | BUCKET_ID |
BIS_BUCKET_U2 | NORMAL | UNIQUE | APPS_TS_TX_IDX | SHORT_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
BUCKET_ID | NUMBER | Yes | The Bucket ID | |
SHORT_NAME | VARCHAR2 | (30) | Yes | The Bucket Short Name |
TYPE | VARCHAR2 | (30) | Yes | The Bucket Type |
APPLICATION_ID | NUMBER | Yes | The Application ID | |
RANGE1_LOW | NUMBER | Bucket Value | ||
RANGE1_HIGH | NUMBER | Bucket Value | ||
RANGE2_LOW | NUMBER | Bucket Value | ||
RANGE2_HIGH | NUMBER | Bucket Value | ||
RANGE3_LOW | NUMBER | Bucket Value | ||
RANGE3_HIGH | NUMBER | Bucket Value | ||
RANGE4_LOW | NUMBER | Bucket Value | ||
RANGE4_HIGH | NUMBER | Bucket Value | ||
RANGE5_LOW | NUMBER | Bucket Value | ||
RANGE5_HIGH | NUMBER | Bucket Value | ||
RANGE6_LOW | NUMBER | Bucket Value | ||
RANGE6_HIGH | NUMBER | Bucket Value | ||
RANGE7_LOW | NUMBER | Bucket Value | ||
RANGE7_HIGH | NUMBER | Bucket Value | ||
RANGE8_LOW | NUMBER | Bucket Value | ||
RANGE8_HIGH | NUMBER | Bucket Value | ||
RANGE9_LOW | NUMBER | Bucket Value | ||
RANGE9_HIGH | NUMBER | Bucket Value | ||
RANGE10_LOW | NUMBER | Bucket Value | ||
RANGE10_HIGH | NUMBER | Bucket Value | ||
UPDATABLE | VARCHAR2 | (1) | Updatable Flag(T/F) | |
EXPANDABLE | VARCHAR2 | (1) | Expandable Flag(T/F) | |
DISCONTINUOUS | VARCHAR2 | (1) | Discontinuous Flag(T/F) | |
OVERLAPPING | VARCHAR2 | (1) | Overlapping Flag(T/F) | |
UOM | VARCHAR2 | (10) | Unit of Measure | |
CREATION_DATE | DATE | Yes | The Creation Date | |
CREATED_BY | NUMBER | Yes | The Created By Column | |
LAST_UPDATE_DATE | DATE | Yes | Last Update Date Column | |
LAST_UPDATED_BY | NUMBER | Yes | The Updated By Column | |
LAST_UPDATE_LOGIN | NUMBER | Last Update Login Column |
Cut, paste (and edit) the following text to query this object:
SELECT BUCKET_ID
, SHORT_NAME
, TYPE
, APPLICATION_ID
, RANGE1_LOW
, RANGE1_HIGH
, RANGE2_LOW
, RANGE2_HIGH
, RANGE3_LOW
, RANGE3_HIGH
, RANGE4_LOW
, RANGE4_HIGH
, RANGE5_LOW
, RANGE5_HIGH
, RANGE6_LOW
, RANGE6_HIGH
, RANGE7_LOW
, RANGE7_HIGH
, RANGE8_LOW
, RANGE8_HIGH
, RANGE9_LOW
, RANGE9_HIGH
, RANGE10_LOW
, RANGE10_HIGH
, UPDATABLE
, EXPANDABLE
, DISCONTINUOUS
, OVERLAPPING
, UOM
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
FROM BIS.BIS_BUCKET;
BIS.BIS_BUCKET does not reference any database object
BIS.BIS_BUCKET is referenced by following:
|
|
|