1831: UPDATE pon_item_prices_interface p1
1832: SET job_id =
1833: (SELECT nvl(max(poj.job_id),-1)
1834: FROM po_job_associations poj,
1835: per_jobs pj,
1836: per_jobs_vl pjvl
1837: WHERE pjvl.name = p1.item_number AND
1838: pjvl.job_id = pj.job_id AND
1839: pj.job_id = poj.job_id AND
1832: SET job_id =
1833: (SELECT nvl(max(poj.job_id),-1)
1834: FROM po_job_associations poj,
1835: per_jobs pj,
1836: per_jobs_vl pjvl
1837: WHERE pjvl.name = p1.item_number AND
1838: pjvl.job_id = pj.job_id AND
1839: pj.job_id = poj.job_id AND
1840: sysdate < nvl(poj.inactive_date, sysdate + 1) AND