Query for re-open the finally closed PO in Oracle R12/11i
update po_headers_all
set closed_code = 'OPEN',
authorization_status = 'REQUIRES REAPPROVAL'
approved_flag = 'R',
wf_item_type = NULL,
wf_item_key = NULL
where po_header_id = 62170;
update po_action_history
set action_code = 'NO ACTION',
action_date = trunc(sysdate),
note = 'updated by reset script on '||to_char(trunc(sysdate))
where object_id = 62170 --po_header_id
and object_type_code = 'PO'
and object_sub_type_code in ('STANDARD','PLANNED');
set closed_code = 'OPEN',
authorization_status = 'REQUIRES REAPPROVAL'
approved_flag = 'R',
wf_item_type = NULL,
wf_item_key = NULL
where po_header_id = 62170;
update po_action_history
set action_code = 'NO ACTION',
action_date = trunc(sysdate),
note = 'updated by reset script on '||to_char(trunc(sysdate))
where object_id = 62170 --po_header_id
and object_type_code = 'PO'
and object_sub_type_code in ('STANDARD','PLANNED');
No comments:
Post a Comment