DBA Data[Home] [Help]

APPS.PO_PDOI_MAINPROC_UTL_PVT dependencies on PO_DISTRIBUTIONS_INTERFACE

Line 1108: FROM po_distributions_interface intf_dists,

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
1111: WHERE intf_dists.interface_line_location_id =
1112: intf_locs.interface_line_location_id

Line 1360: FROM po_distributions_interface intf_dists,

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