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_CUSTOMIZATIONS

Object Details

Object Name:	BIS_BUCKET_CUSTOMIZATIONS
Object Type:	TABLE
Owner:	BIS
FND Design Data:	BIS.BIS_BUCKET_CUSTOMIZATIONS
Subobject Name:
Status:	VALID

This is a customization table for bis bucket.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
BIS_BUCKET_CUSTOMIZATIONS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	BUCKET_ID USER_ID RESPONSIBILITY_ID ORG_ID APPLICATION_ID SITE_ID PAGE_ID FUNCTION_ID

Columns

Name	Datatype	Length	Mandatory	Comments
ID	NUMBER		Yes	Customization id.
BUCKET_ID	NUMBER		Yes	Bucket id.
USER_ID	NUMBER			User id.
RESPONSIBILITY_ID	NUMBER			Responsibility id.
ORG_ID	NUMBER			Org id.
APPLICATION_ID	NUMBER			Application id.
SITE_ID	NUMBER			Site id.
PAGE_ID	NUMBER			Page id.
FUNCTION_ID	NUMBER			Function id.
RANGE1_LOW	NUMBER			Low range number for bucket1.
RANGE1_HIGH	NUMBER			High range number for bucket1.
RANGE2_LOW	NUMBER			Low range number for bucket2.
RANGE2_HIGH	NUMBER			High range number for bucket2.
RANGE3_LOW	NUMBER			Low range number for bucket3.
RANGE3_HIGH	NUMBER			High range number for bucket3.
RANGE4_LOW	NUMBER			Low range number for bucket4.
RANGE4_HIGH	NUMBER			High range number for bucket4.
RANGE5_LOW	NUMBER			Low range number for bucket5.
RANGE5_HIGH	NUMBER			High range number for bucket5.
RANGE6_LOW	NUMBER			Low range number for bucket6.
RANGE6_HIGH	NUMBER			High range number for bucket6.
RANGE7_LOW	NUMBER			Low range number for bucket7.
RANGE7_HIGH	NUMBER			High range number for bucket7.
RANGE8_LOW	NUMBER			Low range number for bucket8.
RANGE8_HIGH	NUMBER			High range number for bucket8.
RANGE9_LOW	NUMBER			Low range number for bucket9.
RANGE9_HIGH	NUMBER			High range number for bucket9.
RANGE10_LOW	NUMBER			Low range number for bucket10.
RANGE10_HIGH	NUMBER			High range number for bucket10.
CREATED_BY	NUMBER		Yes	Standard who column.
CREATION_DATE	DATE		Yes	Standard who column.
LAST_UPDATED_BY	NUMBER		Yes	Standard who column.
LAST_UPDATE_DATE	DATE		Yes	Standard who column.
LAST_UPDATE_LOGIN	NUMBER			Standard who column.
CUSTOMIZED	VARCHAR2	(1)		Customized

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ID
,      BUCKET_ID
,      USER_ID
,      RESPONSIBILITY_ID
,      ORG_ID
,      APPLICATION_ID
,      SITE_ID
,      PAGE_ID
,      FUNCTION_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
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      CUSTOMIZED
FROM BIS.BIS_BUCKET_CUSTOMIZATIONS;

Dependencies

[top of page]

BIS.BIS_BUCKET_CUSTOMIZATIONS does not reference any database object

BIS.BIS_BUCKET_CUSTOMIZATIONS is referenced by following:

APPS: ASO_BI_DISC_BUK_MV; BIL_BI_PIPEC_WG_MV; BIL_BI_PIPE_MV; BIS_BUCKET_CUSTOMIZATIONS; 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