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_REQ_NAVIGATION dependencies on AK_QUERY_PKG

Line 163: for i in ak_query_pkg.g_items_table.first .. ak_query_pkg.g_items_table.last loop

159: begin
160:
161: v_on := 'N';
162: v_vendor_on_flag := 'N';
163: for i in ak_query_pkg.g_items_table.first .. ak_query_pkg.g_items_table.last loop
164: if (ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_NAME' or
165: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_CONTACT' or
166: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_PHONE' or
167: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_SITE') and

Line 164: if (ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_NAME' or

160:
161: v_on := 'N';
162: v_vendor_on_flag := 'N';
163: for i in ak_query_pkg.g_items_table.first .. ak_query_pkg.g_items_table.last loop
164: if (ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_NAME' or
165: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_CONTACT' or
166: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_PHONE' or
167: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_SITE') and
168: ak_query_pkg.g_items_table(i).node_display_flag = 'Y' and

Line 165: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_CONTACT' or

161: v_on := 'N';
162: v_vendor_on_flag := 'N';
163: for i in ak_query_pkg.g_items_table.first .. ak_query_pkg.g_items_table.last loop
164: if (ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_NAME' or
165: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_CONTACT' or
166: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_PHONE' or
167: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_SITE') and
168: ak_query_pkg.g_items_table(i).node_display_flag = 'Y' and
169: ak_query_pkg.g_items_table(i).update_flag = 'Y' and

Line 166: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_PHONE' or

162: v_vendor_on_flag := 'N';
163: for i in ak_query_pkg.g_items_table.first .. ak_query_pkg.g_items_table.last loop
164: if (ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_NAME' or
165: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_CONTACT' or
166: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_PHONE' or
167: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_SITE') and
168: ak_query_pkg.g_items_table(i).node_display_flag = 'Y' and
169: ak_query_pkg.g_items_table(i).update_flag = 'Y' and
170: ak_query_pkg.g_items_table(i).secured_column <> 'T' and

Line 167: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_SITE') and

163: for i in ak_query_pkg.g_items_table.first .. ak_query_pkg.g_items_table.last loop
164: if (ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_NAME' or
165: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_CONTACT' or
166: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_PHONE' or
167: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_SITE') and
168: ak_query_pkg.g_items_table(i).node_display_flag = 'Y' and
169: ak_query_pkg.g_items_table(i).update_flag = 'Y' and
170: ak_query_pkg.g_items_table(i).secured_column <> 'T' and
171: ak_query_pkg.g_items_table(i).item_style <> 'HIDDEN' then

Line 168: ak_query_pkg.g_items_table(i).node_display_flag = 'Y' and

164: if (ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_NAME' or
165: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_CONTACT' or
166: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_PHONE' or
167: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_SITE') and
168: ak_query_pkg.g_items_table(i).node_display_flag = 'Y' and
169: ak_query_pkg.g_items_table(i).update_flag = 'Y' and
170: ak_query_pkg.g_items_table(i).secured_column <> 'T' and
171: ak_query_pkg.g_items_table(i).item_style <> 'HIDDEN' then
172:

Line 169: ak_query_pkg.g_items_table(i).update_flag = 'Y' and

165: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_CONTACT' or
166: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_PHONE' or
167: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_SITE') and
168: ak_query_pkg.g_items_table(i).node_display_flag = 'Y' and
169: ak_query_pkg.g_items_table(i).update_flag = 'Y' and
170: ak_query_pkg.g_items_table(i).secured_column <> 'T' and
171: ak_query_pkg.g_items_table(i).item_style <> 'HIDDEN' then
172:
173: v_vendor_on_flag := 'Y';

Line 170: ak_query_pkg.g_items_table(i).secured_column <> 'T' and

166: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_PHONE' or
167: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_SITE') and
168: ak_query_pkg.g_items_table(i).node_display_flag = 'Y' and
169: ak_query_pkg.g_items_table(i).update_flag = 'Y' and
170: ak_query_pkg.g_items_table(i).secured_column <> 'T' and
171: ak_query_pkg.g_items_table(i).item_style <> 'HIDDEN' then
172:
173: v_vendor_on_flag := 'Y';
174: exit;

Line 171: ak_query_pkg.g_items_table(i).item_style <> 'HIDDEN' then

167: ak_query_pkg.g_items_table(i).attribute_code = 'ICX_SUGGESTED_VENDOR_SITE') and
168: ak_query_pkg.g_items_table(i).node_display_flag = 'Y' and
169: ak_query_pkg.g_items_table(i).update_flag = 'Y' and
170: ak_query_pkg.g_items_table(i).secured_column <> 'T' and
171: ak_query_pkg.g_items_table(i).item_style <> 'HIDDEN' then
172:
173: v_vendor_on_flag := 'Y';
174: exit;
175: end if;