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_MO_UI_PKG dependencies on BSC_KPIS_VL

Line 453: FROM BSC_KPIS_VL

449: -- Default list for Selected Objectives
450: if (pMode = 'SELECTED' OR pMode = 'SELECTED_REPORTS' OR pMode = 'SELECTED_SIMULATIONS') then
451: l_stmt := ' INSERT INTO BSC_TMP_OPT_UI_KPIS (indicator, prototype_flag, process_id)
452: SELECT INDICATOR, prototype_flag, :1
453: FROM BSC_KPIS_VL
454: WHERE PROTOTYPE_FLAG NOT IN (1,2,3,4)';
455: execute immediate l_stmt USING pProcessId;
456: commit;
457: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN

Line 468: FROM BSC_KPIS_VL

464:
465: if (pMode = 'ALL') THEN
466: l_stmt := ' INSERT INTO BSC_TMP_OPT_UI_KPIS (indicator, prototype_flag, process_id)
467: SELECT INDICATOR, prototype_flag, :1
468: FROM BSC_KPIS_VL
469: WHERE BSC_DBGEN_UTILS.GET_OBJECTIVE_TYPE(SHORT_NAME) = :2 ';
470: execute immediate l_stmt USING pProcessId, 'OBJECTIVE';
471: commit;
472: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN

Line 482: FROM BSC_KPIS_VL

478: -- Only Modified mode, now, all other Modes would have returned.
479: SELECT count(1) INTO l_total_kpis FROM BSC_KPIS_B;
480: l_stmt := ' INSERT INTO BSC_TMP_OPT_UI_KPIS (indicator, prototype_flag, process_id)
481: SELECT INDICATOR, prototype_flag, :1
482: FROM BSC_KPIS_VL
483: WHERE (PROTOTYPE_FLAG = 2 OR PROTOTYPE_FLAG = 3) ';
484: execute immediate l_stmt USING pProcessId;
485:
486: IF (SQL%ROWCOUNT = l_total_kpis) THEN

Line 540: FROM BSC_KPIS_VL WHERE (' || strWhereInIndics4 || ')';

536: END LOOP;
537: strWhereNotInIndics4 := 'NOT (' || strWhereInIndics4 || ')';
538: l_stmt := 'INSERT INTO BSC_TMP_OPT_UI_KPIS( INDICATOR, PROTOTYPE_FLAG, process_id)
539: SELECT DISTINCT INDICATOR, 4, :1
540: FROM BSC_KPIS_VL WHERE (' || strWhereInIndics4 || ')';
541: IF BSC_METADATA_OPTIMIZER_PKG.gnumIndics > 0 THEN
542: l_stmt := l_stmt || ' minus select indicator, 4, :2 from BSC_TMP_OPT_ui_kpis WHERE process_id = :3 ';
543: execute immediate l_stmt USING pProcessId, pProcessId, pProcessId;
544: ELSE

Line 552: SELECT INDICATOR, prototype_flag, :1 FROM BSC_KPIS_VL a

548:
549: IF BSC_METADATA_OPTIMIZER_PKG.g_Sum_Level_Change <> 0 THEN
550: -- summarization change, add production indicators to the list.
551: l_stmt := ' INSERT INTO BSC_TMP_OPT_UI_KPIS (indicator, prototype_flag, process_id)
552: SELECT INDICATOR, prototype_flag, :1 FROM BSC_KPIS_VL a
553: WHERE NOT EXISTS (SELECT 1 FROM BSC_TMP_OPT_UI_KPIS b WHERE process_id = :2 and a.indicator = b.indicator)';
554: execute immediate l_stmt USING pProcessId, pProcessId;
555:
556: END IF;

Line 561: FROM BSC_KPIS_VL parent,

557:
558: -- take care of shared kpis, which are NOT marked by the builder, just in case
559: l_stmt := ' INSERT INTO BSC_TMP_OPT_UI_KPIS (indicator, prototype_flag, process_id)
560: SELECT child.INDICATOR, parent.prototype_flag, :1
561: FROM BSC_KPIS_VL parent,
562: BSC_KPIS_VL child,
563: BSC_TMP_OPT_UI_KPIS uitmp
564: where uitmp.indicator = parent.indicator
565: and uitmp.process_id = :2

Line 562: BSC_KPIS_VL child,

558: -- take care of shared kpis, which are NOT marked by the builder, just in case
559: l_stmt := ' INSERT INTO BSC_TMP_OPT_UI_KPIS (indicator, prototype_flag, process_id)
560: SELECT child.INDICATOR, parent.prototype_flag, :1
561: FROM BSC_KPIS_VL parent,
562: BSC_KPIS_VL child,
563: BSC_TMP_OPT_UI_KPIS uitmp
564: where uitmp.indicator = parent.indicator
565: and uitmp.process_id = :2
566: and parent.share_flag = 1

Line 574: SELECT INDICATOR, prototype_flag, :1 FROM BSC_KPIS_VL a

570: execute immediate l_stmt USING pProcessId, pProcessId, pProcessId;
571:
572: -- insert remaining KPIS finally, UI wants it
573: l_stmt := ' INSERT INTO BSC_TMP_OPT_UI_KPIS (indicator, prototype_flag, process_id)
574: SELECT INDICATOR, prototype_flag, :1 FROM BSC_KPIS_VL a
575: WHERE NOT EXISTS (SELECT 1 FROM BSC_TMP_OPT_UI_KPIS b WHERE process_id = :2 and a.indicator = b.indicator)';
576: execute immediate l_stmt USING pProcessId, pProcessId;
577:
578: -- Get rid of the autogen. report generated objectives for ALL and MODIFIED modes

Line 583: (select indicator from bsc_kpis_vl kpis

579: IF (pMode='MODIFIED') THEN
580: l_stmt := 'delete from BSC_TMP_OPT_UI_KPIS tmp
581: where process_id = :1
582: and indicator in
583: (select indicator from bsc_kpis_vl kpis
584: where kpis.short_name is not null
585: and BSC_DBGEN_UTILS.get_objective_type(kpis.short_name) <> ''OBJECTIVE'') ';
586: execute immediate l_stmt USING pProcessId;
587: END IF;

Line 699: EDW_FLAG FROM BSC_KPIS_VL WHERE

695: CURSOR cAPI IS
696: SELECT DISTINCT INDICATOR, NAME, PROTOTYPE_FLAG,
697: INDICATOR_TYPE, CONFIG_TYPE, PERIODICITY_ID,
698: SHARE_FLAG, SOURCE_INDICATOR,
699: EDW_FLAG FROM BSC_KPIS_VL WHERE
700: INDICATOR = pIndicator;
701: cIndAPI cAPI%ROWTYPE;
702:
703: BEGIN

Line 1270: FROM BSC_KPIS_VL k,

1266:
1267: -- take care of shared kpis
1268: l_stmt := ' INSERT INTO BSC_TMP_OPT_UI_KPIS (indicator, prototype_flag, process_id)
1269: SELECT k.INDICATOR, k.PROTOTYPE_FLAG, :1
1270: FROM BSC_KPIS_VL k,
1271: BSC_TMP_OPT_UI_KPIS t
1272: WHERE ((k.SHARE_FLAG = 2 AND k.SOURCE_INDICATOR = t.INDICATOR)
1273: OR (k.SHARE_FLAG = 2 AND k.SOURCE_INDICATOR IN
1274: (SELECT I.SOURCE_INDICATOR FROM BSC_KPIS_B I WHERE I.SHARE_FLAG = 2 AND I.INDICATOR = t.INDICATOR))