APPS.BSC_PMD_OPT_DOC_UTIL dependencies on BSC_KPI_PROPERTIES

Line 41: from BSC_KPI_PROPERTIES

37: set DISPLAY_TYPE = 'ANALYTICAL_WORKSPACES'
38: where PHYSICAL_TYPE = 'VIEW'
39: and TABLE_NAME_DISPLAY LIKE 'BSC\_S%' ESCAPE '\'
40: and exists (SELECT 1
41: from BSC_KPI_PROPERTIES
42: where INDICATOR =
43: TO_NUMBER(
44: SUBSTR(TABLE_NAME_DISPLAY,
45: INSTR(TABLE_NAME_DISPLAY,'_',1,2)+1,

Line 55: from BSC_KPI_PROPERTIES

51: set DISPLAY_TYPE = 'VIEW'
52: where PHYSICAL_TYPE = 'VIEW'
53: and (TABLE_NAME_DISPLAY NOT LIKE 'BSC\_S%' ESCAPE '\'
54: or not exists (SELECT 1
55: from BSC_KPI_PROPERTIES
56: where INDICATOR =
57: TO_NUMBER(
58: SUBSTR(TABLE_NAME_DISPLAY,
59: INSTR(TABLE_NAME_DISPLAY,'_',1,2)+1,