VIEW: APPS.BIV_FS_TRVL_DIST_VAR_LVL_V

Source

View Text - Preformatted

SELECT decode(grouping_id( range1_name , range2_name , range3_name , range4_name , range5_name , range6_name , range7_name , range8_name , range9_name , range10_name ), 511, 1 , 255, 2 , 127, 3 , 63, 4 , 31, 5 , 15, 6 , 7, 7 , 3, 8 , 1, 9 , 10 ) id , decode(grouping_id( range1_name , range2_name , range3_name , range4_name , range5_name , range6_name , range7_name , range8_name , range9_name , range10_name ), 511, range1_name , 255, range2_name , 127, range3_name , 63, range4_name , 31, range5_name , 15, range6_name , 7, range7_name , 3, range8_name , 1, range9_name , range10_name ) value , short_name from bis_bucket_customizations_vl WHERE short_name = 'BIV_FS_TRVL_DIST_VAR' group by range1_name , rollup( range2_name , range3_name , range4_name , range5_name , range6_name , range7_name , range8_name , range9_name , range10_name ) , short_name having decode(grouping_id( range1_name , range2_name , range3_name , range4_name , range5_name , range6_name , range7_name , range8_name , range9_name , range10_name ), 511, range1_name , 255, range2_name , 127, range3_name , 63, range4_name , 31, range5_name , 15, range6_name , 7, range7_name , 3, range8_name , 1, range9_name , range10_name ) is not null

View Text - HTML Formatted

SELECT DECODE(GROUPING_ID( RANGE1_NAME
, RANGE2_NAME
, RANGE3_NAME
, RANGE4_NAME
, RANGE5_NAME
, RANGE6_NAME
, RANGE7_NAME
, RANGE8_NAME
, RANGE9_NAME
, RANGE10_NAME )
, 511
, 1
, 255
, 2
, 127
, 3
, 63
, 4
, 31
, 5
, 15
, 6
, 7
, 7
, 3
, 8
, 1
, 9
, 10 ) ID
, DECODE(GROUPING_ID( RANGE1_NAME
, RANGE2_NAME
, RANGE3_NAME
, RANGE4_NAME
, RANGE5_NAME
, RANGE6_NAME
, RANGE7_NAME
, RANGE8_NAME
, RANGE9_NAME
, RANGE10_NAME )
, 511
, RANGE1_NAME
, 255
, RANGE2_NAME
, 127
, RANGE3_NAME
, 63
, RANGE4_NAME
, 31
, RANGE5_NAME
, 15
, RANGE6_NAME
, 7
, RANGE7_NAME
, 3
, RANGE8_NAME
, 1
, RANGE9_NAME
, RANGE10_NAME ) VALUE
, SHORT_NAME
FROM BIS_BUCKET_CUSTOMIZATIONS_VL
WHERE SHORT_NAME = 'BIV_FS_TRVL_DIST_VAR' GROUP BY RANGE1_NAME
, ROLLUP( RANGE2_NAME
, RANGE3_NAME
, RANGE4_NAME
, RANGE5_NAME
, RANGE6_NAME
, RANGE7_NAME
, RANGE8_NAME
, RANGE9_NAME
, RANGE10_NAME )
, SHORT_NAME HAVING DECODE(GROUPING_ID( RANGE1_NAME
, RANGE2_NAME
, RANGE3_NAME
, RANGE4_NAME
, RANGE5_NAME
, RANGE6_NAME
, RANGE7_NAME
, RANGE8_NAME
, RANGE9_NAME
, RANGE10_NAME )
, 511
, RANGE1_NAME
, 255
, RANGE2_NAME
, 127
, RANGE3_NAME
, 63
, RANGE4_NAME
, 31
, RANGE5_NAME
, 15
, RANGE6_NAME
, 7
, RANGE7_NAME
, 3
, RANGE8_NAME
, 1
, RANGE9_NAME
, RANGE10_NAME ) IS NOT NULL