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_REGION_ITEMS_VL

Line 1937: l_display_name AK_REGION_ITEMS_VL.attribute_label_long%TYPE;

1933: p_region_code IN VARCHAR
1934: ,p_dataset_id IN NUMBER
1935: ,x_meas_disp_name OUT NOCOPY VARCHAR
1936: ) IS
1937: l_display_name AK_REGION_ITEMS_VL.attribute_label_long%TYPE;
1938: l_measure_type BIS_INDICATORS_VL.MEASURE_TYPE%TYPE;
1939: l_source BSC_SYS_DATASETS_B.SOURCE%TYPE;
1940: l_item_type AK_REGION_ITEMS_VL.ATTRIBUTE1%TYPE;
1941: BEGIN

Line 1940: l_item_type AK_REGION_ITEMS_VL.ATTRIBUTE1%TYPE;

1936: ) IS
1937: l_display_name AK_REGION_ITEMS_VL.attribute_label_long%TYPE;
1938: l_measure_type BIS_INDICATORS_VL.MEASURE_TYPE%TYPE;
1939: l_source BSC_SYS_DATASETS_B.SOURCE%TYPE;
1940: l_item_type AK_REGION_ITEMS_VL.ATTRIBUTE1%TYPE;
1941: BEGIN
1942: Get_Measure_Prop(p_region_code, p_dataset_id, l_display_name, l_measure_type, l_source, l_item_type);
1943: x_meas_disp_name := l_display_name;
1944:

Line 1965: ,x_meas_disp_name OUT NOCOPY AK_REGION_ITEMS_VL.ATTRIBUTE_LABEL_LONG%TYPE

1961: PROCEDURE Get_Measure_Prop
1962: (
1963: p_region_code IN VARCHAR
1964: ,p_dataset_id IN NUMBER
1965: ,x_meas_disp_name OUT NOCOPY AK_REGION_ITEMS_VL.ATTRIBUTE_LABEL_LONG%TYPE
1966: ,x_measure_type OUT NOCOPY BIS_INDICATORS_VL.MEASURE_TYPE%TYPE
1967: ,x_source OUT NOCOPY BSC_SYS_DATASETS_B.SOURCE%TYPE
1968: ,x_item_type OUT NOCOPY AK_REGION_ITEMS_VL.ATTRIBUTE1%TYPE
1969: ) IS

Line 1968: ,x_item_type OUT NOCOPY AK_REGION_ITEMS_VL.ATTRIBUTE1%TYPE

1964: ,p_dataset_id IN NUMBER
1965: ,x_meas_disp_name OUT NOCOPY AK_REGION_ITEMS_VL.ATTRIBUTE_LABEL_LONG%TYPE
1966: ,x_measure_type OUT NOCOPY BIS_INDICATORS_VL.MEASURE_TYPE%TYPE
1967: ,x_source OUT NOCOPY BSC_SYS_DATASETS_B.SOURCE%TYPE
1968: ,x_item_type OUT NOCOPY AK_REGION_ITEMS_VL.ATTRIBUTE1%TYPE
1969: ) IS
1970: l_display_name AK_REGION_ITEMS_VL.attribute_label_long%TYPE;
1971:
1972: CURSOR measure_cur IS

Line 1970: l_display_name AK_REGION_ITEMS_VL.attribute_label_long%TYPE;

1966: ,x_measure_type OUT NOCOPY BIS_INDICATORS_VL.MEASURE_TYPE%TYPE
1967: ,x_source OUT NOCOPY BSC_SYS_DATASETS_B.SOURCE%TYPE
1968: ,x_item_type OUT NOCOPY AK_REGION_ITEMS_VL.ATTRIBUTE1%TYPE
1969: ) IS
1970: l_display_name AK_REGION_ITEMS_VL.attribute_label_long%TYPE;
1971:
1972: CURSOR measure_cur IS
1973: SELECT DISTINCT NVL(V.ATTRIBUTE_LABEL_LONG,B.NAME) NAME,
1974: B.MEASURE_TYPE,

Line 1979: AK_REGION_ITEMS_VL V,

1975: D.SOURCE,
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%'