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_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 2379: --- INDEX(tau1 HXC_TIME_ATTRIBUTE_USAGES_FK1) */

2375: --- SELECT 1
2376: --- FROM hxc_latest_details tbb
2377: --- WHERE 1=1 AND (tbb.time_building_block_id,tbb.object_version_number)in (
2378: --- select /*+ LEADING(ta1) INDEX(ta1)
2379: --- INDEX(tau1 HXC_TIME_ATTRIBUTE_USAGES_FK1) */
2380: --- tau1.time_building_block_id,tau1.time_building_block_ovn from
2381: --- hxc_time_attribute_usages tau1,
2382: --- hxc_time_attributes ta1
2383: --- where tau1.time_building_block_id = tbb.time_building_block_id

Line 2381: --- hxc_time_attribute_usages tau1,

2377: --- WHERE 1=1 AND (tbb.time_building_block_id,tbb.object_version_number)in (
2378: --- select /*+ LEADING(ta1) INDEX(ta1)
2379: --- INDEX(tau1 HXC_TIME_ATTRIBUTE_USAGES_FK1) */
2380: --- tau1.time_building_block_id,tau1.time_building_block_ovn from
2381: --- hxc_time_attribute_usages tau1,
2382: --- hxc_time_attributes ta1
2383: --- where tau1.time_building_block_id = tbb.time_building_block_id
2384: --- AND tau1.time_building_block_ovn = tbb.object_version_number
2385: --- AND tau1.time_attribute_id = ta1.time_attribute_id

Line 2413: --- 7971698 TABLE ACCESS BY INDEX ROWID HXC_TIME_ATTRIBUTE_USAGES (cr=84033 pr=64115 pw=0 time=55803941 us)

2409: --- 3395698 HASH JOIN (cr=234278 pr=228654 pw=25995 time=176797447 us)
2410: --- 5070998 TABLE ACCESS FULL HXC_TIME_BUILDING_BLOCKS (cr=137452 pr=125820 pw=0 time=76065499 us)
2411: --- 3402919 HASH JOIN (cr=96826 pr=76824 pw=0 time=58232636 us)
2412: --- 1108942 TABLE ACCESS FULL HXC_LATEST_DETAILS (cr=12793 pr=12709 pw=0 time=1109375 us)
2413: --- 7971698 TABLE ACCESS BY INDEX ROWID HXC_TIME_ATTRIBUTE_USAGES (cr=84033 pr=64115 pw=0 time=55803941 us)
2414: --- 7971698 INDEX FULL SCAN HXC_TIME_ATTRIBUTE_USAGES_FK1 (cr=19245 pr=17458 pw=0 time=15977131 us)(object id 75329)
2415: --- 3395698 TABLE ACCESS BY INDEX ROWID HXC_TIME_BUILDING_BLOCKS (cr=10187096 pr=460559 pw=0 time=182819518 us)
2416: --- 3395698 INDEX UNIQUE SCAN HXC_TIME_BUILDING_BLOCKS_PK (cr=6791398 pr=81265 pw=0 time=49309421 us)(object id 249842)
2417: --- 3395698 TABLE ACCESS BY INDEX ROWID HXC_TIMECARD_SUMMARY (cr=10187096 pr=44893 pw=0 time=67496066 us)

Line 2414: --- 7971698 INDEX FULL SCAN HXC_TIME_ATTRIBUTE_USAGES_FK1 (cr=19245 pr=17458 pw=0 time=15977131 us)(object id 75329)

2410: --- 5070998 TABLE ACCESS FULL HXC_TIME_BUILDING_BLOCKS (cr=137452 pr=125820 pw=0 time=76065499 us)
2411: --- 3402919 HASH JOIN (cr=96826 pr=76824 pw=0 time=58232636 us)
2412: --- 1108942 TABLE ACCESS FULL HXC_LATEST_DETAILS (cr=12793 pr=12709 pw=0 time=1109375 us)
2413: --- 7971698 TABLE ACCESS BY INDEX ROWID HXC_TIME_ATTRIBUTE_USAGES (cr=84033 pr=64115 pw=0 time=55803941 us)
2414: --- 7971698 INDEX FULL SCAN HXC_TIME_ATTRIBUTE_USAGES_FK1 (cr=19245 pr=17458 pw=0 time=15977131 us)(object id 75329)
2415: --- 3395698 TABLE ACCESS BY INDEX ROWID HXC_TIME_BUILDING_BLOCKS (cr=10187096 pr=460559 pw=0 time=182819518 us)
2416: --- 3395698 INDEX UNIQUE SCAN HXC_TIME_BUILDING_BLOCKS_PK (cr=6791398 pr=81265 pw=0 time=49309421 us)(object id 249842)
2417: --- 3395698 TABLE ACCESS BY INDEX ROWID HXC_TIMECARD_SUMMARY (cr=10187096 pr=44893 pw=0 time=67496066 us)
2418: --- 3395698 INDEX UNIQUE SCAN HXC_TIMECARD_SUMMARY_PK (cr=6791398 pr=4725 pw=0 time=28993073 us)(object id 211692)

Line 2437: ---- INDEX(tau1 HXC_TIME_ATTRIBUTE_USAGES_FK1) */

2433: ---- WHERE 1=1 AND (tbb.time_building_block_id,tbb.object_version_number)in (
2434: ---- select /*+ UNNEST
2435: ---- USE_NL(ta1 tau1)
2436: ---- INDEX(ta1 HXC_TIME_ATTRIBUTES_FK4)
2437: ---- INDEX(tau1 HXC_TIME_ATTRIBUTE_USAGES_FK1) */
2438: ---- tau1.time_building_block_id,tau1.time_building_block_ovn from
2439: ---- hxc_time_attribute_usages tau1,
2440: ---- hxc_time_attributes ta1
2441: ---- where tau1.time_building_block_id = tbb.time_building_block_id

Line 2439: ---- hxc_time_attribute_usages tau1,

2435: ---- USE_NL(ta1 tau1)
2436: ---- INDEX(ta1 HXC_TIME_ATTRIBUTES_FK4)
2437: ---- INDEX(tau1 HXC_TIME_ATTRIBUTE_USAGES_FK1) */
2438: ---- tau1.time_building_block_id,tau1.time_building_block_ovn from
2439: ---- hxc_time_attribute_usages tau1,
2440: ---- hxc_time_attributes ta1
2441: ---- where tau1.time_building_block_id = tbb.time_building_block_id
2442: ---- AND tau1.time_building_block_ovn = tbb.object_version_number
2443: ---- AND tau1.time_attribute_id = ta1.time_attribute_id

Line 2472: --- | 5 | TABLE ACCESS BY INDEX ROWID | HXC_TIME_ATTRIBUTE_USAGES |

2468: --- |* 1 | FILTER | |
2469: --- | 2 | FAST DUAL | |
2470: --- |* 3 | FILTER | |
2471: --- |* 4 | HASH JOIN | |
2472: --- | 5 | TABLE ACCESS BY INDEX ROWID | HXC_TIME_ATTRIBUTE_USAGES |
2473: --- | 6 | NESTED LOOPS | |
2474: --- |* 7 | TABLE ACCESS BY INDEX ROWID| HXC_TIME_ATTRIBUTES |
2475: --- |* 8 | INDEX RANGE SCAN | HXC_TIME_ATTRIBUTES_FK4 |
2476: --- |* 9 | INDEX RANGE SCAN | HXC_TIME_ATTRIBUTE_USAGES_FK1 |

Line 2476: --- |* 9 | INDEX RANGE SCAN | HXC_TIME_ATTRIBUTE_USAGES_FK1 |

2472: --- | 5 | TABLE ACCESS BY INDEX ROWID | HXC_TIME_ATTRIBUTE_USAGES |
2473: --- | 6 | NESTED LOOPS | |
2474: --- |* 7 | TABLE ACCESS BY INDEX ROWID| HXC_TIME_ATTRIBUTES |
2475: --- |* 8 | INDEX RANGE SCAN | HXC_TIME_ATTRIBUTES_FK4 |
2476: --- |* 9 | INDEX RANGE SCAN | HXC_TIME_ATTRIBUTE_USAGES_FK1 |
2477: --- | 10 | TABLE ACCESS BY INDEX ROWID | HXC_LATEST_DETAILS |
2478: --- | 11 | INDEX RANGE SCAN | HXC_LATEST_DETAILS_FK |
2479: --- | 12 | NESTED LOOPS | |
2480: --- | 13 | NESTED LOOPS | |

Line 2544: INDEX(tau1 HXC_TIME_ATTRIBUTE_USAGES_FK1) */

2540: select /*+ UNNEST
2541: LEADING(ta1)
2542: USE_NL(ta1 tau1)
2543: INDEX(ta1 HTA_HINT)
2544: INDEX(tau1 HXC_TIME_ATTRIBUTE_USAGES_FK1) */
2545: tau1.time_building_block_id,
2546: tau1.time_building_block_ovn
2547: from hxc_time_attribute_usages tau1,
2548: hxc_time_attributes ta1

Line 2547: from hxc_time_attribute_usages tau1,

2543: INDEX(ta1 HTA_HINT)
2544: INDEX(tau1 HXC_TIME_ATTRIBUTE_USAGES_FK1) */
2545: tau1.time_building_block_id,
2546: tau1.time_building_block_ovn
2547: from hxc_time_attribute_usages tau1,
2548: hxc_time_attributes ta1
2549: where tau1.time_building_block_id = tbb.time_building_block_id
2550: AND tau1.time_building_block_ovn = tbb.object_version_number
2551: AND tau1.time_attribute_id = ta1.time_attribute_id

Line 2572: INDEX(tau1 HXC_TIME_ATTRIBUTE_USAGES_FK1) */

2568: select /*+ UNNEST
2569: LEADING(ta1)
2570: USE_NL(ta1 tau1)
2571: INDEX(ta1 HTA_HINT)
2572: INDEX(tau1 HXC_TIME_ATTRIBUTE_USAGES_FK1) */
2573: tau1.time_building_block_id,
2574: tau1.time_building_block_ovn
2575: from hxc_time_attribute_usages tau1,
2576: hxc_time_attributes ta1

Line 2575: from hxc_time_attribute_usages tau1,

2571: INDEX(ta1 HTA_HINT)
2572: INDEX(tau1 HXC_TIME_ATTRIBUTE_USAGES_FK1) */
2573: tau1.time_building_block_id,
2574: tau1.time_building_block_ovn
2575: from hxc_time_attribute_usages tau1,
2576: hxc_time_attributes ta1
2577: where tau1.time_building_block_id = tbb.time_building_block_id
2578: AND tau1.time_building_block_ovn = tbb.object_version_number
2579: AND tau1.time_attribute_id = ta1.time_attribute_id

Line 3194: hxc_time_attribute_usages tau,

3190:
3191: l_query := '
3192: select sum(ta.'||l_segment1||')
3193: from hxc_time_attributes ta,
3194: hxc_time_attribute_usages tau,
3195: hxc_time_building_blocks tbb
3196: where
3197: tbb.scope = :p_scope
3198: AND tbb.resource_id = :p_resource_id

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

3221: l_segment_outer:=t_consolidated_info(l_index).segment;
3222:
3223: if(l_field_value_outer is not null) then
3224:
3225: l_field_value:= l_field_value||' AND EXISTS ( select 1 from hxc_time_attribute_usages tau2,
3226: hxc_time_attributes ta2
3227: where tau2.time_building_block_id = tbb.time_building_block_id
3228: AND tau2.time_building_block_ovn = tbb.object_version_number
3229: AND tau2.time_attribute_id = ta2.time_attribute_id

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

3233:
3234: else
3235:
3236:
3237: l_field_value:= l_field_value||' AND EXISTS ( select 1 from hxc_time_attribute_usages tau2,
3238: hxc_time_attributes ta2
3239: where tau2.time_building_block_id = tbb.time_building_block_id
3240: AND tau2.time_building_block_ovn = tbb.object_version_number
3241: AND tau2.time_attribute_id = ta2.time_attribute_id