DBA Data[Home] [Help]

APPS.PO_PDOI_MAINPROC_UTL_PVT dependencies on PO_DISTRIBUTIONS_INTERFACE

Line 1105: FROM po_distributions_interface intf_dists,

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
1108: WHERE intf_dists.interface_line_location_id =
1109: intf_locs.interface_line_location_id

Line 1357: FROM po_distributions_interface intf_dists,

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