VIEW: APPS.BIS_BUCKET_CUSTOMIZATIONS_VL

Source

View Text - Preformatted

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')
   

View Text - HTML Formatted

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')