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 7691: from pn_rec_arcl_dtlln_all

7687: SELECT 'Y'
7688: FROM dual
7689: WHERE exists
7690: (select area_class_dtl_line_id
7691: from pn_rec_arcl_dtlln_all
7692: where location_id in
7693: (select loc.location_id
7694: from pn_locations_all loc
7695: connect by prior loc.location_id = loc.parent_location_id

Line 7704: from pn_rec_arcl_dtlln_all arclDtl

7700: select 'Y'
7701: from dual
7702: where exists
7703: (select arclDtl.area_class_dtl_line_id
7704: from pn_rec_arcl_dtlln_all arclDtl
7705: where arclDtl.location_id = p_location_id
7706: and (arclDtl.from_date between p_active_start_date
7707: and p_active_end_date
7708: or