[Home] [Help] [Dependency Information]
Object Name: | BIS_BUCKET# |
---|---|
Object Type: | VIEW |
Owner: | BIS |
Subobject Name: | |
Status: | VALID |
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 |
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#;
|
|
|