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_RPT_LOAD_TC_SNAPSHOT dependencies on HXC_LAYOUT_COMPONENTS

Line 764: hxc_layout_components hlc,

760: ) attribute_category,
761: SUBSTR(hlcq.qualifier_attribute27,1,30) attribute,
762: RANK() OVER ( ORDER BY hlc.layout_component_id ) row_num
763: FROM hxc_layouts hl,
764: hxc_layout_components hlc,
765: hxc_layout_comp_qualifiers hlcq
766: WHERE hlc.layout_id = hl.layout_id
767: AND hl.layout_id = p_curr_layout
768: AND hl.layout_type = 'TIMECARD'

Line 2568: SELECT /*+ INDEX( hlc HXC_LAYOUT_COMPONENTS_FK1 )

2564: layout_component_id,
2565: component_name,
2566: attribute
2567: FROM (
2568: SELECT /*+ INDEX( hlc HXC_LAYOUT_COMPONENTS_FK1 )
2569: INDEX( hlcq HXC_LAYOUT_COMP_QUALIFIERS_FK1) */
2570: hlc.layout_id ,
2571: hlc.layout_component_id ,
2572: REGEXP_REPLACE(hlc.component_name,'.*- ') component_name,

Line 2577: hxc_layout_components hlc,

2573: hlcq.qualifier_attribute1 vo_name,
2574: 'ATTRIBUTE'||RANK() OVER ( PARTITION BY hlc.layout_id
2575: ORDER BY hlc.layout_component_id ) AS attribute
2576: FROM hxc_layouts hl,
2577: hxc_layout_components hlc,
2578: hxc_layout_comp_qualifiers hlcq
2579: WHERE hlc.layout_id = hl.layout_id
2580: AND hl.layout_type = 'TIMECARD'
2581: AND hlcq.layout_component_id = hlc.layout_component_id