[Home] [Help]
59: -- get cost center information from ATTRIBUTE table
60: CURSOR get_cost_attributes
61: IS
62: SELECT /*+ INDEX(htau HXC_TIME_ATTRIBUTE_USAGES_FK2)
63: INDEX(hta HXC_TIME_ATTRIBUTES_PK) */
64: temp.time_building_block_id time_building_block_id,
65: temp.object_version_number object_version_number,
66: hta.attribute1 attribute1, hta.attribute2 attribute2,
67: hta.attribute3 attribute3, hta.attribute4 attribute4,
81: NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
82: NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
83: NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
84: 0 cost_allocation_keyflex_id
85: FROM hxc_time_attributes hta,
86: hxc_time_attribute_usages htau,
87: hxc_abs_ret_temp temp
88: WHERE temp.time_building_block_id = htau.time_building_block_id
89: AND temp.object_version_number = htau.time_building_block_ovn
372: INSERT INTO hxc_abs_ret_temp (
373: SELECT /*+ LEADING (latest HXC_LATEST_DETAILS_N1)
374: INDEX(detail HXC_TIME_BUILDING_BLOCKS_PK)
375: INDEX(htau HXC_TIME_ATTRIBUTE_USAGES_FK2)
376: INDEX(hta HXC_TIME_ATTRIBUTES_PK) */
377: detail.time_building_block_id, --time_building_block_id,
378: detail.object_version_number , --object_version_number,
379: detail.resource_id , --resource_id,
380: detail.start_time , --in_time,
393: NULL --link_time_building_block_id
394: FROM hxc_latest_details latest,
395: hxc_time_building_blocks detail,
396: hxc_time_attribute_usages htau,
397: hxc_time_attributes hta,
398: hxc_absence_type_elements hate
399: WHERE latest.resource_id = g_resource_id
400: AND TRUNC (latest.start_time) BETWEEN TRUNC (g_tc_start) AND TRUNC (g_tc_stop)
401: AND latest.time_building_block_id = detail.time_building_block_id