VIEW: APPS.BIV_DR_BKLG_DIST_V

Source

View Text - Preformatted

SELECT id, value, short_name from ( 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') and b.short_name IN ('ISC_DEPOT_BKLG_CMP_AGING', 'ISC_DEPOT_MTTR','ISC_DEPOT_DAYS_UNTIL_PROM') group by b.short_name, 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 ) UNION ALL select to_number( LOOKUP_CODE), meaning, 'ADDITIONAL_VALUES' from fnd_lookups where lookup_type = 'ISC_DEPOT_BACKLOG_DIST'

View Text - HTML Formatted

SELECT ID
, VALUE
, SHORT_NAME
FROM ( 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')
AND B.SHORT_NAME IN ('ISC_DEPOT_BKLG_CMP_AGING'
, 'ISC_DEPOT_MTTR'
, 'ISC_DEPOT_DAYS_UNTIL_PROM') GROUP BY B.SHORT_NAME
, 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 ) UNION ALL SELECT TO_NUMBER( LOOKUP_CODE)
, MEANING
, 'ADDITIONAL_VALUES'
FROM FND_LOOKUPS
WHERE LOOKUP_TYPE = 'ISC_DEPOT_BACKLOG_DIST'