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.ICX_UTIL dependencies on AK_REGION_ITEMS

Line 201: from AK_REGION_ITEMS_VL ari1, AK_REGION_ITEMS_VL ari2

197:
198: cursor lov_out_attributes (lov_reg in varchar2, lov_reg_id in number, lov_f_key_name in varchar2) is
199: select decode(ari1.ATTRIBUTE_CODE,null,'NULL',ari1.ATTRIBUTE_CODE),
200: ari2.DISPLAY_SEQUENCE
201: from AK_REGION_ITEMS_VL ari1, AK_REGION_ITEMS_VL ari2
202: where ari1.REGION_APPLICATION_ID(+) = c_region_app_id
203: and ari1.REGION_CODE(+) = c_region_code
204: and ari1.LOV_REGION_APPLICATION_ID(+) = lov_reg_id
205: and ari1.LOV_REGION_CODE(+) = lov_reg

Line 216: from AK_REGION_ITEMS_VL ari1, AK_REGION_ITEMS_VL ari2

212: order by ari2.DISPLAY_SEQUENCE;
213:
214: cursor js_out_attributes (lov_reg in varchar2, lov_reg_id in number, lov_f_key_name in varchar2) is
215: select ari1.REGION_DEFAULTING_API_PROC, ari2.DISPLAY_SEQUENCE
216: from AK_REGION_ITEMS_VL ari1, AK_REGION_ITEMS_VL ari2
217: where ari1.REGION_APPLICATION_ID = c_region_app_id
218: and ari1.REGION_CODE = c_region_code
219: and ari1.LOV_REGION_APPLICATION_ID = lov_reg_id
220: and ari1.LOV_REGION_CODE = lov_reg

Line 263: from ak_region_items_vl

259: begin
260: if icx_sec.validateSession then
261:
262: select attribute_label_long into LOV_title
263: from ak_region_items_vl
264: where region_application_id = c_region_app_id
265: and region_code = c_region_code
266: and attribute_application_id = c_attribute_app_id
267: and attribute_code = c_attribute_code;

Line 272: from AK_REGION_ITEMS

268:
269: -- Look up the LOV region being called
270: select LOV_FOREIGN_KEY_NAME, LOV_REGION_APPLICATION_ID, LOV_REGION_CODE
271: into temp_LOV_foreign_key_name, temp_LOV_region_id, temp_LOV_region
272: from AK_REGION_ITEMS
273: where REGION_APPLICATION_ID = c_region_app_id
274: and REGION_CODE = c_region_code
275: and ATTRIBUTE_APPLICATION_ID = c_attribute_app_id
276: and ATTRIBUTE_CODE = c_attribute_code;

Line 435: AK_REGION_ITEMS_VL b,

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
439: and b.REGION_CODE = p_LOV_region

Line 769: AK_REGION_ITEMS_VL b,

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
773: and b.REGION_CODE = p_LOV_region

Line 984: AK_REGION_ITEMS_VL b,

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
988: and b.REGION_CODE = p_LOV_region

Line 1262: from AK_REGION_ITEMS_VL

1258: case_sensitive in varchar2) is
1259:
1260: cursor lov_out_attributes is
1261: select ATTRIBUTE_CODE, LOV_ATTRIBUTE_CODE
1262: from AK_REGION_ITEMS_VL
1263: where REGION_APPLICATION_ID = p_region_app_id
1264: and REGION_CODE = p_region_code
1265: and LOV_REGION_APPLICATION_ID = p_LOV_region_id
1266: and LOV_REGION_CODE = p_LOV_region

Line 1272: from AK_REGION_ITEMS_VL

1268: order by DISPLAY_SEQUENCE;
1269:
1270: cursor js_out_attributes is
1271: select ATTRIBUTE_CODE, LOV_ATTRIBUTE_CODE, REGION_DEFAULTING_API_PROC
1272: from AK_REGION_ITEMS_VL
1273: where REGION_APPLICATION_ID = p_region_app_id
1274: and REGION_CODE = p_region_code
1275: and LOV_REGION_APPLICATION_ID = p_LOV_region_id
1276: and LOV_REGION_CODE = p_LOV_region

