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

Line 1148: from main_indics ind, bsc_kpis_vl kpis

1144: (
1145: SELECT INDICATOR FROM main_indics
1146: union -- get dependant child indicators after validating filters are same
1147: select kpis.indicator
1148: from main_indics ind, bsc_kpis_vl kpis
1149: where ind.indicator = kpis.source_indicator
1150: and not exists
1151: (select 1 from bsc_kpi_dim_levels_b master, bsc_kpi_dim_levels_b child
1152: where master.indicator=kpis.source_indicator

Line 1515: Name BSC_KPIS_VL.NAME%TYPE;

1511: PROCEDURE InicAllIndicadores IS
1512:
1513: l_stmt VARCHAR2(1000);
1514: Cod NUMBER;
1515: Name BSC_KPIS_VL.NAME%TYPE;
1516: l_indic_type NUMBER;
1517: l_config_type NUMBER;
1518: Per_Inter NUMBER;
1519: OptimizationMode NUMBER;

Line 1527: SOURCE_INDICATOR, EDW_FLAG FROM BSC_KPIS_VL

1523: EDW_Flag NUMBER;
1524: CURSOR c1 IS
1525: SELECT DISTINCT INDICATOR, NAME, PROTOTYPE_FLAG,
1526: INDICATOR_TYPE, CONFIG_TYPE, PERIODICITY_ID, SHARE_FLAG,
1527: SOURCE_INDICATOR, EDW_FLAG FROM BSC_KPIS_VL
1528: ORDER BY INDICATOR;
1529: cRow c1%ROWTYPE;
1530: l_impl_type number;
1531: BEGIN