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.HXC_HAD_BUS dependencies on HXC_PREF_HIERARCHIES

Line 376: FROM hxc_pref_hierarchies hph,

372: --
373: CURSOR get_num_hierarchy_occurances
374: IS
375: SELECT count(*)
376: FROM hxc_pref_hierarchies hph,
377: hxc_pref_definitions hpd,
378: hxc_pref_hierarchies hph1
379: WHERE hph.pref_definition_id = hpd.pref_definition_id
380: AND hpd.code = 'TC_W_TCRD_ALIASES'

Line 378: hxc_pref_hierarchies hph1

374: IS
375: SELECT count(*)
376: FROM hxc_pref_hierarchies hph,
377: hxc_pref_definitions hpd,
378: hxc_pref_hierarchies hph1
379: WHERE hph.pref_definition_id = hpd.pref_definition_id
380: AND hpd.code = 'TC_W_TCRD_ALIASES'
381: AND (hph.attribute1 = TO_CHAR(p_alias_definition_id)
382: OR hph.attribute2 = TO_CHAR(p_alias_definition_id)