DBA Data[Home] [Help]

APPS.BSC_METADATA_OPTIMIZER_PKG dependencies on BSC_KPI_PROPERTIES

Line 781: FROM BSC_KPIS_VL KPIS, BSC_KPI_PROPERTIES prop

777:
778: PROCEDURE writeKPIList IS
779: cursor cList IS
780: SELECT KPIS.INDICATOR, KPIS.NAME, KPIS.PROTOTYPE_FLAG , decode(nvl(prop.property_value, 1), 1, 'Summary Tables/MVs', 'Analytical Workspace') impl_type
781: FROM BSC_KPIS_VL KPIS, BSC_KPI_PROPERTIES prop
782: WHERE kpis.INDICATOR IN
783: (SELECT INDICATOR FROM BSC_TMP_OPT_UI_KPIS WHERE process_id=g_processID)
784: AND kpis.indicator=prop.indicator(+)
785: and prop.property_code(+) = 'IMPLEMENTATION_TYPE'