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

Line 542: FROM dual

538: -- If req line is being combined with another req or PO line, set flag to
539: -- 'Y'. Else, set flag to 'N'.
540: SELECT NVL(
541: (SELECT 'Y'
542: FROM dual
543: WHERE EXISTS(
544: -- Select all doc builder requisition lines that have the same PO line
545: -- number as the current line in the loop.
546: SELECT 'doc builder lines with same PO line number'

Line 5159: FROM dual

5155: /*SQL to check if some other modification is already holding a full lock on this line*/
5156:
5157: SELECT 'Y'
5158: INTO l_lock_available
5159: FROM dual
5160: WHERE NOT EXISTS (SELECT 'Another Mod has F lock'
5161: FROM po_entity_locks poel,
5162: po_lines_merge_v plm
5163: WHERE plm.po_line_id = poel.entity_pk1

Line 5459: select PO_SESSION_GT_S.nextval into l_session_key from dual;

5455:
5456:
5457: p_po_line_num_disp_tbl.extend(l_end_index - l_start_index + 1);
5458: -- get the session key
5459: select PO_SESSION_GT_S.nextval into l_session_key from dual;
5460:
5461: -- get the action whether the line is being added(match case) or new line
5462: l_action_tbl := PO_AUTOCREATE_GROUPING_PVT.get_line_action_tbl(p_po_line_num_tbl,
5463: p_add_to_po_header_id,