2705: l_num_list(i),
2706: order_type_lookup_code,
2707: item_id,
2708: job_id
2709: FROM po_lines_all
2710: WHERE po_line_id = x_lines.po_line_id_tbl(i)
2711: AND NOT EXISTS (SELECT 1
2712: FROM po_lines_draft_all
2713: WHERE po_line_id = x_lines.po_line_id_tbl(i)
3375: WHERE po_line_id = txn_lines.po_line_id
3376: AND shipment_type = 'BLANKET')
3377: OR
3378: EXISTS (SELECT 1
3379: FROM po_lines_all
3380: WHERE from_line_id = txn_lines.po_line_id)
3381: );
3382:
3383: DELETE FROM po_session_gt