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_INLINE_NOTIF_UTILS_PKG dependencies on HXC_TIME_ATTRIBUTE_USAGES

Line 73: 'from hxc_time_building_blocks tbb, hxc_time_attribute_usages htau, hxc_time_attributes hta

69:
70: if(p_get_type = c_new_get_type) then
71: if p_context like 'PAEXPITDFF%' THEN
72: l_query := l_query ||
73: 'from hxc_time_building_blocks tbb, hxc_time_attribute_usages htau, hxc_time_attributes hta
74: where htau.time_building_block_id= :p_det_bb_id
75: and htau.time_building_block_ovn = :p_det_bb_ovn
76: and tbb.time_building_block_id = htau.time_building_block_id
77: and tbb.object_version_number = htau.time_building_block_ovn

Line 83: 'from hxc_time_building_blocks tbb, hxc_time_attribute_usages htau, hxc_time_attributes hta, hxc_bld_blk_info_types bbit

79: and htau.time_attribute_id = hta.time_attribute_id
80: and hta.attribute_category = :p_context';
81: else
82: l_query := l_query ||
83: 'from hxc_time_building_blocks tbb, hxc_time_attribute_usages htau, hxc_time_attributes hta, hxc_bld_blk_info_types bbit
84: where htau.time_building_block_id= :p_det_bb_id
85: and htau.time_building_block_ovn = :p_det_bb_ovn
86: and tbb.time_building_block_id = htau.time_building_block_id
87: and tbb.object_version_number = htau.time_building_block_ovn

Line 96: 'from hxc_time_attribute_usages htau, hxc_time_attributes hta

92: end if;
93: else
94: if p_context like 'PAEXPITDFF%' THEN
95: l_query := l_query ||
96: 'from hxc_time_attribute_usages htau, hxc_time_attributes hta
97: where htau.time_building_block_id= :p_det_bb_id
98: and htau.time_building_block_ovn = :p_det_bb_ovn
99: and htau.time_attribute_id = hta.time_attribute_id
100: and hta.attribute_category = :p_context';

Line 103: 'from hxc_time_attribute_usages htau, hxc_time_attributes hta, hxc_bld_blk_info_types bbit

99: and htau.time_attribute_id = hta.time_attribute_id
100: and hta.attribute_category = :p_context';
101: else
102: l_query := l_query ||
103: 'from hxc_time_attribute_usages htau, hxc_time_attributes hta, hxc_bld_blk_info_types bbit
104: where htau.time_building_block_id= :p_det_bb_id
105: and htau.time_building_block_ovn = :p_det_bb_ovn
106: and htau.time_attribute_id = hta.time_attribute_id
107: and hta.bld_blk_info_type_id = bbit.bld_blk_info_type_id

Line 320: hxc_time_attribute_usages au,

316: ,'N' NEW
317: ,'N' CHANGED
318: ,'N' PROCESS
319: from hxc_time_attributes a,
320: hxc_time_attribute_usages au,
321: hxc_bld_blk_info_types bbit
322: where au.time_building_block_id = p_building_block_id
323: and au.time_building_block_ovn = p_ovn
324: and au.time_attribute_id = a.time_attribute_id

Line 828: hxc_time_attribute_usages tau,

824: -- and building block info type for each alias name
825: l_query:= 'select ta.'|| l_select;
826: l_query:= l_query || ' from
827: hxc_time_attributes ta,
828: hxc_time_attribute_usages tau,
829: HXC_BLD_BLK_INFO_TYPES bbit
830: where tau.time_building_block_id = :l_time_building_block_id and tau.time_building_block_ovn = :l_time_building_block_ovn
831: and tau.time_attribute_id = ta.time_attribute_id
832: and bbit.bld_blk_info_type_id = ta.bld_blk_info_type_id