[Home] [Help]
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
Name |
PROCESS_RUN_NAME |
PROCESS_RUN_TYPE |
PROCESS_RUN_ID |
SEQUENCE_NUMBER1 |
SEQUENCE_NUMBER2 |
ITEM_VALUE_ID |
ITEM_USAGE1_ITEM_VALUE1 |
ITEM_USAGE1_ITEM_VALUE2 |
ITEM_USAGE2_ITEM_VALUE1 |
ITEM_USAGE2_ITEM_VALUE2 |