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 700: This fix is done as the CBO was starting from the po_line_locations_interface index.*/

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

Line 710: FROM po_line_locations_interface intf_locs,

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

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

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

Line 951: FROM po_line_locations_interface intf_locs,

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

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

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

Line 1106: po_line_locations_interface intf_locs,

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

Line 1358: po_line_locations_interface intf_locs,

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