View: HR_SUMMARY_RUN_VALUES_X2_V

Product:	PER - Human Resources
Description:	This view provides the run values available in the HR_SUMMARY table
Implementation/DBA Data:	APPS.HR_SUMMARY_RUN_VALUES_X2_V

View Text

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)

Columns