DBA Data[Home] [Help]

APPS.PON_VALIDATE_ITEM_PRICES_INT dependencies on PER_JOBS_VL

Line 2026: per_jobs_vl pjvl

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