VIEW: APPS.BIV_MAINT_LATE_COMP_AGING_V

Source

View Text - Preformatted

SELECT decode(grouping_id( range10_name , range9_name , range8_name , range7_name , range6_name , range5_name , range4_name , range3_name , range2_name , 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( range10_name , range9_name , range8_name , range7_name , range6_name , range5_name , range4_name , range3_name , range2_name , 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 , short_name from BIS_BUCKET_CUSTOMIZATIONS_VL WHERE short_name = 'BIV_MAINT_LATECMPL_AGING' and type = 'BIS_BUCKET_TP1' group by grouping sets ( ( range10_name, range9_name, range8_name , range7_name, range6_name, range5_name , range4_name, range3_name, range2_name , range1_name ) , ( range10_name, range9_name, range8_name , range7_name, range6_name, range5_name , range4_name, range3_name, range2_name ) , ( range10_name, range9_name, range8_name , range7_name, range6_name, range5_name , range4_name, range3_name ) , ( range10_name, range9_name, range8_name , range7_name, range6_name, range5_name , range4_name ) , ( range10_name, range9_name, range8_name , range7_name, range6_name, range5_name ) , ( range10_name, range9_name, range8_name , range7_name, range6_name ) , ( range10_name, range9_name, range8_name , range7_name ) , ( range10_name, range9_name, range8_name ) , ( range10_name, range9_name ) , ( range10_name ) ) , short_name having decode(grouping_id( range10_name , range9_name , range8_name , range7_name , range6_name , range5_name , range4_name , range3_name , range2_name , 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) is not null

View Text - HTML Formatted

SELECT DECODE(GROUPING_ID( RANGE10_NAME
, RANGE9_NAME
, RANGE8_NAME
, RANGE7_NAME
, RANGE6_NAME
, RANGE5_NAME
, RANGE4_NAME
, RANGE3_NAME
, RANGE2_NAME
, 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( RANGE10_NAME
, RANGE9_NAME
, RANGE8_NAME
, RANGE7_NAME
, RANGE6_NAME
, RANGE5_NAME
, RANGE4_NAME
, RANGE3_NAME
, RANGE2_NAME
, 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
, SHORT_NAME
FROM BIS_BUCKET_CUSTOMIZATIONS_VL
WHERE SHORT_NAME = 'BIV_MAINT_LATECMPL_AGING'
AND TYPE = 'BIS_BUCKET_TP1' GROUP BY GROUPING SETS ( ( RANGE10_NAME
, RANGE9_NAME
, RANGE8_NAME
, RANGE7_NAME
, RANGE6_NAME
, RANGE5_NAME
, RANGE4_NAME
, RANGE3_NAME
, RANGE2_NAME
, RANGE1_NAME )
, ( RANGE10_NAME
, RANGE9_NAME
, RANGE8_NAME
, RANGE7_NAME
, RANGE6_NAME
, RANGE5_NAME
, RANGE4_NAME
, RANGE3_NAME
, RANGE2_NAME )
, ( RANGE10_NAME
, RANGE9_NAME
, RANGE8_NAME
, RANGE7_NAME
, RANGE6_NAME
, RANGE5_NAME
, RANGE4_NAME
, RANGE3_NAME )
, ( RANGE10_NAME
, RANGE9_NAME
, RANGE8_NAME
, RANGE7_NAME
, RANGE6_NAME
, RANGE5_NAME
, RANGE4_NAME )
, ( RANGE10_NAME
, RANGE9_NAME
, RANGE8_NAME
, RANGE7_NAME
, RANGE6_NAME
, RANGE5_NAME )
, ( RANGE10_NAME
, RANGE9_NAME
, RANGE8_NAME
, RANGE7_NAME
, RANGE6_NAME )
, ( RANGE10_NAME
, RANGE9_NAME
, RANGE8_NAME
, RANGE7_NAME )
, ( RANGE10_NAME
, RANGE9_NAME
, RANGE8_NAME )
, ( RANGE10_NAME
, RANGE9_NAME )
, ( RANGE10_NAME ) )
, SHORT_NAME HAVING DECODE(GROUPING_ID( RANGE10_NAME
, RANGE9_NAME
, RANGE8_NAME
, RANGE7_NAME
, RANGE6_NAME
, RANGE5_NAME
, RANGE4_NAME
, RANGE3_NAME
, RANGE2_NAME
, 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) IS NOT NULL