VIEW: APPS.HXC_APPLICATION_PERIODS_V

Source

View Text - Preformatted

SELECT hap.time_building_block_id, hap.object_version_number, hap.start_time, hap.stop_time, hap.type, hap.measure, hap.unit_of_measure, hap.parent_building_block_id, hap.parent_building_block_ovn, hap.scope, hap.approval_style_id, hap.approval_status, hap.resource_type, hap.resource_id, hta.attribute6, hta.attribute1, hta.attribute2, hta.attribute3, hta.attribute7, hap.object_version_number, hap.creation_date from hxc_time_building_blocks hap, hxc_time_attribute_usages htau, hxc_time_attributes hta WHERE hap.scope = 'APPLICATION_PERIOD' and hap.type = 'RANGE' and hap.date_to = hr_general.end_of_time and hap.resource_type = 'PERSON' and hap.time_building_block_id = htau.time_building_block_id and hap.object_version_number = htau.time_building_block_ovn and htau.time_attribute_id = hta.time_attribute_id and hta.attribute_category = 'APPROVAL' and hap.object_version_number = (select max(object_version_number) from hxc_time_building_blocks where time_building_block_id = hap.time_building_block_id)

View Text - HTML Formatted

SELECT HAP.TIME_BUILDING_BLOCK_ID
, HAP.OBJECT_VERSION_NUMBER
, HAP.START_TIME
, HAP.STOP_TIME
, HAP.TYPE
, HAP.MEASURE
, HAP.UNIT_OF_MEASURE
, HAP.PARENT_BUILDING_BLOCK_ID
, HAP.PARENT_BUILDING_BLOCK_OVN
, HAP.SCOPE
, HAP.APPROVAL_STYLE_ID
, HAP.APPROVAL_STATUS
, HAP.RESOURCE_TYPE
, HAP.RESOURCE_ID
, HTA.ATTRIBUTE6
, HTA.ATTRIBUTE1
, HTA.ATTRIBUTE2
, HTA.ATTRIBUTE3
, HTA.ATTRIBUTE7
, HAP.OBJECT_VERSION_NUMBER
, HAP.CREATION_DATE
FROM HXC_TIME_BUILDING_BLOCKS HAP
, HXC_TIME_ATTRIBUTE_USAGES HTAU
, HXC_TIME_ATTRIBUTES HTA
WHERE HAP.SCOPE = 'APPLICATION_PERIOD'
AND HAP.TYPE = 'RANGE'
AND HAP.DATE_TO = HR_GENERAL.END_OF_TIME
AND HAP.RESOURCE_TYPE = 'PERSON'
AND HAP.TIME_BUILDING_BLOCK_ID = HTAU.TIME_BUILDING_BLOCK_ID
AND HAP.OBJECT_VERSION_NUMBER = HTAU.TIME_BUILDING_BLOCK_OVN
AND HTAU.TIME_ATTRIBUTE_ID = HTA.TIME_ATTRIBUTE_ID
AND HTA.ATTRIBUTE_CATEGORY = 'APPROVAL'
AND HAP.OBJECT_VERSION_NUMBER = (SELECT MAX(OBJECT_VERSION_NUMBER)
FROM HXC_TIME_BUILDING_BLOCKS
WHERE TIME_BUILDING_BLOCK_ID = HAP.TIME_BUILDING_BLOCK_ID)