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 766: hxc_layout_components hlc,

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

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

2659: layout_component_id,
2660: component_name,
2661: attribute
2662: FROM (
2663: SELECT /*+ INDEX( hlc HXC_LAYOUT_COMPONENTS_FK1 )
2664: INDEX( hlcq HXC_LAYOUT_COMP_QUALIFIERS_FK1) */
2665: hlc.layout_id ,
2666: hlc.layout_component_id ,
2667: REGEXP_REPLACE(hlc.component_name,'.*- ') component_name,

Line 2672: hxc_layout_components hlc,

2668: hlcq.qualifier_attribute1 vo_name,
2669: 'ATTRIBUTE'||RANK() OVER ( PARTITION BY hlc.layout_id
2670: ORDER BY hlc.layout_component_id ) AS attribute
2671: FROM hxc_layouts hl,
2672: hxc_layout_components hlc,
2673: hxc_layout_comp_qualifiers hlcq
2674: WHERE hlc.layout_id = hl.layout_id
2675: AND hl.layout_type = 'TIMECARD'
2676: AND hlcq.layout_component_id = hlc.layout_component_id