VIEW: APPS.BIV_BUCKET_AGING_V

Source

View Text - Preformatted

SELECT decode(grouping_id( t.range10_name , t.range9_name , t.range8_name , t.range7_name , t.range6_name , t.range5_name , t.range4_name , t.range3_name , t.range2_name , t.range1_name ), 0, 1 , 1, 2 , 3, 3 , 7, 4 , 15, 5 , 31, 6 , 63, 7 , 127, 8 , 255, 9 , 10) id , decode(grouping_id( t.range10_name , t.range9_name , t.range8_name , t.range7_name , t.range6_name , t.range5_name , t.range4_name , t.range3_name , t.range2_name , t.range1_name ), 0, range1_name , 1, range2_name , 3, range3_name , 7, range4_name , 15, range5_name , 31, range6_name , 63, range7_name , 127, range8_name , 255, range9_name , range10_name) value , b.short_name from bis_bucket b , bis_bucket_customizations bc , bis_bucket_customizations_tl t WHERE b.bucket_id = bc.bucket_id and bc.id = t.id and t.language = userenv('LANG') group by grouping sets ( ( t.range10_name, t.range9_name, t.range8_name , t.range7_name, t.range6_name, t.range5_name , t.range4_name, t.range3_name, t.range2_name , t.range1_name ) , ( t.range10_name, t.range9_name, t.range8_name , t.range7_name, t.range6_name, t.range5_name , t.range4_name, t.range3_name, t.range2_name ) , ( t.range10_name, t.range9_name, t.range8_name , t.range7_name, t.range6_name, t.range5_name , t.range4_name, t.range3_name ) , ( t.range10_name, t.range9_name, t.range8_name , t.range7_name, t.range6_name, t.range5_name , t.range4_name ) , ( t.range10_name, t.range9_name, t.range8_name , t.range7_name, t.range6_name, t.range5_name ) , ( t.range10_name, t.range9_name, t.range8_name , t.range7_name, t.range6_name ) , ( t.range10_name, t.range9_name, t.range8_name , t.range7_name ) , ( t.range10_name, t.range9_name, t.range8_name ) , ( t.range10_name, t.range9_name ) , ( t.range10_name ) ) , b.short_name having decode(grouping_id( t.range10_name , t.range9_name , t.range8_name , t.range7_name , t.range6_name , t.range5_name , t.range4_name , t.range3_name , t.range2_name , t.range1_name ), 0, t.range1_name , 1, t.range2_name , 3, t.range3_name , 7, t.range4_name , 15, t.range5_name , 31, t.range6_name , 63, t.range7_name , 127, t.range8_name , 255, t.range9_name , t.range10_name) is not null

View Text - HTML Formatted

SELECT DECODE(GROUPING_ID( T.RANGE10_NAME
, T.RANGE9_NAME
, T.RANGE8_NAME
, T.RANGE7_NAME
, T.RANGE6_NAME
, T.RANGE5_NAME
, T.RANGE4_NAME
, T.RANGE3_NAME
, T.RANGE2_NAME
, T.RANGE1_NAME )
, 0
, 1
, 1
, 2
, 3
, 3
, 7
, 4
, 15
, 5
, 31
, 6
, 63
, 7
, 127
, 8
, 255
, 9
, 10) ID
, DECODE(GROUPING_ID( T.RANGE10_NAME
, T.RANGE9_NAME
, T.RANGE8_NAME
, T.RANGE7_NAME
, T.RANGE6_NAME
, T.RANGE5_NAME
, T.RANGE4_NAME
, T.RANGE3_NAME
, T.RANGE2_NAME
, T.RANGE1_NAME )
, 0
, RANGE1_NAME
, 1
, RANGE2_NAME
, 3
, RANGE3_NAME
, 7
, RANGE4_NAME
, 15
, RANGE5_NAME
, 31
, RANGE6_NAME
, 63
, RANGE7_NAME
, 127
, RANGE8_NAME
, 255
, RANGE9_NAME
, RANGE10_NAME) VALUE
, B.SHORT_NAME
FROM BIS_BUCKET B
, BIS_BUCKET_CUSTOMIZATIONS BC
, BIS_BUCKET_CUSTOMIZATIONS_TL T
WHERE B.BUCKET_ID = BC.BUCKET_ID
AND BC.ID = T.ID
AND T.LANGUAGE = USERENV('LANG') GROUP BY GROUPING SETS ( ( T.RANGE10_NAME
, T.RANGE9_NAME
, T.RANGE8_NAME
, T.RANGE7_NAME
, T.RANGE6_NAME
, T.RANGE5_NAME
, T.RANGE4_NAME
, T.RANGE3_NAME
, T.RANGE2_NAME
, T.RANGE1_NAME )
, ( T.RANGE10_NAME
, T.RANGE9_NAME
, T.RANGE8_NAME
, T.RANGE7_NAME
, T.RANGE6_NAME
, T.RANGE5_NAME
, T.RANGE4_NAME
, T.RANGE3_NAME
, T.RANGE2_NAME )
, ( T.RANGE10_NAME
, T.RANGE9_NAME
, T.RANGE8_NAME
, T.RANGE7_NAME
, T.RANGE6_NAME
, T.RANGE5_NAME
, T.RANGE4_NAME
, T.RANGE3_NAME )
, ( T.RANGE10_NAME
, T.RANGE9_NAME
, T.RANGE8_NAME
, T.RANGE7_NAME
, T.RANGE6_NAME
, T.RANGE5_NAME
, T.RANGE4_NAME )
, ( T.RANGE10_NAME
, T.RANGE9_NAME
, T.RANGE8_NAME
, T.RANGE7_NAME
, T.RANGE6_NAME
, T.RANGE5_NAME )
, ( T.RANGE10_NAME
, T.RANGE9_NAME
, T.RANGE8_NAME
, T.RANGE7_NAME
, T.RANGE6_NAME )
, ( T.RANGE10_NAME
, T.RANGE9_NAME
, T.RANGE8_NAME
, T.RANGE7_NAME )
, ( T.RANGE10_NAME
, T.RANGE9_NAME
, T.RANGE8_NAME )
, ( T.RANGE10_NAME
, T.RANGE9_NAME )
, ( T.RANGE10_NAME ) )
, B.SHORT_NAME HAVING DECODE(GROUPING_ID( T.RANGE10_NAME
, T.RANGE9_NAME
, T.RANGE8_NAME
, T.RANGE7_NAME
, T.RANGE6_NAME
, T.RANGE5_NAME
, T.RANGE4_NAME
, T.RANGE3_NAME
, T.RANGE2_NAME
, T.RANGE1_NAME )
, 0
, T.RANGE1_NAME
, 1
, T.RANGE2_NAME
, 3
, T.RANGE3_NAME
, 7
, T.RANGE4_NAME
, 15
, T.RANGE5_NAME
, 31
, T.RANGE6_NAME
, 63
, T.RANGE7_NAME
, 127
, T.RANGE8_NAME
, 255
, T.RANGE9_NAME
, T.RANGE10_NAME) IS NOT NULL