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_ATTRIBUTES

Line 730: , hxc_time_attributes ta

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
734: bb.time_building_block_id = p_bb_id AND

Line 814: hxc_time_attributes ta

810: , 'X'
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

Line 1905: -- returns the name of the attribute column in HXC_TIME_ATTRIBUTES which

1901: -- function
1902: -- attribute_column
1903: --
1904: -- description
1905: -- returns the name of the attribute column in HXC_TIME_ATTRIBUTES which
1906: -- maps to the parameter p_field_name, based on the building block
1907: -- category and information type
1908: --
1909: -- parameters

Line 1961: -- attribute column in HXC_TIME_ATTRIBUTES which maps to the parameter

1957: -- attribute_column
1958: --
1959: -- description
1960: -- overload of attribute_column function. returns the name of the
1961: -- attribute column in HXC_TIME_ATTRIBUTES which maps to the parameter
1962: -- p_field_name, based on the deposit or retrieval process identifier.
1963: -- since there is no guarantee that mappings have been explicitly defined
1964: -- for the given process, the column name is returned in an out parameter,
1965: -- and the function returns true or false depending on whether a mapping

Line 2224: l_index_name(0) := 'HXC_TIME_ATTRIBUTES_FK2';

2220: -- Bug 11937354
2221: -- Initialize the table with the index names -- this will later be used to
2222: -- specify the right hint.
2223:
2224: l_index_name(0) := 'HXC_TIME_ATTRIBUTES_FK2';
2225: l_index_name(1) := 'HXC_TIME_ATTRIBUTES_FK3';
2226: l_index_name(2) := 'HXC_TIME_ATTRIBUTES_FK4';
2227: l_index_name(3) := 'HXC_TIME_ATTRIBUTES_FK5';
2228:

Line 2225: l_index_name(1) := 'HXC_TIME_ATTRIBUTES_FK3';

2221: -- Initialize the table with the index names -- this will later be used to
2222: -- specify the right hint.
2223:
2224: l_index_name(0) := 'HXC_TIME_ATTRIBUTES_FK2';
2225: l_index_name(1) := 'HXC_TIME_ATTRIBUTES_FK3';
2226: l_index_name(2) := 'HXC_TIME_ATTRIBUTES_FK4';
2227: l_index_name(3) := 'HXC_TIME_ATTRIBUTES_FK5';
2228:
2229: -- chk to see if OTL is installed

Line 2226: l_index_name(2) := 'HXC_TIME_ATTRIBUTES_FK4';

2222: -- specify the right hint.
2223:
2224: l_index_name(0) := 'HXC_TIME_ATTRIBUTES_FK2';
2225: l_index_name(1) := 'HXC_TIME_ATTRIBUTES_FK3';
2226: l_index_name(2) := 'HXC_TIME_ATTRIBUTES_FK4';
2227: l_index_name(3) := 'HXC_TIME_ATTRIBUTES_FK5';
2228:
2229: -- chk to see if OTL is installed
2230:

Line 2227: l_index_name(3) := 'HXC_TIME_ATTRIBUTES_FK5';

2223:
2224: l_index_name(0) := 'HXC_TIME_ATTRIBUTES_FK2';
2225: l_index_name(1) := 'HXC_TIME_ATTRIBUTES_FK3';
2226: l_index_name(2) := 'HXC_TIME_ATTRIBUTES_FK4';
2227: l_index_name(3) := 'HXC_TIME_ATTRIBUTES_FK5';
2228:
2229: -- chk to see if OTL is installed
2230:
2231: OPEN csr_chk_otl_installed;

Line 2382: --- hxc_time_attributes ta1

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
2386: --- AND ta1.bld_blk_info_type_id = 13

Line 2419: --- 0 TABLE ACCESS BY INDEX ROWID HXC_TIME_ATTRIBUTES (cr=10187096 pr=354607 pw=0 time=151577213 us)

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)
2421:
2422:
2423: -- This was the earlier SQL and plan generated.

Line 2420: --- 3395698 INDEX UNIQUE SCAN HXC_TIME_ATTRIBUTES_PK (cr=6791398 pr=79962 pw=0 time=49425962 us)(object id 249844)

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)
2421:
2422:
2423: -- This was the earlier SQL and plan generated.
2424:

Line 2436: ---- INDEX(ta1 HXC_TIME_ATTRIBUTES_FK4)

2432: ---- FROM hxc_latest_details tbb
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

Line 2440: ---- hxc_time_attributes ta1

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
2444: ---- AND ta1.bld_blk_info_type_id = 13

Line 2474: --- |* 7 | TABLE ACCESS BY INDEX ROWID| HXC_TIME_ATTRIBUTES |

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 |
2477: --- | 10 | TABLE ACCESS BY INDEX ROWID | HXC_LATEST_DETAILS |
2478: --- | 11 | INDEX RANGE SCAN | HXC_LATEST_DETAILS_FK |

Line 2475: --- |* 8 | INDEX RANGE SCAN | HXC_TIME_ATTRIBUTES_FK4 |

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 |
2477: --- | 10 | TABLE ACCESS BY INDEX ROWID | HXC_LATEST_DETAILS |
2478: --- | 11 | INDEX RANGE SCAN | HXC_LATEST_DETAILS_FK |
2479: --- | 12 | NESTED LOOPS | |

Line 2548: hxc_time_attributes ta1

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
2552: AND ta1.bld_blk_info_type_id = '||l_bld_block_info_id_outer||fnd_global.newline||

Line 2576: hxc_time_attributes ta1

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
2580: AND ta1.bld_blk_info_type_id = '||l_bld_block_info_id_outer||fnd_global.newline||

Line 3193: from hxc_time_attributes ta,

3189: -- build dynamic SQL query
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

Line 3226: hxc_time_attributes ta2

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
3230: AND ta2.bld_blk_info_type_id = '||l_bld_block_info_id_outer||

Line 3238: hxc_time_attributes ta2

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
3242: AND ta2.bld_blk_info_type_id = '||l_bld_block_info_id_outer||