2021: UPDATE pon_item_prices_interface p1
2022: SET job_id =
2023: (SELECT nvl(max(poj.job_id),-1)
2024: FROM po_job_associations poj,
2025: per_jobs pj,
2026: per_jobs_vl pjvl
2027: WHERE pjvl.name = p1.item_number AND
2028: pjvl.job_id = pj.job_id AND
2029: pj.job_id = poj.job_id AND
2022: SET job_id =
2023: (SELECT nvl(max(poj.job_id),-1)
2024: FROM po_job_associations poj,
2025: per_jobs pj,
2026: per_jobs_vl pjvl
2027: WHERE pjvl.name = p1.item_number AND
2028: pjvl.job_id = pj.job_id AND
2029: pj.job_id = poj.job_id AND
2030: sysdate < nvl(poj.inactive_date, sysdate + 1) AND