DBA Data[Home] [Help]

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