1074: 'PRODUCT GROUP', 2,
1075: 'ITEM', 3) prod_value
1076: from bisbv_performance_measures bpm,
1077: bisbv_target_levels btl,
1078: bisbv_dimension_levels tltime,
1079: bisbv_dimension_levels tlorg,
1080: bisbv_dimension_levels tlgeo,
1081: bisbv_dimension_levels tlcat
1082: where bpm.measure_short_name = 'WIPBIUZIND'
1075: 'ITEM', 3) prod_value
1076: from bisbv_performance_measures bpm,
1077: bisbv_target_levels btl,
1078: bisbv_dimension_levels tltime,
1079: bisbv_dimension_levels tlorg,
1080: bisbv_dimension_levels tlgeo,
1081: bisbv_dimension_levels tlcat
1082: where bpm.measure_short_name = 'WIPBIUZIND'
1083: and btl.measure_id = bpm.measure_id
1076: from bisbv_performance_measures bpm,
1077: bisbv_target_levels btl,
1078: bisbv_dimension_levels tltime,
1079: bisbv_dimension_levels tlorg,
1080: bisbv_dimension_levels tlgeo,
1081: bisbv_dimension_levels tlcat
1082: where bpm.measure_short_name = 'WIPBIUZIND'
1083: and btl.measure_id = bpm.measure_id
1084: and btl.time_level_id = tltime.dimension_level_id
1077: bisbv_target_levels btl,
1078: bisbv_dimension_levels tltime,
1079: bisbv_dimension_levels tlorg,
1080: bisbv_dimension_levels tlgeo,
1081: bisbv_dimension_levels tlcat
1082: where bpm.measure_short_name = 'WIPBIUZIND'
1083: and btl.measure_id = bpm.measure_id
1084: and btl.time_level_id = tltime.dimension_level_id
1085: and btl.org_level_id = tlorg.dimension_level_id