APPS.HXC_MAPPING_UTILITIES dependencies on HXC_TIME_ATTRIBUTE_USAGES

Line 731: , hxc_time_attribute_usages tau

727: , 'X' process
728: FROM
729: hxc_time_building_blocks bb
730: , hxc_time_attributes ta
731: , hxc_time_attribute_usages tau
732: , hxc_bld_blk_info_types bbit
733: WHERE
734: bb.time_building_block_id = p_bb_id AND
735: bb.object_version_number = p_bb_ovn

Line 815: , hxc_time_attribute_usages tau

811: , 'X'
812: , 'X'
813: FROM
814: hxc_time_attributes ta
815: , hxc_time_attribute_usages tau
816: , hxc_time_building_blocks bb
817: , hxc_bld_blk_info_types bbit
818: WHERE
819: bb.time_building_block_id = p_bb_id AND

Line 2392: INDEX(tau1 HXC_TIME_ATTRIBUTE_USAGES_FK1) */

2388:
2389:
2390: l_field_value:= l_field_value||' AND (tbb.time_building_block_id,tbb.object_version_number)in (
2391: select /*+ LEADING(ta1) INDEX(ta1)
2392: INDEX(tau1 HXC_TIME_ATTRIBUTE_USAGES_FK1) */
2393: tau1.time_building_block_id,tau1.time_building_block_ovn from
2394: hxc_time_attribute_usages tau1,
2395: hxc_time_attributes ta1
2396: where tau1.time_building_block_id = tbb.time_building_block_id

Line 2394: hxc_time_attribute_usages tau1,

2390: l_field_value:= l_field_value||' AND (tbb.time_building_block_id,tbb.object_version_number)in (
2391: select /*+ LEADING(ta1) INDEX(ta1)
2392: INDEX(tau1 HXC_TIME_ATTRIBUTE_USAGES_FK1) */
2393: tau1.time_building_block_id,tau1.time_building_block_ovn from
2394: hxc_time_attribute_usages tau1,
2395: hxc_time_attributes ta1
2396: where tau1.time_building_block_id = tbb.time_building_block_id
2397: AND tau1.time_building_block_ovn = tbb.object_version_number
2398: AND tau1.time_attribute_id = ta1.time_attribute_id

Line 2408: INDEX(tau1 HXC_TIME_ATTRIBUTE_USAGES_FK1) */

2404:
2405:
2406: l_field_value:= l_field_value||' AND (tbb.time_building_block_id,tbb.object_version_number)in (
2407: select /*+ LEADING(ta1) INDEX(ta1)
2408: INDEX(tau1 HXC_TIME_ATTRIBUTE_USAGES_FK1) */
2409: tau1.time_building_block_id,tau1.time_building_block_ovn from
2410: hxc_time_attribute_usages tau1,
2411: hxc_time_attributes ta1
2412: where tau1.time_building_block_id = tbb.time_building_block_id

Line 2410: hxc_time_attribute_usages tau1,

2406: l_field_value:= l_field_value||' AND (tbb.time_building_block_id,tbb.object_version_number)in (
2407: select /*+ LEADING(ta1) INDEX(ta1)
2408: INDEX(tau1 HXC_TIME_ATTRIBUTE_USAGES_FK1) */
2409: tau1.time_building_block_id,tau1.time_building_block_ovn from
2410: hxc_time_attribute_usages tau1,
2411: hxc_time_attributes ta1
2412: where tau1.time_building_block_id = tbb.time_building_block_id
2413: AND tau1.time_building_block_ovn = tbb.object_version_number
2414: AND tau1.time_attribute_id = ta1.time_attribute_id

Line 2962: hxc_time_attribute_usages tau,

2958:
2959: l_query := '
2960: select sum(ta.'||l_segment1||')
2961: from hxc_time_attributes ta,
2962: hxc_time_attribute_usages tau,
2963: hxc_time_building_blocks tbb
2964: where
2965: tbb.scope = :p_scope
2966: AND tbb.resource_id = :p_resource_id

Line 2993: l_field_value:= l_field_value||' AND EXISTS ( select 1 from hxc_time_attribute_usages tau2,

2989: l_segment_outer:=t_consolidated_info(l_index).segment;
2990:
2991: if(l_field_value_outer is not null) then
2992:
2993: l_field_value:= l_field_value||' AND EXISTS ( select 1 from hxc_time_attribute_usages tau2,
2994: hxc_time_attributes ta2
2995: where tau2.time_building_block_id = tbb.time_building_block_id
2996: AND tau2.time_building_block_ovn = tbb.object_version_number
2997: AND tau2.time_attribute_id = ta2.time_attribute_id

Line 3005: l_field_value:= l_field_value||' AND EXISTS ( select 1 from hxc_time_attribute_usages tau2,

3001:
3002: else
3003:
3004:
3005: l_field_value:= l_field_value||' AND EXISTS ( select 1 from hxc_time_attribute_usages tau2,
3006: hxc_time_attributes ta2
3007: where tau2.time_building_block_id = tbb.time_building_block_id
3008: AND tau2.time_building_block_ovn = tbb.object_version_number
3009: AND tau2.time_attribute_id = ta2.time_attribute_id