DBA Data[Home] [Help]

APPS.PON_VALIDATE_ITEM_PRICES_INT dependencies on PER_JOBS

Line 1835: per_jobs pj,

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

Line 1836: per_jobs_vl pjvl

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