APPS.ICX_UTIL dependencies on AK_REGIONS

Line 436: AK_REGIONS c,

432: cursor lov_query_columns is
433: select d.COLUMN_NAME
434: from AK_ATTRIBUTES a,
435: AK_REGION_ITEMS_VL b,
436: AK_REGIONS c,
437: AK_OBJECT_ATTRIBUTES d
438: where b.REGION_APPLICATION_ID = p_LOV_region_id
439: and b.REGION_CODE = p_LOV_region
440: and b.NODE_QUERY_FLAG = 'Y'

Line 770: AK_REGIONS c,

766: select d.COLUMN_NAME,b.ATTRIBUTE_LABEL_LONG,
767: substr(a.DATA_TYPE,1,1)
768: from AK_ATTRIBUTES a,
769: AK_REGION_ITEMS_VL b,
770: AK_REGIONS c,
771: AK_OBJECT_ATTRIBUTES d
772: where b.REGION_APPLICATION_ID = p_LOV_region_id
773: and b.REGION_CODE = p_LOV_region
774: and b.NODE_QUERY_FLAG = 'Y'

Line 853: from ak_regions

849: }');
850:
851: select icx_custom_call
852: into l_icx_custom_call
853: from ak_regions
854: where REGION_APPLICATION_ID = p_LOV_region_id
855: and REGION_CODE = p_LOV_region;
856:
857: if instr(l_icx_custom_call,'LONG') > 0

Line 985: AK_REGIONS c,

981: select count(*)
982: into l_query_attr_cnt
983: from AK_ATTRIBUTES a,
984: AK_REGION_ITEMS_VL b,
985: AK_REGIONS c,
986: AK_OBJECT_ATTRIBUTES d
987: where b.REGION_APPLICATION_ID = p_LOV_region_id
988: and b.REGION_CODE = p_LOV_region
989: and b.NODE_QUERY_FLAG = 'Y'

Line 1285: AK_REGIONS c,

1281: cursor lov_query_columns is
1282: select d.COLUMN_NAME
1283: from AK_ATTRIBUTES a,
1284: AK_REGION_ITEMS_VL b,
1285: AK_REGIONS c,
1286: AK_OBJECT_ATTRIBUTES d
1287: where b.REGION_APPLICATION_ID = p_LOV_region_id
1288: and b.REGION_CODE = p_LOV_region
1289: and b.ATTRIBUTE_APPLICATION_ID = d.ATTRIBUTE_APPLICATION_ID

Line 1494: AK_REGIONS c,

1490: select substr(a.DATA_TYPE,1,1)||d.COLUMN_NAME
1491: into temp_a_1
1492: from AK_ATTRIBUTES a,
1493: AK_REGION_ITEMS_VL b,
1494: AK_REGIONS c,
1495: AK_OBJECT_ATTRIBUTES d
1496: where b.REGION_APPLICATION_ID = p_LOV_region_id
1497: and b.REGION_CODE = p_LOV_region
1498: and b.NODE_QUERY_FLAG = 'Y'

Line 1940: from AK_REGIONS_VL

1936: begin
1937:
1938: select NAME
1939: into p_title
1940: from AK_REGIONS_VL
1941: where REGION_APPLICATION_ID = p_region_application_id
1942: and REGION_CODE = p_region_code;
1943:
1944: /*

Line 1966: from AK_REGIONS_TL a,

1962: when NO_DATA_FOUND then
1963: begin
1964: select NAME
1965: into p_title
1966: from AK_REGIONS_TL a,
1967: FND_LANGUAGES b
1968: where REGION_APPLICATION_ID = p_region_application_id
1969: and REGION_CODE = p_region_code
1970: and a.LANGUAGE = b.LANGUAGE_CODE