DBA Data[Home] [Help]

APPS.HXC_RPT_LOAD_TC_SNAPSHOT dependencies on HXC_LAYOUTS

Line 763: FROM hxc_layouts hl,

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

Line 2576: FROM hxc_layouts hl,

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