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.BIS_PMV_PARAMETERS_PVT dependencies on AK_REGIONS

Line 324: ak_regions where region_code = cpRegionCode;

320: AND nested_region_code IS NOT NULL;
321: --ashgarg Bug 3878112: get Data Source
322: cursor getDataSource (cpRegionCode varchar2) is
323: SELECT attribute10 FROM
324: ak_regions where region_code = cpRegionCode;
325:
326: --first get the parameters that do not share dimensions/attribute code with the nested region
327: BEGIN
328:

Line 2221: FROM ak_regions

2217: IS
2218:
2219: CURSOR getDelegationParam IS
2220: SELECT attribute14
2221: FROM ak_regions
2222: WHERE region_code = pRegionCode;
2223:
2224: CURSOR getPrivileges(pAttributeCode VARCHAR2) IS
2225: SELECT attribute24

Line 2233: from ak_region_items vl, ak_regions r

2229: cursor c_level_values_view_name (cp_parameter_name varchar2, cp_region_code varchar2) is
2230: select vl.attribute15, -- level view name
2231: substr(vl.attribute2, instr(vl.attribute2,'+')+1), -- dimension level
2232: nvl(r.region_object_type, 'OLTP') -- level type
2233: from ak_region_items vl, ak_regions r
2234: where nvl(vl.attribute2,vl.attribute_code) = rtrim(cp_parameter_name)
2235: and vl.region_code = rtrim(cp_region_code)
2236: and vl.region_code = r.region_code;
2237:

Line 4060: from ak_region_items_vl vl, ak_regions r

4056:
4057: ----GSANAP for EDW purposes 10/17/00
4058: cursor c_edw_level_values_view_name (cp_parameter_name varchar2, cp_region_code varchar2) is
4059: select vl.attribute15 level_values_view_name, substr(vl.attribute2, instr(vl.attribute2, '+')+1) dimension_level
4060: from ak_region_items_vl vl, ak_regions r
4061: where nvl(vl.attribute2,vl.attribute_code) LIKE rtrim(cp_parameter_name)
4062: and vl.region_code = rtrim(cp_region_code)
4063: and vl.region_code = r.region_code
4064: and lower(r.region_object_type) = 'edw' ;

Line 4075: from ak_region_items vl, ak_regions r

4071: substr(vl.attribute2, 1, instr(vl.attribute2,'+')-1), -- dimension
4072: substr(vl.attribute2, instr(vl.attribute2,'+')+1), -- dimension level
4073: nvl(r.region_object_type, 'OLTP'), -- level type
4074: vl.attribute4 -- lov where clause
4075: from ak_region_items vl, ak_regions r
4076: where nvl(vl.attribute2,vl.attribute_code) = rtrim(cp_parameter_name)
4077: and vl.region_code = rtrim(cp_region_code)
4078: and vl.region_code = r.region_code;
4079:

Line 4382: from ak_region_items_vl vl, ak_regions r

4378:
4379: ----GSANAP for EDW purposes 10/17/00
4380: cursor c_edw_tmlvl_values_view_name (cp_parameter_name varchar2, cp_region_code varchar2) is
4381: select vl.attribute15 edw_level_values_view_name, substr(vl.attribute2, instr(vl.attribute2, '+')+1) dimension_level
4382: from ak_region_items_vl vl, ak_regions r
4383: where nvl(vl.attribute2,vl.attribute_code) LIKE rtrim(cp_parameter_name)
4384: and vl.region_code = rtrim(cp_region_code)
4385: and vl.region_code = r.region_code
4386: and lower(r.region_object_type) = 'edw';

Line 4393: from ak_region_items vl, ak_regions r

4389: cursor c_tmlvl_values_view_name (cp_parameter_name varchar2, cp_region_code varchar2) is
4390: select vl.attribute15, -- view name
4391: substr(vl.attribute2, instr(vl.attribute2, '+')+1), -- dimension level
4392: nvl(r.region_object_type, 'OLTP') -- level type
4393: from ak_region_items vl, ak_regions r
4394: where nvl(vl.attribute2,vl.attribute_code) = rtrim(cp_parameter_name)
4395: and vl.region_code = rtrim(cp_region_code)
4396: and vl.region_code = r.region_code;
4397: