View: BIS_BUCKET_CUSTOMIZATIONS_VL

Product:	BIS - Applications BIS
Description:
Implementation/DBA Data:	APPS.BIS_BUCKET_CUSTOMIZATIONS_VL

View Text

SELECT BC.ID ID
, BC.BUCKET_ID
, BC.USER_ID
, BC.RESPONSIBILITY_ID
, BC.ORG_ID
, BC.APPLICATION_ID
, BC.SITE_ID
, BC.PAGE_ID
, BC.FUNCTION_ID
, BC.RANGE1_LOW
, BC.RANGE1_HIGH
, BC.RANGE2_LOW
, BC.RANGE2_HIGH
, BC.RANGE3_LOW
, BC.RANGE3_HIGH
, BC.RANGE4_LOW
, BC.RANGE4_HIGH
, BC.RANGE5_LOW
, BC.RANGE5_HIGH
, BC.RANGE6_LOW
, BC.RANGE6_HIGH
, BC.RANGE7_LOW
, BC.RANGE7_HIGH
, BC.RANGE8_LOW
, BC.RANGE8_HIGH
, BC.RANGE9_LOW
, BC.RANGE9_HIGH
, BC.RANGE10_LOW
, BC.RANGE10_HIGH
, BC.CREATION_DATE
, BC.CREATED_BY
, BC.LAST_UPDATE_DATE
, BC.LAST_UPDATED_BY
, BC.LAST_UPDATE_LOGIN
, BCTL.RANGE1_NAME
, BCTL.RANGE2_NAME
, BCTL.RANGE3_NAME
, BCTL.RANGE4_NAME
, BCTL.RANGE5_NAME
, BCTL.RANGE6_NAME
, BCTL.RANGE7_NAME
, BCTL.RANGE8_NAME
, BCTL.RANGE9_NAME
, BCTL.RANGE10_NAME
, BC.CUSTOMIZED
, BT.SHORT_NAME
, BT.TYPE
, BT.UPDATABLE
, BT.EXPANDABLE
, BT.DISCONTINUOUS
, BT.OVERLAPPING
, BT.UOM
, BTL.NAME
, BTL.DESCRIPTION
FROM BIS_BUCKET_CUSTOMIZATIONS BC
, BIS_BUCKET_CUSTOMIZATIONS_TL BCTL
, BIS_BUCKET BT
, BIS_BUCKET_TL BTL
WHERE BC.ID = BCTL.ID
AND BT.BUCKET_ID = BTL.BUCKET_ID
AND BC.BUCKET_ID = BT.BUCKET_ID
AND BCTL.LANGUAGE = USERENV('LANG')
AND BTL.LANGUAGE = USERENV('LANG')