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.

VIEW: APPS.HXC_TIMECARD_TEMPLATES_V

Source

View Text - Preformatted


SELECT 'DYNAMIC|'||lookup_code value, Meaning display_value, fnd_global.employee_id resource_id, 'PERSON' RESOURCE_type, Null layout_id from hr_lookups WHERE lookup_type = 'HXC_DYNAMIC_TEMPLATES' and enabled_flag = 'Y' and sysdate between start_date_active and NVL(end_date_active,hr_general.end_of_time) and lookup_code <> 'APP|HXT' union all select /*+ LEADING(tbb) INDEX(tbb HXC_TIME_BUILDING_BLOCKS_FK2) */ 'PRIVATE|'||tbb.time_building_block_id value, ta.attribute1 display_value, tbb.resource_id resource_id, tbb.resource_type resource_type, ta2.attribute1 layout_id from hxc_time_building_blocks tbb , hxc_time_attribute_usages tau , hxc_time_attributes ta, hxc_time_attributes ta2, hxc_time_attribute_usages tau2 where ta.time_attribute_id = tau.time_attribute_id and tau.time_building_block_id = tbb.time_building_block_id and tau.time_building_block_ovn = tbb.object_version_number and tbb.date_to = hr_general.end_of_time and ta.attribute_category = 'TEMPLATES' and ta.attribute2 = 'PRIVATE' and tbb.scope = 'TIMECARD_TEMPLATE' and tbb.date_to = hr_general.end_of_time and ta2.time_attribute_id = tau2.time_attribute_id and ta2.attribute_category = 'LAYOUT' and tau2.time_building_block_ovn = tbb.object_version_number and tbb.time_building_block_id = tau2.time_building_block_id union all select /*+ LEADING(tbb) INDEX(tbb HXC_TIME_BUILDING_BLOCKS_FK2) */ 'PUBLIC|'||tbb.time_building_block_id value, ta.attribute1 display_value, fnd_global.employee_id resource_id, tbb.resource_type resource_type, ta2.attribute1 layout_id from hxc_time_building_blocks tbb, hxc_time_attributes ta, hxc_time_attribute_usages tau, hxc_time_attributes nta, hxc_time_attribute_usages ntau, hxc_time_attributes ta2, hxc_time_attribute_usages tau2 where tbb.resource_id=-1 and ntau.time_attribute_id = nta.time_attribute_id and ntau.time_building_block_ovn = tbb.object_version_number and tbb.time_building_block_id = ntau.time_building_block_id and nta.attribute_category = 'SECURITY' and nta.attribute2= DECODE(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N',fnd_profile.value('PER_BUSINESS_GROUP_ID'),nta.attribute2) and tbb.time_building_block_id = tau.time_building_block_id and tau.time_attribute_id = ta.time_attribute_id and tau.time_building_block_ovn = tbb.object_version_number and tbb.date_to = hr_general.end_of_time and ta.attribute2 = 'PUBLIC' and ta.attribute_category = 'TEMPLATES' and tbb.scope = 'TIMECARD_TEMPLATE' and tbb.date_to = hr_general.end_of_time and tbb.time_building_block_id = tau2.time_building_block_id and tau2.time_building_block_ovn = tbb.object_version_number and ta2.time_attribute_id = tau2.time_attribute_id and ta2.attribute_category = 'LAYOUT'

View Text - HTML Formatted

SELECT 'DYNAMIC|'||LOOKUP_CODE VALUE
, MEANING DISPLAY_VALUE
, FND_GLOBAL.EMPLOYEE_ID RESOURCE_ID
, 'PERSON' RESOURCE_TYPE
, NULL LAYOUT_ID
FROM HR_LOOKUPS
WHERE LOOKUP_TYPE = 'HXC_DYNAMIC_TEMPLATES'
AND ENABLED_FLAG = 'Y'
AND SYSDATE BETWEEN START_DATE_ACTIVE
AND NVL(END_DATE_ACTIVE
, HR_GENERAL.END_OF_TIME)
AND LOOKUP_CODE <> 'APP|HXT' UNION ALL SELECT /*+ LEADING(TBB) INDEX(TBB HXC_TIME_BUILDING_BLOCKS_FK2) */ 'PRIVATE|'||TBB.TIME_BUILDING_BLOCK_ID VALUE
, TA.ATTRIBUTE1 DISPLAY_VALUE
, TBB.RESOURCE_ID RESOURCE_ID
, TBB.RESOURCE_TYPE RESOURCE_TYPE
, TA2.ATTRIBUTE1 LAYOUT_ID
FROM HXC_TIME_BUILDING_BLOCKS TBB
, HXC_TIME_ATTRIBUTE_USAGES TAU
, HXC_TIME_ATTRIBUTES TA
, HXC_TIME_ATTRIBUTES TA2
, HXC_TIME_ATTRIBUTE_USAGES TAU2
WHERE TA.TIME_ATTRIBUTE_ID = TAU.TIME_ATTRIBUTE_ID
AND TAU.TIME_BUILDING_BLOCK_ID = TBB.TIME_BUILDING_BLOCK_ID
AND TAU.TIME_BUILDING_BLOCK_OVN = TBB.OBJECT_VERSION_NUMBER
AND TBB.DATE_TO = HR_GENERAL.END_OF_TIME
AND TA.ATTRIBUTE_CATEGORY = 'TEMPLATES'
AND TA.ATTRIBUTE2 = 'PRIVATE'
AND TBB.SCOPE = 'TIMECARD_TEMPLATE'
AND TBB.DATE_TO = HR_GENERAL.END_OF_TIME
AND TA2.TIME_ATTRIBUTE_ID = TAU2.TIME_ATTRIBUTE_ID
AND TA2.ATTRIBUTE_CATEGORY = 'LAYOUT'
AND TAU2.TIME_BUILDING_BLOCK_OVN = TBB.OBJECT_VERSION_NUMBER
AND TBB.TIME_BUILDING_BLOCK_ID = TAU2.TIME_BUILDING_BLOCK_ID UNION ALL SELECT /*+ LEADING(TBB) INDEX(TBB HXC_TIME_BUILDING_BLOCKS_FK2) */ 'PUBLIC|'||TBB.TIME_BUILDING_BLOCK_ID VALUE
, TA.ATTRIBUTE1 DISPLAY_VALUE
, FND_GLOBAL.EMPLOYEE_ID RESOURCE_ID
, TBB.RESOURCE_TYPE RESOURCE_TYPE
, TA2.ATTRIBUTE1 LAYOUT_ID
FROM HXC_TIME_BUILDING_BLOCKS TBB
, HXC_TIME_ATTRIBUTES TA
, HXC_TIME_ATTRIBUTE_USAGES TAU
, HXC_TIME_ATTRIBUTES NTA
, HXC_TIME_ATTRIBUTE_USAGES NTAU
, HXC_TIME_ATTRIBUTES TA2
, HXC_TIME_ATTRIBUTE_USAGES TAU2
WHERE TBB.RESOURCE_ID=-1
AND NTAU.TIME_ATTRIBUTE_ID = NTA.TIME_ATTRIBUTE_ID
AND NTAU.TIME_BUILDING_BLOCK_OVN = TBB.OBJECT_VERSION_NUMBER
AND TBB.TIME_BUILDING_BLOCK_ID = NTAU.TIME_BUILDING_BLOCK_ID
AND NTA.ATTRIBUTE_CATEGORY = 'SECURITY'
AND NTA.ATTRIBUTE2= DECODE(FND_PROFILE.VALUE('HR_CROSS_BUSINESS_GROUP')
, 'N'
, FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')
, NTA.ATTRIBUTE2)
AND TBB.TIME_BUILDING_BLOCK_ID = TAU.TIME_BUILDING_BLOCK_ID
AND TAU.TIME_ATTRIBUTE_ID = TA.TIME_ATTRIBUTE_ID
AND TAU.TIME_BUILDING_BLOCK_OVN = TBB.OBJECT_VERSION_NUMBER
AND TBB.DATE_TO = HR_GENERAL.END_OF_TIME
AND TA.ATTRIBUTE2 = 'PUBLIC'
AND TA.ATTRIBUTE_CATEGORY = 'TEMPLATES'
AND TBB.SCOPE = 'TIMECARD_TEMPLATE'
AND TBB.DATE_TO = HR_GENERAL.END_OF_TIME
AND TBB.TIME_BUILDING_BLOCK_ID = TAU2.TIME_BUILDING_BLOCK_ID
AND TAU2.TIME_BUILDING_BLOCK_OVN = TBB.OBJECT_VERSION_NUMBER
AND TA2.TIME_ATTRIBUTE_ID = TAU2.TIME_ATTRIBUTE_ID
AND TA2.ATTRIBUTE_CATEGORY = 'LAYOUT'