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_CUSTOM_VIEW_UI_WRAPPER dependencies on AK_REGIONS

Line 1823: FROM AK_REGIONS

1819:
1820: IF (p_time_stamp IS NOT NULL) THEN
1821: SELECT LAST_UPDATE_DATE
1822: INTO l_last_update_date
1823: FROM AK_REGIONS
1824: WHERE REGION_CODE = p_report_sht_name
1825: AND REGION_APPLICATION_ID = p_Application_Id;
1826:
1827: IF(p_time_stamp <> TO_CHAR(l_last_update_date, l_last_upd_format)) THEN

Line 1840: UPDATE AK_REGIONS A

1836:
1837: l_Time_Stamp := SYSDATE;
1838: --DBMS_OUTPUT.PUT_LINE('latest timestamp = ' || TO_CHAR(l_Time_Stamp, l_last_upd_format));
1839:
1840: UPDATE AK_REGIONS A
1841: SET A.LAST_UPDATE_DATE = l_Time_Stamp
1842: WHERE A.REGION_CODE = p_report_sht_name
1843: AND REGION_APPLICATION_ID = p_Application_Id;
1844:

Line 1855: FROM AK_REGIONS_VL

1851: IF(l_count=0)THEN
1852:
1853: SELECT Name
1854: INTO l_tab_name
1855: FROM AK_REGIONS_VL
1856: WHERE REGION_CODE = p_report_sht_name;
1857:
1858: l_tab_name := BSC_BIS_CUSTOM_KPI_UTIL_PUB.Get_Unqiue_Tab_Name(l_tab_name);
1859: BSC_PMF_UI_WRAPPER.Create_Tab

Line 1980: AK_REGIONS C

1976: v.attribute1 ITEM_TYPE
1977: FROM BIS_INDICATORS_VL B,
1978: BSC_SYS_DATASETS_B D,
1979: AK_REGION_ITEMS_VL V,
1980: AK_REGIONS C
1981: WHERE C.REGION_CODE = V.REGION_CODE
1982: AND V.ATTRIBUTE_CATEGORY ='BIS PM Viewer'
1983: AND V.ATTRIBUTE1 LIKE '%MEASURE%'
1984: AND V.ATTRIBUTE1 NOT IN ('COMPARE_TO_MEASURE_NO_TARGET','CHANGE_MEASURE_NO_TARGET')