Monday, 26 August 2019

DML for opening a 'Finally Closed' PO in Oracle Apps

UPDATE po_headers_all 
SET    closed_code = 'OPEN' --FINALLY CLOSED
WHERE  segment1 = '<PO_NUMBER>';

UPDATE po_lines_all 
SET    closed_flag=NULL, 
       closed_code = 'OPEN', --FINALLY CLOSED 
       closed_date = NULL,   --01-AUG-19 
       closed_reason = NULL, --NULL 
       closed_by = NULL     --1583 
where  po_line_id = <PO_LINE_ID>;

UPDATE po_line_locations_all 
SET    closed_code = 'OPEN',             --FINALLY CLOSED 
       closed_date = NULL,               --01-AUG-19 
       closed_by = NULL,                 --1583 
       closed_for_receiving_date = NULL, --01-AUG-19 
       closed_for_invoice_date = NULL    --01-AUG-19 
WHERE  po_line_id = <PO_LINE_ID>;

No comments:

Post a Comment