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.POS_PRODUCT_SERVICE_UTL_PKG dependencies on DUAL

Line 461: select instr(g_product_segments(p_product_segment_index).where_clause,'ORDER BY') INTO l_index from dual;

457: g_product_segments(p_product_segment_index).table_name || ' where (' ||
458: l_id_or_value || ' = :1 )';
459:
460: ELSE
461: select instr(g_product_segments(p_product_segment_index).where_clause,'ORDER BY') INTO l_index from dual;
462: IF(l_index=0) then
463: select instr(g_product_segments(p_product_segment_index).where_clause,'order by') INTO l_index from dual;
464: END IF;
465: IF (l_index=0) THEN

Line 463: select instr(g_product_segments(p_product_segment_index).where_clause,'order by') INTO l_index from dual;

459:
460: ELSE
461: select instr(g_product_segments(p_product_segment_index).where_clause,'ORDER BY') INTO l_index from dual;
462: IF(l_index=0) then
463: select instr(g_product_segments(p_product_segment_index).where_clause,'order by') INTO l_index from dual;
464: END IF;
465: IF (l_index=0) THEN
466: l_string := g_product_segments(p_product_segment_index).where_clause;
467: ELSE

Line 468: SELECT SubStr(g_product_segments(p_product_segment_index).where_clause,1,l_index-1) INTO l_string FROM dual;

464: END IF;
465: IF (l_index=0) THEN
466: l_string := g_product_segments(p_product_segment_index).where_clause;
467: ELSE
468: SELECT SubStr(g_product_segments(p_product_segment_index).where_clause,1,l_index-1) INTO l_string FROM dual;
469: END IF;
470:
471: g_description_queries(p_product_segment_index) :=
472: 'select ' ||