DBA Data[Home] [Help]

APPS.PO_LINES_SV2 dependencies on PO_LINES_ALL

Line 125: FROM po_lines_all pl

121: --on the corresponding blanket agreement line. The approval workflow
122: --would not update the retroactive_date again
123: UPDATE po_line_locations pll
124: SET retroactive_date = (SELECT pl.retroactive_date
125: FROM po_lines_all pl
126: WHERE pl.po_line_id = pll.po_line_id),
127: --retroactive_date = SYSDATE,
128: last_update_date = SYSDATE,
129: last_updated_by = l_user_id