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

TABLE: BIS.BIS_BUCKET

Object Details
Object Name: BIS_BUCKET
Object Type: TABLE
Owner: BIS
FND Design Data: TableBIS.BIS_BUCKET
Subobject Name:
Status: VALID


This table stores the bucket information.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
BIS_BUCKET_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnBUCKET_ID
BIS_BUCKET_U2 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnSHORT_NAME
Columns
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
Query Text

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;

Dependencies

[top of page]

BIS.BIS_BUCKET does not reference any database object

BIS.BIS_BUCKET is referenced by following:

SchemaBIS
ViewBIS_BUCKET#