eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BSC_SIMULATION_VIEW_PVT dependencies on BIS_INDICATORS

Line 98: l_Actual_Data_Source BIS_INDICATORS.ACTUAL_DATA_SOURCE%TYPE;

94: )RETURN NUMBER IS
95:
96: l_attribute_code AK_REGION_ITEMS_VL.attribute_code%TYPE;
97: l_region_Code AK_REGION_ITEMS_VL.region_code%TYPE;
98: l_Actual_Data_Source BIS_INDICATORS.ACTUAL_DATA_SOURCE%TYPE;
99: l_short_name AK_REGION_ITEMS_VL.attribute2%TYPE;
100: l_dataset_id BSC_SYS_DATASETS_VL.dataset_id%TYPE;
101: BEGIN
102: SELECT short_name

Line 111: ,bis_indicators dat

107:
108: SELECT dat.dataset_id
109: INTO l_dataset_id
110: FROM ak_region_items_vl ak
111: ,bis_indicators dat
112: WHERE dat.short_name = ak.attribute2
113: AND ak.region_code =l_region_Code
114: AND ak.attribute1 ='MEASURE_NOTARGET'
115: AND ak.attribute_code = p_attribute_code;

Line 579: l_type BIS_INDICATORS.measure_type%TYPE;

575: l_Table_Number NUMBER;
576: l_kpi_metadata_tables BSC_DESIGNER_PVT.t_kpi_metadata_tables;
577: l_count NUMBER;
578: l_link_id NUMBER;
579: l_type BIS_INDICATORS.measure_type%TYPE;
580: l_short_name BIS_INDICATORS.short_name%TYPE;
581: l_attribute_code AK_REGION_ITEMS_VL.attribute_code%TYPE;
582: l_region_Code AK_REGION_ITEMS_VL.region_code%TYPE;
583: l_Actual_Data_Source BIS_INDICATORS.actual_data_source%TYPE;

Line 580: l_short_name BIS_INDICATORS.short_name%TYPE;

576: l_kpi_metadata_tables BSC_DESIGNER_PVT.t_kpi_metadata_tables;
577: l_count NUMBER;
578: l_link_id NUMBER;
579: l_type BIS_INDICATORS.measure_type%TYPE;
580: l_short_name BIS_INDICATORS.short_name%TYPE;
581: l_attribute_code AK_REGION_ITEMS_VL.attribute_code%TYPE;
582: l_region_Code AK_REGION_ITEMS_VL.region_code%TYPE;
583: l_Actual_Data_Source BIS_INDICATORS.actual_data_source%TYPE;
584: l_dataset_id BIS_INDICATORS.dataset_id%TYPE;

Line 583: l_Actual_Data_Source BIS_INDICATORS.actual_data_source%TYPE;

579: l_type BIS_INDICATORS.measure_type%TYPE;
580: l_short_name BIS_INDICATORS.short_name%TYPE;
581: l_attribute_code AK_REGION_ITEMS_VL.attribute_code%TYPE;
582: l_region_Code AK_REGION_ITEMS_VL.region_code%TYPE;
583: l_Actual_Data_Source BIS_INDICATORS.actual_data_source%TYPE;
584: l_dataset_id BIS_INDICATORS.dataset_id%TYPE;
585: l_node_id BIS_INDICATORS.dataset_id%TYPE;
586:
587: CURSOR c_cust_labels IS

Line 584: l_dataset_id BIS_INDICATORS.dataset_id%TYPE;

580: l_short_name BIS_INDICATORS.short_name%TYPE;
581: l_attribute_code AK_REGION_ITEMS_VL.attribute_code%TYPE;
582: l_region_Code AK_REGION_ITEMS_VL.region_code%TYPE;
583: l_Actual_Data_Source BIS_INDICATORS.actual_data_source%TYPE;
584: l_dataset_id BIS_INDICATORS.dataset_id%TYPE;
585: l_node_id BIS_INDICATORS.dataset_id%TYPE;
586:
587: CURSOR c_cust_labels IS
588: SELECT DISTINCT link_id

Line 585: l_node_id BIS_INDICATORS.dataset_id%TYPE;

581: l_attribute_code AK_REGION_ITEMS_VL.attribute_code%TYPE;
582: l_region_Code AK_REGION_ITEMS_VL.region_code%TYPE;
583: l_Actual_Data_Source BIS_INDICATORS.actual_data_source%TYPE;
584: l_dataset_id BIS_INDICATORS.dataset_id%TYPE;
585: l_node_id BIS_INDICATORS.dataset_id%TYPE;
586:
587: CURSOR c_cust_labels IS
588: SELECT DISTINCT link_id
589: FROM bsc_tab_view_labels_vl

Line 644: FROM bis_indicators

640: l_link_id := cd.link_id;
641:
642: SELECT measure_type,actual_data_source
643: INTO l_type,l_Actual_Data_Source
644: FROM bis_indicators
645: WHERE dataset_id = l_link_id;
646:
647: IF(l_type=BSC_SIMULATION_VIEW_PUB.c_CALCULATED_KPI)THEN
648:

Line 697: FROM bis_indicators

693: IF(l_type=BSC_SIMULATION_VIEW_PUB.c_CALC_KPI)THEN
694:
695: SELECT actual_data_source
696: INTO l_Actual_Data_Source
697: FROM bis_indicators
698: WHERE dataset_id = l_node_id;
699:
700: l_attribute_code := SUBSTR(l_Actual_Data_Source, INSTR(l_Actual_Data_Source, '.') + 1,LENGTH(l_Actual_Data_Source));
701: l_dataset_id := Get_dup_dataset_id

Line 1348: l_meas_short_name BIS_INDICATORS.short_name%TYPE;

1344: ,x_msg_data OUT NOCOPY VARCHAR2
1345: ) IS
1346: l_region_code AK_REGIONS.region_code%TYPE;
1347: l_attribute_code AK_REGION_ITEMS_VL.attribute_code%TYPE;
1348: l_meas_short_name BIS_INDICATORS.short_name%TYPE;
1349: l_number_format v$nls_parameters.value%TYPE;
1350: l_replace_format VARCHAR2(10);
1351: l_attribute7 AK_REGION_ITEMS_VL.attribute7%TYPE;
1352:

Line 1377: FROM bis_indicators

1373:
1374: l_region_code := cd.short_name;
1375: SELECT short_name
1376: INTO l_meas_short_name
1377: FROM bis_indicators
1378: WHERE dataset_id =p_dataset_Id;
1379:
1380: l_attribute7 := Get_Format(p_format_Id => p_format_Id);
1381: