VIEW: APPS.HR_SUMMARY_RUN_VALUES_X2_V

Source

View Text - Preformatted

SELECT pr.name, pr.process_type, pr.process_run_id, itu.sequence_number, -1, iv.item_value_id, iv.numvalue1, iv.numvalue2, 0, 0 FROM hr_summary_process_run pr ,hr_summary_item_type_usage itu ,hr_summary_item_value iv WHERE pr.process_run_id = iv.process_run_id and pr.template_id = itu.template_id and itu.item_type_usage_id = iv.item_type_usage_id and pr.business_group_id = NVL(hr_general.get_business_group_id, pr.business_group_id) UNION SELECT pr.name ,pr.process_type ,pr.process_run_id ,-1 ,itu.sequence_number ,iv.item_value_id ,0 ,0 ,iv.numvalue1 ,iv.numvalue2 FROM hr_summary_process_run pr ,hr_summary_item_type_usage itu ,hr_summary_item_value iv where pr.process_run_id = iv.process_run_id and pr.template_id = itu.template_id and itu.item_type_usage_id = iv.item_type_usage_id and pr.business_group_id = NVL(hr_general.get_business_group_id, pr.business_group_id)

View Text - HTML Formatted

SELECT PR.NAME
, PR.PROCESS_TYPE
, PR.PROCESS_RUN_ID
, ITU.SEQUENCE_NUMBER
, -1
, IV.ITEM_VALUE_ID
, IV.NUMVALUE1
, IV.NUMVALUE2
, 0
, 0
FROM HR_SUMMARY_PROCESS_RUN PR
, HR_SUMMARY_ITEM_TYPE_USAGE ITU
, HR_SUMMARY_ITEM_VALUE IV
WHERE PR.PROCESS_RUN_ID = IV.PROCESS_RUN_ID
AND PR.TEMPLATE_ID = ITU.TEMPLATE_ID
AND ITU.ITEM_TYPE_USAGE_ID = IV.ITEM_TYPE_USAGE_ID
AND PR.BUSINESS_GROUP_ID = NVL(HR_GENERAL.GET_BUSINESS_GROUP_ID
, PR.BUSINESS_GROUP_ID) UNION SELECT PR.NAME
, PR.PROCESS_TYPE
, PR.PROCESS_RUN_ID
, -1
, ITU.SEQUENCE_NUMBER
, IV.ITEM_VALUE_ID
, 0
, 0
, IV.NUMVALUE1
, IV.NUMVALUE2
FROM HR_SUMMARY_PROCESS_RUN PR
, HR_SUMMARY_ITEM_TYPE_USAGE ITU
, HR_SUMMARY_ITEM_VALUE IV
WHERE PR.PROCESS_RUN_ID = IV.PROCESS_RUN_ID
AND PR.TEMPLATE_ID = ITU.TEMPLATE_ID
AND ITU.ITEM_TYPE_USAGE_ID = IV.ITEM_TYPE_USAGE_ID
AND PR.BUSINESS_GROUP_ID = NVL(HR_GENERAL.GET_BUSINESS_GROUP_ID
, PR.BUSINESS_GROUP_ID)