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_OAF_VIEWS_PVT dependencies on BSC_KPI_ANALYSIS_GROUPS

Line 73: FROM BSC_KPI_ANALYSIS_GROUPS

69: h_err := 0;
70: -- Number of Analysis Groups
71: SELECT MAX( ANALYSIS_GROUP_ID)
72: INTO h_ag_count
73: FROM BSC_KPI_ANALYSIS_GROUPS
74: WHERE INDICATOR=X_INDICATOR;
75:
76:
77: h_err := 1;

Line 95: FROM BSC_KPI_ANALYSIS_GROUPS

91:
92: --h_ag_depend
93: SELECT DEPENDENCY_FLAG
94: INTO h_ag1_depend
95: FROM BSC_KPI_ANALYSIS_GROUPS
96: WHERE ANALYSIS_GROUP_ID =1 AND
97: INDICATOR=X_INDICATOR;
98:
99:

Line 162: FROM BSC_KPI_ANALYSIS_GROUPS

158: h_err := 6;
159: --h_ag_depend
160: SELECT DEPENDENCY_FLAG
161: INTO h_ag2_depend
162: FROM BSC_KPI_ANALYSIS_GROUPS
163: WHERE ANALYSIS_GROUP_ID =2 AND
164: INDICATOR=X_INDICATOR;
165: -- If depend it
166: IF h_ag2_depend = 0 THEN

Line 441: from BSC_KPI_ANALYSIS_GROUPS

437: h_err := 0;
438: -- Number of Analysis Groups
439: select max(analysis_group_id)
440: into h_ag_count
441: from BSC_KPI_ANALYSIS_GROUPS
442: where indicator = x_indicator;
443:
444: h_err := 1;
445:

Line 449: from BSC_KPI_ANALYSIS_GROUPS

445:
446: -- Get option id default value for Analysis Group 0.
447: select default_value
448: into l_def_flag0
449: from BSC_KPI_ANALYSIS_GROUPS
450: where indicator = x_indicator
451: and analysis_group_id = 0;
452:
453: -- Get Name for A0

Line 474: from BSC_KPI_ANALYSIS_GROUPS

470:
471: -- Get dependency flag and option id default value for Analysis group 1.
472: select dependency_flag, default_value
473: into h_ag1_depend, l_def_flag1
474: from BSC_KPI_ANALYSIS_GROUPS
475: where analysis_group_id = 1
476: and indicator = x_indicator;
477:
478: -- If depend it

Line 533: from BSC_KPI_ANALYSIS_GROUPS

529: h_err := 6;
530: -- Get dependency flag and option id default value for Analysis group 2.
531: select dependency_flag, default_value
532: into h_ag2_depend, l_def_flag2
533: from BSC_KPI_ANALYSIS_GROUPS
534: where analysis_group_id = 2
535: and indicator = x_indicator;
536:
537: -- If dependent

Line 622: BSC_KPI_ANALYSIS_GROUPS b

618: if l_simul_tree <> 0 then
619: select count(a.option_id)
620: into l_def_opt_count
621: from BSC_KPI_ANALYSIS_OPTIONS_B a,
622: BSC_KPI_ANALYSIS_GROUPS b
623: where a.indicator = x_indicator
624: and a.indicator = b.indicator
625: and a.analysis_group_id = b.analysis_group_id
626: and a.option_id = b.default_value