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_BUILDING_BLOCKS

Line 21: hxc_time_building_blocks bb

17: , bb.measure
18: , bb.date_to
19: , bb.comment_text
20: FROM
21: hxc_time_building_blocks bb
22: WHERE
23: bb.object_version_number = (
24: SELECT MAX(bb1.object_version_number)
25: FROM hxc_time_building_blocks bb1

Line 25: FROM hxc_time_building_blocks bb1

21: hxc_time_building_blocks bb
22: WHERE
23: bb.object_version_number = (
24: SELECT MAX(bb1.object_version_number)
25: FROM hxc_time_building_blocks bb1
26: WHERE bb1.time_building_block_id = bb.time_building_block_id )
27: AND
28: ((
29: p_start_date BETWEEN

Line 150: FROM hxc_time_building_blocks bb

146: FUNCTION get_day_date ( p_type VARCHAR2, p_bb_id NUMBER, p_bb_ovn NUMBER ) RETURN DATE IS
147:
148: CURSOR csr_get_start IS
149: SELECT start_time
150: FROM hxc_time_building_blocks bb
151: WHERE bb.time_building_block_id = p_bb_id
152: AND bb.object_version_number = p_bb_ovn;
153:
154: CURSOR csr_get_stop IS

Line 156: FROM hxc_time_building_blocks bb

152: AND bb.object_version_number = p_bb_ovn;
153:
154: CURSOR csr_get_stop IS
155: SELECT stop_time
156: FROM hxc_time_building_blocks bb
157: WHERE bb.time_building_block_id = p_bb_id
158: AND bb.object_version_number = p_bb_ovn;
159:
160: l_date DATE;

Line 729: hxc_time_building_blocks bb

725: , 'X' dummy1
726: , 'X' dummy2
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

Line 765: l_decr_ovn hxc_time_building_blocks.object_version_number%TYPE := 0;

761: RETURN hxc_self_service_time_deposit.building_block_attribute_info IS
762:
763: l_proc VARCHAR2(72);
764:
765: l_decr_ovn hxc_time_building_blocks.object_version_number%TYPE := 0;
766: l_attributes_exist BOOLEAN := TRUE;
767: l_old BINARY_INTEGER := 1;
768: r_old_atts hxc_self_service_time_deposit.attribute_info;
769: t_old_atts hxc_self_service_time_deposit.building_block_attribute_info;

Line 816: , hxc_time_building_blocks bb

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
820: bb.object_version_number = p_decr_ovn AND

Line 1507: hxc_time_building_blocks bb

1503: , bb.measure
1504: , bb.date_to
1505: , bb.comment_text
1506: FROM
1507: hxc_time_building_blocks bb
1508: WHERE
1509: bb.time_building_block_id = p_bb_id AND
1510: bb.object_version_number = p_bb_ovn AND
1511: bb.approval_status = p_status;

Line 2390: --- from hxc_time_building_blocks detbb,

2386: --- AND ta1.bld_blk_info_type_id = 13
2387: --- AND ta1.ATTRIBUTE2 = '10092612')
2388: --- AND exists (
2389: --- select 'Y'
2390: --- from hxc_time_building_blocks detbb,
2391: --- hxc_time_building_blocks daybb,
2392: --- hxc_timecard_summary time_status
2393: --- where tbb.time_building_Block_id = detbb.time_building_block_id
2394: --- and tbb.object_version_number = detbb.object_version_number

Line 2391: --- hxc_time_building_blocks daybb,

2387: --- AND ta1.ATTRIBUTE2 = '10092612')
2388: --- AND exists (
2389: --- select 'Y'
2390: --- from hxc_time_building_blocks detbb,
2391: --- hxc_time_building_blocks daybb,
2392: --- hxc_timecard_summary time_status
2393: --- where tbb.time_building_Block_id = detbb.time_building_block_id
2394: --- and tbb.object_version_number = detbb.object_version_number
2395: --- and detbb.parent_building_block_id = daybb.time_building_block_id

Line 2410: --- 5070998 TABLE ACCESS FULL HXC_TIME_BUILDING_BLOCKS (cr=137452 pr=125820 pw=0 time=76065499 us)

2406: --- 0 NESTED LOOPS (cr=30795566 pr=1088713 pw=25995 time=585061680 us)
2407: --- 3395698 NESTED LOOPS (cr=20608470 pr=734106 pw=25995 time=428086279 us)
2408: --- 3395698 NESTED LOOPS (cr=10421374 pr=689213 pw=25995 time=353373822 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)

Line 2415: --- 3395698 TABLE ACCESS BY INDEX ROWID HXC_TIME_BUILDING_BLOCKS (cr=10187096 pr=460559 pw=0 time=182819518 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)
2419: --- 0 TABLE ACCESS BY INDEX ROWID HXC_TIME_ATTRIBUTES (cr=10187096 pr=354607 pw=0 time=151577213 us)

Line 2416: --- 3395698 INDEX UNIQUE SCAN HXC_TIME_BUILDING_BLOCKS_PK (cr=6791398 pr=81265 pw=0 time=49309421 us)(object id 249842)

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)
2419: --- 0 TABLE ACCESS BY INDEX ROWID HXC_TIME_ATTRIBUTES (cr=10187096 pr=354607 pw=0 time=151577213 us)
2420: --- 3395698 INDEX UNIQUE SCAN HXC_TIME_ATTRIBUTES_PK (cr=6791398 pr=79962 pw=0 time=49425962 us)(object id 249844)

Line 2450: ---- from hxc_time_building_blocks detbb,

2446: ---- AND exists (
2447: ---- select /*+ NO_UNNEST
2448: ---- LEADING(detbb) */
2449: ---- 'Y'
2450: ---- from hxc_time_building_blocks detbb,
2451: ---- hxc_time_building_blocks daybb,
2452: ---- hxc_timecard_summary time_status
2453: ---- where tbb.time_building_Block_id = detbb.time_building_block_id
2454: ---- and tbb.object_version_number = detbb.object_version_number

Line 2451: ---- hxc_time_building_blocks daybb,

2447: ---- select /*+ NO_UNNEST
2448: ---- LEADING(detbb) */
2449: ---- 'Y'
2450: ---- from hxc_time_building_blocks detbb,
2451: ---- hxc_time_building_blocks daybb,
2452: ---- hxc_timecard_summary time_status
2453: ---- where tbb.time_building_Block_id = detbb.time_building_block_id
2454: ---- and tbb.object_version_number = detbb.object_version_number
2455: ---- and detbb.parent_building_block_id = daybb.time_building_block_id

Line 2481: --- |* 14 | TABLE ACCESS BY INDEX ROWID | HXC_TIME_BUILDING_BLOCKS |

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 | |
2481: --- |* 14 | TABLE ACCESS BY INDEX ROWID | HXC_TIME_BUILDING_BLOCKS |
2482: --- |* 15 | INDEX UNIQUE SCAN | HXC_TIME_BUILDING_BLOCKS_PK |
2483: --- |* 16 | TABLE ACCESS BY INDEX ROWID | HXC_TIME_BUILDING_BLOCKS |
2484: --- |* 17 | INDEX UNIQUE SCAN | HXC_TIME_BUILDING_BLOCKS_PK |
2485: --- |* 18 | TABLE ACCESS BY INDEX ROWID | HXC_TIMECARD_SUMMARY |

Line 2482: --- |* 15 | INDEX UNIQUE SCAN | HXC_TIME_BUILDING_BLOCKS_PK |

2478: --- | 11 | INDEX RANGE SCAN | HXC_LATEST_DETAILS_FK |
2479: --- | 12 | NESTED LOOPS | |
2480: --- | 13 | NESTED LOOPS | |
2481: --- |* 14 | TABLE ACCESS BY INDEX ROWID | HXC_TIME_BUILDING_BLOCKS |
2482: --- |* 15 | INDEX UNIQUE SCAN | HXC_TIME_BUILDING_BLOCKS_PK |
2483: --- |* 16 | TABLE ACCESS BY INDEX ROWID | HXC_TIME_BUILDING_BLOCKS |
2484: --- |* 17 | INDEX UNIQUE SCAN | HXC_TIME_BUILDING_BLOCKS_PK |
2485: --- |* 18 | TABLE ACCESS BY INDEX ROWID | HXC_TIMECARD_SUMMARY |
2486: --- |* 19 | INDEX UNIQUE SCAN | HXC_TIMECARD_SUMMARY_PK |

Line 2483: --- |* 16 | TABLE ACCESS BY INDEX ROWID | HXC_TIME_BUILDING_BLOCKS |

2479: --- | 12 | NESTED LOOPS | |
2480: --- | 13 | NESTED LOOPS | |
2481: --- |* 14 | TABLE ACCESS BY INDEX ROWID | HXC_TIME_BUILDING_BLOCKS |
2482: --- |* 15 | INDEX UNIQUE SCAN | HXC_TIME_BUILDING_BLOCKS_PK |
2483: --- |* 16 | TABLE ACCESS BY INDEX ROWID | HXC_TIME_BUILDING_BLOCKS |
2484: --- |* 17 | INDEX UNIQUE SCAN | HXC_TIME_BUILDING_BLOCKS_PK |
2485: --- |* 18 | TABLE ACCESS BY INDEX ROWID | HXC_TIMECARD_SUMMARY |
2486: --- |* 19 | INDEX UNIQUE SCAN | HXC_TIMECARD_SUMMARY_PK |
2487: --- --------------------------------------------------------------------------

Line 2484: --- |* 17 | INDEX UNIQUE SCAN | HXC_TIME_BUILDING_BLOCKS_PK |

2480: --- | 13 | NESTED LOOPS | |
2481: --- |* 14 | TABLE ACCESS BY INDEX ROWID | HXC_TIME_BUILDING_BLOCKS |
2482: --- |* 15 | INDEX UNIQUE SCAN | HXC_TIME_BUILDING_BLOCKS_PK |
2483: --- |* 16 | TABLE ACCESS BY INDEX ROWID | HXC_TIME_BUILDING_BLOCKS |
2484: --- |* 17 | INDEX UNIQUE SCAN | HXC_TIME_BUILDING_BLOCKS_PK |
2485: --- |* 18 | TABLE ACCESS BY INDEX ROWID | HXC_TIMECARD_SUMMARY |
2486: --- |* 19 | INDEX UNIQUE SCAN | HXC_TIMECARD_SUMMARY_PK |
2487: --- --------------------------------------------------------------------------
2488:

Line 2498: FROM hxc_time_building_blocks tbb

2494: SELECT ''Y''
2495: FROM dual
2496: WHERE EXISTS (
2497: SELECT 1
2498: FROM hxc_time_building_blocks tbb
2499: WHERE tbb.scope = :p_scope AND
2500: tbb.object_version_number = (
2501: SELECT MAX ( tbb1.object_version_number )
2502: FROM hxc_time_building_blocks tbb1

Line 2502: FROM hxc_time_building_blocks tbb1

2498: FROM hxc_time_building_blocks tbb
2499: WHERE tbb.scope = :p_scope AND
2500: tbb.object_version_number = (
2501: SELECT MAX ( tbb1.object_version_number )
2502: FROM hxc_time_building_blocks tbb1
2503: WHERE tbb1.time_building_block_id = tbb.time_building_block_id )';
2504:
2505: ELSE
2506:

Line 2706: from hxc_time_building_blocks detbb,

2702: AND exists (
2703: select /*+ NO_UNNEST
2704: LEADING(detbb) */
2705: ''Y''
2706: from hxc_time_building_blocks detbb,
2707: hxc_time_building_blocks daybb,
2708: hxc_timecard_summary time_status
2709: where tbb.time_building_Block_id = detbb.time_building_block_id
2710: and tbb.object_version_number = detbb.object_version_number

Line 2707: hxc_time_building_blocks daybb,

2703: select /*+ NO_UNNEST
2704: LEADING(detbb) */
2705: ''Y''
2706: from hxc_time_building_blocks detbb,
2707: hxc_time_building_blocks daybb,
2708: hxc_timecard_summary time_status
2709: where tbb.time_building_Block_id = detbb.time_building_block_id
2710: and tbb.object_version_number = detbb.object_version_number
2711: and detbb.parent_building_block_id = daybb.time_building_block_id

Line 2731: select 1 from hxc_time_building_blocks daybb1

2727: ELSE
2728:
2729: l_end_date := '
2730: AND exists (
2731: select 1 from hxc_time_building_blocks daybb1
2732: where tbb.parent_building_block_id = daybb1.time_building_block_id
2733: and tbb.parent_building_block_ovn = daybb1.object_version_number
2734: and daybb1.stop_time >= :p_end_date) ';
2735:

Line 2863: FROM hxc_time_building_blocks tbb

2859: SELECT ''Y''
2860: FROM dual
2861: WHERE EXISTS (
2862: SELECT 1
2863: FROM hxc_time_building_blocks tbb
2864: WHERE tbb.scope = :p_scope AND
2865: tbb.object_version_number = (
2866: SELECT MAX ( tbb1.object_version_number )
2867: FROM hxc_time_building_blocks tbb1

Line 2867: FROM hxc_time_building_blocks tbb1

2863: FROM hxc_time_building_blocks tbb
2864: WHERE tbb.scope = :p_scope AND
2865: tbb.object_version_number = (
2866: SELECT MAX ( tbb1.object_version_number )
2867: FROM hxc_time_building_blocks tbb1
2868: WHERE tbb1.time_building_block_id = tbb.time_building_block_id )
2869: AND NOT EXISTS (
2870: SELECT 1
2871: FROM hxc_transactions tx

Line 3195: hxc_time_building_blocks tbb

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
3199: AND tbb.object_version_number = (

Line 3201: FROM hxc_time_building_blocks tbb1

3197: tbb.scope = :p_scope
3198: AND tbb.resource_id = :p_resource_id
3199: AND tbb.object_version_number = (
3200: SELECT MAX ( tbb1.object_version_number )
3201: FROM hxc_time_building_blocks tbb1
3202: WHERE tbb1.time_building_block_id = tbb.time_building_block_id )
3203: AND tau.time_building_block_id = tbb.time_building_block_id
3204: AND tau.time_building_block_ovn = tbb.object_version_number
3205: AND tau.time_attribute_id = ta.time_attribute_id

Line 3312: from hxc_time_building_blocks daybb,

3308:
3309: l_status := '
3310: AND exists (
3311: select ''Y''
3312: from hxc_time_building_blocks daybb,
3313: hxc_time_building_blocks timebb,
3314: hxc_timecard_summary time_status
3315: where tbb.parent_building_block_id = daybb.time_building_block_id
3316: and tbb.parent_building_block_ovn = daybb.object_version_number

Line 3313: hxc_time_building_blocks timebb,

3309: l_status := '
3310: AND exists (
3311: select ''Y''
3312: from hxc_time_building_blocks daybb,
3313: hxc_time_building_blocks timebb,
3314: hxc_timecard_summary time_status
3315: where tbb.parent_building_block_id = daybb.time_building_block_id
3316: and tbb.parent_building_block_ovn = daybb.object_version_number
3317: and daybb.parent_building_block_id = timebb.time_building_block_id