eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PON_VALIDATE_ITEM_PRICES_INT dependencies on PO_JOB_ASSOCIATIONS

Line 2024: FROM po_job_associations poj,

2020: --
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

Line 2042: FROM po_job_associations poj,

2038: UPDATE pon_item_prices_interface p1
2039: SET (item_description, category_name) =
2040: (SELECT poj.job_long_description,
2041: FND_FLEX_EXT.get_segs('INV', 'MCAT', CAT.STRUCTURE_ID, CAT.CATEGORY_ID)
2042: FROM po_job_associations poj,
2043: mtl_categories_kfv cat
2044: WHERE cat.category_id = poj.category_id AND
2045: poj.job_id = p1.job_id)
2046: WHERE batch_id = p_batch_id AND

Line 2100: FROM po_job_associations poj,

2096: (SELECT poj.job_description,
2097: decode(nvl(p1.additional_job_details,'JOB_DETAILS_NONE_ENTERED'),'JOB_DETAILS_NONE_ENTERED',poj.job_long_description, p1.additional_job_details),
2098: cat.category_id,
2099: FND_FLEX_EXT.get_segs('INV', 'MCAT', CAT.STRUCTURE_ID, CAT.CATEGORY_ID)
2100: FROM po_job_associations poj,
2101: mtl_categories_kfv cat
2102: WHERE poj.job_id = p1.job_id
2103: AND cat.category_id = poj.category_id)
2104: WHERE batch_id = p_batch_id AND