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 278: po_headers_interface intf_headers

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

Line 530: po_headers_interface intf_headers

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

Line 712: po_headers_interface intf_headers

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

Line 953: po_headers_interface intf_headers

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

Line 1107: po_headers_interface intf_headers

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

Line 1359: po_headers_interface intf_headers

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