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 278: FROM po_lines_interface intf_lines,

274: p_po_header_id_tbl(i),
275: v.max_line_num
276: FROM (SELECT /*+ INDEX(intf_headers PO_HEADERS_INTERFACE_N5) */ -- Added as 9799280 fix
277: max(intf_lines.line_num) AS max_line_num
278: FROM po_lines_interface intf_lines,
279: po_headers_interface intf_headers
280: WHERE intf_lines.interface_header_id = intf_headers.interface_header_id
281: AND intf_lines.processing_id = PO_PDOI_PARAMS.g_processing_id
282: AND intf_headers.processing_round_num = PO_PDOI_PARAMS.g_current_round_num

Line 531: FROM po_lines_interface intf_lines,

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

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

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

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

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

Line 714: po_lines_interface intf_lines,

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

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

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

Line 955: po_lines_interface intf_lines,

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