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.PNP_UTIL_FUNC dependencies on PN_REC_ARCL_DTLLN_ALL

Line 7858: from pn_rec_arcl_dtlln_all

7854: SELECT 'Y'
7855: FROM dual
7856: WHERE exists
7857: (select area_class_dtl_line_id
7858: from pn_rec_arcl_dtlln_all
7859: where location_id in
7860: (select loc.location_id
7861: from pn_locations_all loc
7862: connect by prior loc.location_id = loc.parent_location_id

Line 7871: from pn_rec_arcl_dtlln_all arclDtl

7867: select 'Y'
7868: from dual
7869: where exists
7870: (select arclDtl.area_class_dtl_line_id
7871: from pn_rec_arcl_dtlln_all arclDtl
7872: where arclDtl.location_id = p_location_id
7873: and (arclDtl.from_date between p_active_start_date
7874: and p_active_end_date
7875: or