1083: SELECT l_key,
1084: p_line_loc_id_tbl(i),
1085: v.max_dist_num
1086: FROM (SELECT max(distribution_num) AS max_dist_num
1087: FROM po_distributions_draft_all
1088: WHERE draft_id = p_draft_id_tbl(i)
1089: AND line_location_id = p_line_loc_id_tbl(i)) v
1090: WHERE v.max_dist_num IS NOT NULL;
1091:
1341: FORALL i IN 1..l_index_tbl.COUNT
1342: INSERT INTO po_session_gt(key, num1)
1343: SELECT l_key,
1344: l_index_tbl(i)
1345: FROM po_distributions_draft_all
1346: WHERE line_location_id = p_line_loc_id_tbl(i)
1347: AND draft_id = p_draft_id_tbl(i)
1348: AND distribution_num = p_dist_num_tbl(i);
1349: