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.OKL_PA_DATA_INTEGRITY dependencies on OKL_K_HEADERS

Line 459: WHERE vpa.crs_id = (select crs_id from okl_k_headers where id = cp_chr_id)

455: vpa.assoc_object_id,
456: vpa.assoc_object_version
457: FROM okl_vp_associations vpa,
458: okl_vp_change_requests creq
459: WHERE vpa.crs_id = (select crs_id from okl_k_headers where id = cp_chr_id)
460: AND vpa.crs_id = creq.id
461: AND creq.status_code in ('PASSED','NEW','INCOMPLETE')
462: */
463:

Line 573: okl_k_headers okl

569: SELECT lat.name
570: FROM OKL_LEASEAPP_TMPLS lat,
571: okl_vp_associations_v vpa,
572: okl_vp_change_requests chreq,
573: okl_k_headers okl
574: WHERE lat.id = vpa.assoc_object_id
575: AND vpa.assoc_object_type_code = 'LA_TEMPLATE'
576: AND okl.id = cp_chr_id
577: AND vpa.crs_id = okl.crs_id