[Home] [Help]
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
Name |
PROCESS_RUN_NAME |
PROCESS_RUN_TYPE |
PROCESS_RUN_ID |
SEQUENCE_NUMBER |
ITEM_VALUE1 |
ITEM_VALUE2 |
ITEM_VALUE_ID |