VIEW: APPS.BIS_CUSTOMIZED_BUCKET_VL

Source

View Text - Preformatted

SELECT BC.ROWID ROW_ID , BC.ID CUSTOMIZATION_ID, B.BUCKET_ID ,B.SHORT_NAME , B.TYPE , 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 , B.UPDATABLE, B.EXPANDABLE, B.DISCONTINUOUS, B.OVERLAPPING, B.UOM, BTL.NAME , 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 ,BTL.DESCRIPTION FROM BIS_BUCKET B , BIS_BUCKET_TL BTL, BIS_BUCKET_CUSTOMIZATIONS BC, BIS_BUCKET_CUSTOMIZATIONS_TL BCTL WHERE B.BUCKET_ID = BTL.BUCKET_ID AND BC.BUCKET_ID = B.BUCKET_ID AND BC.ID = BCTL.ID AND BC.CUSTOMIZED = 'T' AND BTL.LANGUAGE = USERENV('LANG') AND BCTL.LANGUAGE = USERENV('LANG')

View Text - HTML Formatted

SELECT BC.ROWID ROW_ID
, BC.ID CUSTOMIZATION_ID
, B.BUCKET_ID
, B.SHORT_NAME
, B.TYPE
, 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
, B.UPDATABLE
, B.EXPANDABLE
, B.DISCONTINUOUS
, B.OVERLAPPING
, B.UOM
, BTL.NAME
, 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
, BTL.DESCRIPTION
FROM BIS_BUCKET B
, BIS_BUCKET_TL BTL
, BIS_BUCKET_CUSTOMIZATIONS BC
, BIS_BUCKET_CUSTOMIZATIONS_TL BCTL
WHERE B.BUCKET_ID = BTL.BUCKET_ID
AND BC.BUCKET_ID = B.BUCKET_ID
AND BC.ID = BCTL.ID
AND BC.CUSTOMIZED = 'T'
AND BTL.LANGUAGE = USERENV('LANG')
AND BCTL.LANGUAGE = USERENV('LANG')