eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: BIS.BIS_BUCKET

Object Details

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.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

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

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:

APPS: ASO_BI_DISC_BUK_MV; BIL_BI_PIPEC_WG_MV; BIL_BI_PIPE_MV; BIS_BUCKET; BIV_CLO_SUM_MV; BIV_RES_SUM_MV; ISC_DBI_CFM_008_MV; ISC_DBI_FM_0000_MV; ISC_DBI_FM_0006_MV; ISC_DR_BKLG_01_MV; ISC_DR_CURR_02_MV; ISC_DR_MTTR_01_MV; ISC_FS_007_MV; ISC_FS_009_MV; ISC_FS_017_MV; ISC_FS_018_MV; ISC_FS_019_MV; ISC_FS_020_MV; ISC_MAINT_003_MV; ISC_MAINT_006_MV; ISC_MAINT_007_MV; OKI_SRM_003_MV; POA_REQ_000_MV; POA_REQ_001_MV; POA_REQ_002_MV