2371: AND plaeb.po_line_id = l_po_lines_tbl(i) )
2372: WHERE plda.draft_id = p_draft_id
2373: AND plda.po_line_id = l_po_lines_tbl(i);
2374:
2375: UPDATE po_line_locations_draft_all pllda
2376: SET pllda.amount =
2377: ( SELECT amount
2378: FROM po_lines_draft_all plda
2379: WHERE plda.draft_id = p_draft_id
2381: )
2382: WHERE pllda.draft_id = p_draft_id
2383: AND pllda.po_line_id = l_po_lines_tbl(i)
2384: AND EXISTS (SELECT 'there should be only one shipment with quantity equals to 1'
2385: FROM po_line_locations_draft_all pllda
2386: WHERE pllda.draft_id = p_draft_id
2387: AND pllda.po_line_id = l_po_lines_tbl(i)
2388: AND pllda.amount = 1
2389: HAVING Count(*) = 1);
2414: AND plaeb.po_line_id = l_po_lines_tbl(i) )
2415: WHERE plda.draft_id = p_draft_id
2416: AND plda.po_line_id = l_po_lines_tbl(i);
2417:
2418: UPDATE po_line_locations_draft_all pllda
2419: SET pllda.quantity =
2420: ( SELECT quantity
2421: FROM po_lines_draft_all plda
2422: WHERE plda.draft_id = p_draft_id
2424: )
2425: WHERE pllda.draft_id = p_draft_id
2426: AND pllda.po_line_id = l_po_lines_tbl(i)
2427: AND EXISTS (SELECT 'there should be only one shipment with quantity equlas to 1'
2428: FROM po_line_locations_draft_all pllda
2429: WHERE pllda.draft_id = p_draft_id
2430: AND pllda.po_line_id = l_po_lines_tbl(i)
2431: AND pllda.quantity = 1
2432: HAVING Count(*) = 1);