Line 1284: AK_REGION_ITEMS_VL b,

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
1288: and b.REGION_CODE = p_LOV_region

Line 1493: AK_REGION_ITEMS_VL b,

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
1497: and b.REGION_CODE = p_LOV_region

Line 1510: from AK_REGION_ITEMS_VL e

1506: and d.ATTRIBUTE_APPLICATION_ID = a.ATTRIBUTE_APPLICATION_ID
1507: and d.ATTRIBUTE_CODE = a.ATTRIBUTE_CODE
1508: and b.DISPLAY_SEQUENCE = (
1509: select min(e.DISPLAY_SEQUENCE)
1510: from AK_REGION_ITEMS_VL e
1511: where e.REGION_APPLICATION_ID = p_LOV_region_id
1512: and e.REGION_CODE = p_LOV_region);
1513:
1514: -- Write autoquery function

Line 1858: from ak_region_items_vl

1854:
1855: -- display message if no rows were returned by query
1856: if j = 0 then
1857: select attribute_label_long into l_attribute_name
1858: from ak_region_items_vl
1859: where region_application_id = p_region_app_id
1860: and region_code = p_region_code
1861: and attribute_application_id = p_attribute_app_id
1862: and attribute_code = p_attribute_code;

Line 1911: from ak_region_items_tl arit,

1907: l_count number;
1908:
1909: cursor items is -- removed select for ari.attribute_code since we didnt use it. mputman 1574527
1910: select arit.attribute_label_long
1911: from ak_region_items_tl arit,
1912: ak_region_items ari
1913: where
1914: arit.region_application_id = ari.region_application_id
1915: and arit.region_code = ari.region_code

Line 1912: ak_region_items ari

1908:
1909: cursor items is -- removed select for ari.attribute_code since we didnt use it. mputman 1574527
1910: select arit.attribute_label_long
1911: from ak_region_items_tl arit,
1912: ak_region_items ari
1913: where
1914: arit.region_application_id = ari.region_application_id
1915: and arit.region_code = ari.region_code
1916: and arit.attribute_application_id = ari.attribute_application_id

Line 1925: from AK_REGION_ITEMS_TL a,

1921: order by display_sequence;
1922:
1923: cursor items_base is
1924: select a.ATTRIBUTE_LABEL_LONG,a.ATTRIBUTE_CODE
1925: from AK_REGION_ITEMS_TL a,
1926: AK_REGION_ITEMS b,
1927: FND_LANGUAGES c
1928: where b.REGION_APPLICATION_ID = p_region_application_id
1929: and b.REGION_CODE = p_region_code

Line 1926: AK_REGION_ITEMS b,

1922:
1923: cursor items_base is
1924: select a.ATTRIBUTE_LABEL_LONG,a.ATTRIBUTE_CODE
1925: from AK_REGION_ITEMS_TL a,
1926: AK_REGION_ITEMS b,
1927: FND_LANGUAGES c
1928: where b.REGION_APPLICATION_ID = p_region_application_id
1929: and b.REGION_CODE = p_region_code
1930: and b.ATTRIBUTE_APPLICATION_ID = a.ATTRIBUTE_APPLICATION_ID

Line 1997: from AK_REGION_ITEMS_VL

1993: begin
1994:
1995: select ATTRIBUTE_LABEL_LONG
1996: into l_prompt
1997: from AK_REGION_ITEMS_VL
1998: where REGION_APPLICATION_ID = p_region_application_id
1999: and REGION_CODE = p_region_code
2000: and ATTRIBUTE_APPLICATION_ID = p_attribute_application_id
2001: and ATTRIBUTE_CODE = p_attribute_code;

Line 2010: from AK_REGION_ITEMS_TL a,

2006: when NO_DATA_FOUND then
2007: begin
2008: select ATTRIBUTE_LABEL_LONG
2009: into l_prompt
2010: from AK_REGION_ITEMS_TL a,
2011: FND_LANGUAGES b
2012: where REGION_APPLICATION_ID = p_region_application_id
2013: and REGION_CODE = p_region_code
2014: and ATTRIBUTE_APPLICATION_ID = p_attribute_application_id