APPS.BIS_PMV_QUERY_PVT dependencies on AK_REGION_ITEMS

Line 733: FROM AK_REGION_ITEMS

729: SELECT attribute2,
730: attribute3 base_column,
731: attribute4 where_clause,
732: attribute14 data_type
733: FROM AK_REGION_ITEMS
734: WHERE region_code = cpRegionCode
735: AND nested_region_code is null
736: AND (nvl(attribute2, attribute_code) = cpParameterName
737: or attribute2||'_FROM' = cpParameterName

Line 743: -- report info from ak_region_items_vl

739: ORDER BY display_sequence;
740:
741: l_save_region_item_rec BIS_PMV_METADATA_PVT.SAVE_REGION_ITEM_REC;
742:
743: -- report info from ak_region_items_vl
744: CURSOR ak_region_item_cursor (cpRegionCode VARCHAR2) IS
745: SELECT attribute1 attribute_type,
746: attribute_code,
747: attribute2,

Line 758: FROM AK_REGION_ITEMS

754: order_sequence,
755: order_direction,
756: node_query_flag
757: ,node_display_flag -- 2371922
758: FROM AK_REGION_ITEMS
759: WHERE region_code = cpRegionCode
760: AND nested_region_code is null
761: ORDER BY display_sequence;
762:

Line 796: FROM AK_REGION_ITEMS

792:
793: --l_extra_groupby VARCHAR2(2000);
794: CURSOR base_col_cursor IS
795: SELECT distinct attribute3 base_column, attribute9 aggregation_function
796: FROM AK_REGION_ITEMS
797: WHERE region_code = p_region_code
798: AND attribute9 is not null
799: AND nested_region_code is null
800: AND substr(attribute3,1,1) not in ('''','"');

Line 1029: --get report info from ak_region_items_vl

1025: return;
1026: end if;
1027:
1028:
1029: --get report info from ak_region_items_vl
1030: l_item_count := 1;
1031: if ak_region_item_cursor%ISOPEN then
1032: close ak_region_item_cursor;
1033: end if;

Line 3455: FROM AK_REGION_ITEMS

3451: order_sequence,
3452: order_direction,
3453: node_query_flag
3454: ,node_display_flag --2371922
3455: FROM AK_REGION_ITEMS
3456: WHERE region_code = cpRegionCode
3457: AND nested_region_code is null
3458: AND node_query_flag = 'N'
3459: AND ( order_direction IS NOT NULL OR order_sequence IS NOT NULL ) --Bug Fix 2605121

Line 3477: FROM AK_REGION_ITEMS

3473: order_sequence,
3474: order_direction,
3475: node_query_flag
3476: ,node_display_flag --2371922
3477: FROM AK_REGION_ITEMS
3478: WHERE region_code = cpRegionCode
3479: AND nested_region_code is null
3480: AND node_query_flag = 'N'
3481: ORDER BY display_sequence;

Line 3893: FROM AK_REGION_ITEMS

3889: SELECT attribute2,
3890: attribute3 base_column,
3891: attribute4 where_clause,
3892: attribute14 data_type
3893: FROM AK_REGION_ITEMS
3894: WHERE region_code = cpRegionCode
3895: AND (nvl(attribute2, attribute_code) = cpParameterName
3896: or attribute2||'_FROM' = cpParameterName
3897: or attribute2||'_TO' = cpParameterName)