When PO is finally closed and you want to re-open in Oracle EBS 11i or R12

When PO is finally closed and you want to re-open in Oracle EBS 11i or R12

Change po_header_id,  po_line_id, Org_id as per your database and PO

update po_line_locations_all

set closed_code='',

    closed_date='',

    CLOSED_FLAG='N'

where po_header_id= 173172

and   po_line_id= 441159

and   org_id= 46;

update po_lines_all

set closed_code='',

    closed_date='',

    CLOSED_FLAG='N'

where po_header_id=173172

and   po_line_id= 441159

and   org_id= 46;

update po_headers_all

set closed_code='',

    closed_date=''   

where po_header_id = 173172  

and   org_id= 46;