DBA Data[Home] [Help]

APPS.PO_DOCUMENT_CONTROL_PVT dependencies on PO_LINES_ARCHIVE

Line 3218: UPDATE po_lines_archive pla

3214:
3215: /* Bug 2781710: We should update the note_to_vendor column
3216: in the archive table also. */
3217:
3218: UPDATE po_lines_archive pla
3219: SET pla.note_to_vendor = p_note_to_vendor
3220: WHERE pla.po_line_id = p_doc_line_id AND
3221: pla.po_header_id = p_doc_id AND
3222: pla.revision_num = (SELECT poh.revision_num