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.XNP_CVU_PKG dependencies on XNP_GEO_HIERARCHY

Line 495: FROM xnp_geo_hierarchy gho

491:
492: CURSOR c_bad_nodes IS
493: SELECT gho.child_geo_area_id child,
494: gho.parent_geo_area_id parent
495: FROM xnp_geo_hierarchy gho
496: WHERE NOT EXISTS
497: (SELECT 'X'
498: FROM xnp_geo_hierarchy ghi
499: WHERE ghi.child_geo_area_id = gho.child_geo_area_id

Line 498: FROM xnp_geo_hierarchy ghi

494: gho.parent_geo_area_id parent
495: FROM xnp_geo_hierarchy gho
496: WHERE NOT EXISTS
497: (SELECT 'X'
498: FROM xnp_geo_hierarchy ghi
499: WHERE ghi.child_geo_area_id = gho.child_geo_area_id
500: AND ghi.parent_geo_area_id = gho.parent_geo_area_id
501: -- START WITH parent_geo_area_id = 0
502: START WITH parent_geo_area_id = (select geo_area_id from xnp_geo_areas_b