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

VIEW: BIS.BIS_BUCKET#

Object Details
Object Name: BIS_BUCKET#
Object Type: VIEW
Owner: BIS
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
BUCKET_ID NUMBER
Yes
SHORT_NAME VARCHAR2 (30) Yes
TYPE VARCHAR2 (30) Yes
APPLICATION_ID NUMBER
Yes
RANGE1_LOW NUMBER

RANGE1_HIGH NUMBER

RANGE2_LOW NUMBER

RANGE2_HIGH NUMBER

RANGE3_LOW NUMBER

RANGE3_HIGH NUMBER

RANGE4_LOW NUMBER

RANGE4_HIGH NUMBER

RANGE5_LOW NUMBER

RANGE5_HIGH NUMBER

RANGE6_LOW NUMBER

RANGE6_HIGH NUMBER

RANGE7_LOW NUMBER

RANGE7_HIGH NUMBER

RANGE8_LOW NUMBER

RANGE8_HIGH NUMBER

RANGE9_LOW NUMBER

RANGE9_HIGH NUMBER

RANGE10_LOW NUMBER

RANGE10_HIGH NUMBER

UPDATABLE VARCHAR2 (1)
EXPANDABLE VARCHAR2 (1)
DISCONTINUOUS VARCHAR2 (1)
OVERLAPPING VARCHAR2 (1)
UOM VARCHAR2 (10)
CREATION_DATE DATE
Yes
CREATED_BY NUMBER
Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER
Yes
LAST_UPDATE_LOGIN NUMBER

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# references the following:

SchemaBIS
TableBIS_BUCKET
BIS.BIS_BUCKET# is referenced by following:

SchemaAPPS
SynonymBIS_BUCKET