APPS.ICX_UTIL dependencies on AK_ATTRIBUTES

Line 434: from AK_ATTRIBUTES a,

430: p_where_clause in varchar2) is
431:
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

Line 768: from AK_ATTRIBUTES a,

764: cursor lov_query_columns is
765:
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

Line 983: from AK_ATTRIBUTES a,

979: htp.p('');
980:
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

Line 1283: from AK_ATTRIBUTES a,

1279: order by DISPLAY_SEQUENCE;
1280:
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

Line 1492: from AK_ATTRIBUTES a,

1488: -- Need to fetch the value of the base LOV attribute
1489: -- column name from the LOV object to be used in the autoquery
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