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_ACTUAL_PVT dependencies on AK_REGION_ITEMS

Line 124: FROM ak_region_items

120: where region_code = p_region_Code;
121:
122: CURSOR base_column_cursor(cpAttributeCode varchar2) IS
123: SELECT attribute3 base_column
124: FROM ak_region_items
125: WHERE region_code = p_region_code
126: AND attribute_code = cpAttributeCode;
127:
128: CURSOR column_items_cursor IS

Line 130: FROM ak_region_items

126: AND attribute_code = cpAttributeCode;
127:
128: CURSOR column_items_cursor IS
129: SELECT attribute_code, attribute3 base_column
130: FROM ak_region_items
131: WHERE region_code = p_region_code
132: AND nested_region_code is null
133: AND ( (attribute1 = 'MEASURE')
134: or (attribute1 = 'MEASURE_NOTARGET')

Line 623: SELECT attribute_code, attribute2 from ak_region_items

619: SELECT attribute1 disable_viewby, attribute8 plsql_function
620: from ak_Regions
621: where region_code = p_region_Code;
622: CURSOR c_rankparam(pRegionCode in varchar2) IS
623: SELECT attribute_code, attribute2 from ak_region_items
624: WHERE display_Sequence = (select min(display_sequence)
625: from ak_region_items where region_code = pregioncode
626: and attribute_code <> 'AS_OF_DATE') and region_code = pregioncode;
627:

Line 625: from ak_region_items where region_code = pregioncode

621: where region_code = p_region_Code;
622: CURSOR c_rankparam(pRegionCode in varchar2) IS
623: SELECT attribute_code, attribute2 from ak_region_items
624: WHERE display_Sequence = (select min(display_sequence)
625: from ak_region_items where region_code = pregioncode
626: and attribute_code <> 'AS_OF_DATE') and region_code = pregioncode;
627:
628: CURSOR base_column_cursor(cpAttributeCode varchar2) IS
629: SELECT attribute3 base_column

Line 630: FROM ak_region_items

626: and attribute_code <> 'AS_OF_DATE') and region_code = pregioncode;
627:
628: CURSOR base_column_cursor(cpAttributeCode varchar2) IS
629: SELECT attribute3 base_column
630: FROM ak_region_items
631: WHERE region_code = p_region_code
632: AND attribute_code = cpAttributeCode;
633:
634: CURSOR column_items_cursor IS

Line 636: FROM ak_region_items

632: AND attribute_code = cpAttributeCode;
633:
634: CURSOR column_items_cursor IS
635: SELECT attribute_code, attribute3 base_column
636: FROM ak_region_items
637: WHERE region_code = p_region_code
638: AND nested_region_code is null
639: AND ( (attribute1 = 'MEASURE')
640: or (attribute1 = 'MEASURE_NOTARGET')

Line 648: FROM ak_region_items

644: --Cursor for getting the attribute code for grand total
645: l_grand_total varchar2(2000) := 'GRAND_TOTAL';
646: CURSOR c_grandattrib(p_attrib_code IN VARCHAR2) IS
647: SELECT attribute_code
648: FROM ak_region_items
649: WHERE region_code = p_region_code
650: and attribute2 = p_attrib_code
651: and attribute1 = l_grand_total;
652: l_actual_base_column varchar2(2000);

Line 727: from ak_region_items

723: end if;
724:
725: begin
726: select attribute_code into l_ranking_attr
727: from ak_region_items
728: where region_code = p_region_code and
729: attribute2 = p_ranking_level;
730: exception
731: when others then null;

Line 1712: SELECT attribute_code, attribute2 from ak_region_items

1708: from ak_Regions
1709: where region_code = p_region_Code;
1710:
1711: CURSOR c_rankparam(pRegionCode in varchar2) IS
1712: SELECT attribute_code, attribute2 from ak_region_items
1713: WHERE display_Sequence = (select min(display_sequence)
1714: from ak_region_items where region_code = pregioncode
1715: and attribute_code <> 'AS_OF_DATE') and region_code = pregioncode;
1716:

Line 1714: from ak_region_items where region_code = pregioncode

1710:
1711: CURSOR c_rankparam(pRegionCode in varchar2) IS
1712: SELECT attribute_code, attribute2 from ak_region_items
1713: WHERE display_Sequence = (select min(display_sequence)
1714: from ak_region_items where region_code = pregioncode
1715: and attribute_code <> 'AS_OF_DATE') and region_code = pregioncode;
1716:
1717: CURSOR base_column_cursor(cpAttributeCode varchar2) IS
1718: SELECT attribute3 base_column

Line 1719: FROM ak_region_items

1715: and attribute_code <> 'AS_OF_DATE') and region_code = pregioncode;
1716:
1717: CURSOR base_column_cursor(cpAttributeCode varchar2) IS
1718: SELECT attribute3 base_column
1719: FROM ak_region_items
1720: WHERE region_code = p_region_code
1721: AND attribute_code = cpAttributeCode;
1722:
1723: CURSOR column_items_cursor IS

Line 1725: FROM ak_region_items

1721: AND attribute_code = cpAttributeCode;
1722:
1723: CURSOR column_items_cursor IS
1724: SELECT attribute_code, attribute3 base_column
1725: FROM ak_region_items
1726: WHERE region_code = p_region_code
1727: AND nested_region_code is null
1728: AND ( (attribute1 = 'MEASURE')
1729: or (attribute1 = 'MEASURE_NOTARGET')

Line 1738: FROM ak_region_items

1734: --Cursor for getting the attribute code for grand total
1735: l_grand_total varchar2(2000) := 'GRAND_TOTAL';
1736: CURSOR c_grandattrib(p_attrib_code IN VARCHAR2) IS
1737: SELECT attribute_code
1738: FROM ak_region_items
1739: WHERE region_code = p_region_code
1740: and attribute2 = p_attrib_code
1741: and attribute1 = l_grand_total;
1742:

Line 1847: from ak_region_items

1843: end if;
1844:
1845: begin
1846: select attribute_code into l_ranking_attr
1847: from ak_region_items
1848: where region_code = p_region_code and
1849: attribute2 = p_ranking_level;
1850: exception
1851: when others then null;