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_PDOI_MAINPROC_UTL_PVT dependencies on PO_LINES_INTERFACE

Line 277: FROM po_lines_interface intf_lines,

273: SELECT l_key,
274: p_po_header_id_tbl(i),
275: v.max_line_num
276: FROM (SELECT max(intf_lines.line_num) AS max_line_num
277: FROM po_lines_interface intf_lines,
278: po_headers_interface intf_headers
279: WHERE intf_lines.interface_header_id = intf_headers.interface_header_id
280: AND intf_lines.processing_id = PO_PDOI_PARAMS.g_processing_id
281: AND intf_headers.processing_round_num = PO_PDOI_PARAMS.g_current_round_num

Line 529: FROM po_lines_interface intf_lines,

525: FORALL i IN 1..l_index_tbl.COUNT
526: INSERT INTO po_session_gt(key, num1)
527: SELECT l_key,
528: l_index_tbl(i)
529: FROM po_lines_interface intf_lines,
530: po_headers_interface intf_headers
531: WHERE intf_lines.interface_header_id = intf_headers.interface_header_id
532: AND intf_lines.processing_id = PO_PDOI_PARAMS.g_processing_id
533: AND intf_headers.processing_round_num =

Line 699: /* Bug 6940325 Added the clause "AND intf_lines.po_line_id IS ....." to ensure the index PO_LINES_INTERFACE_N8 is picked.

695:
696: -- bug4703480
697: -- Add optimizer hint to ensure execution sequence
698:
699: /* Bug 6940325 Added the clause "AND intf_lines.po_line_id IS ....." to ensure the index PO_LINES_INTERFACE_N8 is picked.
700: This fix is done as the CBO was starting from the po_line_locations_interface index.*/
701:
702: -- search interface table
703: FORALL i IN INDICES OF l_processing_row_tbl

Line 708: FROM (SELECT /+ INDEX(intf_lines PO_LINES_INTERFACE_N8) /

704: INSERT INTO po_session_gt(key, num1, num2)
705: SELECT l_key,
706: p_po_line_id_tbl(i),
707: v.max_shipment_num
708: FROM (SELECT /*+ INDEX(intf_lines PO_LINES_INTERFACE_N8) */
709: max(intf_locs.shipment_num) AS max_shipment_num
710: FROM po_line_locations_interface intf_locs,
711: po_lines_interface intf_lines,
712: po_headers_interface intf_headers

Line 711: po_lines_interface intf_lines,

707: v.max_shipment_num
708: FROM (SELECT /*+ INDEX(intf_lines PO_LINES_INTERFACE_N8) */
709: max(intf_locs.shipment_num) AS max_shipment_num
710: FROM po_line_locations_interface intf_locs,
711: po_lines_interface intf_lines,
712: po_headers_interface intf_headers
713: WHERE intf_locs.interface_line_id = intf_lines.interface_line_id
714: AND intf_lines.interface_header_id = intf_headers.interface_header_id
715: AND intf_locs.processing_id = PO_PDOI_PARAMS.g_processing_id

Line 944: Ideally search should start from po_lines_interface.*/

940: d_position := 10;
941:
942: /* Bug 6940325 Added the clause "AND intf_lines.po_line_id IS ....." to improve the performance.
943: This fix is done as the CBO was starting from the po_line_locations_interface index.
944: Ideally search should start from po_lines_interface.*/
945:
946: -- check interface table records which is before current records
947: FORALL i IN 1..l_index_tbl.COUNT
948: INSERT INTO po_session_gt(key, num1)

Line 952: po_lines_interface intf_lines,

948: INSERT INTO po_session_gt(key, num1)
949: SELECT l_key,
950: l_index_tbl(i)
951: FROM po_line_locations_interface intf_locs,
952: po_lines_interface intf_lines,
953: po_headers_interface intf_headers
954: WHERE intf_locs.interface_line_id = intf_lines.interface_line_id
955: AND intf_lines.interface_header_id = intf_headers.interface_header_id
956: AND intf_locs.processing_id = PO_PDOI_PARAMS.g_processing_id