APPS.PO_DOCUMENT_CONTROL_PVT dependencies on PO_HEADERS_ARCHIVE
Line 3395: UPDATE po_headers_archive pha
3391:
3392: /* Bug 2781710: We should update the note_to_vendor column
3393: in the archive table also. */
3394: 3395: UPDATE po_headers_archive pha 3396: SET pha.note_to_vendor = p_note_to_vendor
3397: WHERE pha.po_header_id = p_doc_id AND
3398: pha.revision_num = (SELECT poh.revision_num
3399: FROM po_headers poh