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 1834: FROM po_job_associations poj,

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

Line 1852: FROM po_job_associations poj,

1848: UPDATE pon_item_prices_interface p1
1849: SET (item_description, category_name) =
1850: (SELECT poj.job_long_description,
1851: FND_FLEX_EXT.get_segs('INV', 'MCAT', CAT.STRUCTURE_ID, CAT.CATEGORY_ID)
1852: FROM po_job_associations poj,
1853: mtl_categories_kfv cat
1854: WHERE cat.category_id = poj.category_id AND
1855: poj.job_id = p1.job_id)
1856: WHERE batch_id = p_batch_id AND

Line 1910: FROM po_job_associations poj,

1906: (SELECT poj.job_description,
1907: decode(nvl(p1.additional_job_details,'JOB_DETAILS_NONE_ENTERED'),'JOB_DETAILS_NONE_ENTERED',poj.job_long_description, p1.additional_job_details),
1908: cat.category_id,
1909: FND_FLEX_EXT.get_segs('INV', 'MCAT', CAT.STRUCTURE_ID, CAT.CATEGORY_ID)
1910: FROM po_job_associations poj,
1911: mtl_categories_kfv cat
1912: WHERE poj.job_id = p1.job_id
1913: AND cat.category_id = poj.category_id)
1914: WHERE batch_id = p_batch_id AND