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.

[Home] [Help]

APPS.HXC_RPT_LOAD_TC_SNAPSHOT dependencies on HXC_LAYOUTS

Line 765: FROM hxc_layouts hl,

761: SUBSTR(hlcq.qualifier_attribute26,1,30)
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

Line 2671: FROM hxc_layouts hl,

2667: REGEXP_REPLACE(hlc.component_name,'.*- ') component_name,
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'