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_LINE_LOCATIONS_INTERFACE

Line 703: This fix is done as the CBO was starting from the po_line_locations_interface index.*/

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
707: INSERT INTO po_session_gt(key, num1, num2)

Line 713: FROM po_line_locations_interface intf_locs,

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
716: WHERE intf_locs.interface_line_id = intf_lines.interface_line_id
717: AND intf_lines.interface_header_id = intf_headers.interface_header_id

Line 946: This fix is done as the CBO was starting from the po_line_locations_interface index.

942:
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

Line 954: FROM po_line_locations_interface intf_locs,

950: FORALL i IN 1..l_index_tbl.COUNT
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

Line 1106: FROM (SELECT /+ leading(intf_locs) INDEX(intf_locs PO_LINE_LOCATIONS_INTERFACE_N4) /

1102: INSERT INTO po_session_gt(key, num1, num2)
1103: SELECT l_key,
1104: p_line_loc_id_tbl(i),
1105: v.max_dist_num
1106: FROM (SELECT /*+ leading(intf_locs) INDEX(intf_locs PO_LINE_LOCATIONS_INTERFACE_N4) */
1107: max(intf_dists.distribution_num) AS max_dist_num
1108: FROM po_distributions_interface intf_dists,
1109: po_line_locations_interface intf_locs,
1110: po_headers_interface intf_headers

Line 1109: po_line_locations_interface intf_locs,

1105: v.max_dist_num
1106: FROM (SELECT /*+ leading(intf_locs) INDEX(intf_locs PO_LINE_LOCATIONS_INTERFACE_N4) */
1107: max(intf_dists.distribution_num) AS max_dist_num
1108: FROM po_distributions_interface intf_dists,
1109: po_line_locations_interface intf_locs,
1110: po_headers_interface intf_headers
1111: WHERE intf_dists.interface_line_location_id =
1112: intf_locs.interface_line_location_id
1113: AND intf_locs.interface_header_id = intf_headers.interface_header_id

Line 1361: po_line_locations_interface intf_locs,

1357: INSERT INTO po_session_gt(key, num1)
1358: SELECT /*+ LEADING(intf_locs) */ l_key,
1359: l_index_tbl(i)
1360: FROM po_distributions_interface intf_dists,
1361: po_line_locations_interface intf_locs,
1362: po_headers_interface intf_headers
1363: WHERE intf_dists.interface_line_location_id =
1364: intf_locs.interface_line_location_id
1365: AND intf_locs.interface_header_id = intf_headers.interface_header_id