View: HR_SUMMARY_RUN_VALUES_V

Product:	PER - Human Resources
Description:	This is a join between HR_SUMMARY_PROCESS_RUN, HR_SUMMARY_ITEM_USAGE, HR_SUMMARY_ITEM_VALUE.
Implementation/DBA Data:	APPS.HR_SUMMARY_RUN_VALUES_V

View Text

SELECT PR.NAME
, PR.PROCESS_TYPE
, PR.PROCESS_RUN_ID
, ITU.SEQUENCE_NUMBER
, IV.NUMVALUE1
, IV.NUMVALUE2
, IV.ITEM_VALUE_ID
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