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_HEADERS_INTERFACE

Line 276: FROM (SELECT /+ INDEX(intf_headers PO_HEADERS_INTERFACE_N5) / -- Added as 9799280 fix

272: INSERT INTO po_session_gt(key, num1, num2)
273: SELECT l_key,
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

Line 279: po_headers_interface intf_headers

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
283: AND intf_headers.processing_id = PO_PDOI_PARAMS.g_processing_id

Line 532: po_headers_interface intf_headers

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 =
536: PO_PDOI_PARAMS.g_current_round_num

Line 715: po_headers_interface intf_headers

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
719: AND intf_headers.processing_round_num =

Line 956: po_headers_interface intf_headers

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
960: AND intf_headers.processing_round_num =

Line 1110: po_headers_interface intf_headers

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
1114: AND intf_dists.processing_id = PO_PDOI_PARAMS.g_processing_id

Line 1362: po_headers_interface intf_headers

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
1366: AND intf_dists.processing_id = PO_PDOI_PARAMS.g_processing_id