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_DRILL_PVT dependencies on AK_REGION_ITEMS_VL

Line 314: from ak_region_items_vl

310: vDisplaySeqTable BISVIEWER.t_char;
311:
312: cursor cParameters (cpRegionCode varchar2) is
313: select nvl(attribute2,attribute_code) attribute_code, substr(attribute2,1,instr(attribute2,'+')-1) dimension
314: from ak_region_items_vl
315: where region_code = rtrim(cpRegionCode)
316: and node_query_flag = 'Y'
317: order by display_sequence;
318:

Line 321: from ak_region_items_vl ak

317: order by display_sequence;
318:
319: cursor cPageLessParameters (cpRegionCode varchar2) is
320: select nvl(attribute2,attribute_code) attribute_code, substr(attribute2,1,instr(attribute2,'+')-1) dimension
321: from ak_region_items_vl ak
322: where ak.region_code = rtrim(cpRegionCode)
323: and ak.node_query_flag = 'Y'
324: AND nvl(substr(ak.attribute2,1,instr(ak.attribute2,'+')-1), ak.attribute_code) NOT IN (
325: select DISTINCT nvl(substr(b.attribute_name,1,instr(b.attribute_name,'+')-1), attribute_code)

Line 332: -- ashgarg Bug Fix: 3665085 Changed ak_region_items_vl to ak_region_items

328: and b.user_id =pUserId
329: )
330: order by display_sequence;
331:
332: -- ashgarg Bug Fix: 3665085 Changed ak_region_items_vl to ak_region_items
333: CURSOR cParametersWithNestedRegion (cpRegionCode varchar2, cpNestedRegionCode IN VARCHAR2) is
334: SELECT nvl(attribute2,attribute_code) attribute_code, substr(attribute2,1,instr(attribute2,'+')-1) dimension, display_sequence
335: FROM ak_region_items
336: WHERE region_code=cpNestedRegionCode