DBA Data[Home] [Help]

APPS.BSC_SIMULATION_VIEW_PUB dependencies on AK_REGION_ITEMS_VL

Line 81: FROM ak_region_items_vl v

77: SELECT v.attribute_code,
78: v.attribute2,
79: v.attribute3,
80: b.operation|| '('|| b.measure_col || ')' as measure_col
81: FROM ak_region_items_vl v
82: ,bsc_sys_measures b
83: WHERE v.attribute2 =b.short_name
84: AND v.region_code =l_short_name
85: AND v.attribute1 =BSC_SIMULATION_VIEW_PUB.c_MEASURE_NO_TARGET

Line 95: FROM ak_region_items_vl v

91: SELECT v.attribute_code,
92: v.attribute2,
93: v.attribute3,
94: b.measure_col
95: FROM ak_region_items_vl v
96: ,bsc_sys_measures b
97: WHERE v.attribute2 =b.short_name
98: AND v.region_code =l_short_name
99: AND v.attribute1 =BSC_SIMULATION_VIEW_PUB.c_MEASURE_NO_TARGET