[Home] [Help]
View: HR_SUMMARY_KEY_VALUES_ESTAB_V
Product: | PER - Human Resources |
Description: | View based on HR_SUMMARY_KEY_VALUE, HR_SUMMARY_KEY_TYPE and hr_all_organization_units. |
Implementation/DBA Data: |
APPS.HR_SUMMARY_KEY_VALUES_ESTAB_V
|
View Text
SELECT ORG.NAME
, KV.ITEM_VALUE_ID
FROM HR_SUMMARY_KEY_VALUE KV
, HR_SUMMARY_KEY_TYPE KT
, HR_ALL_ORGANIZATION_UNITS ORG
WHERE KV.KEY_TYPE_ID = KT.KEY_TYPE_ID
AND KV.BUSINESS_GROUP_ID = NVL(HR_GENERAL.GET_BUSINESS_GROUP_ID
, KV.BUSINESS_GROUP_ID)
AND KT.NAME = 'ESTABLISHMENT'
AND KV.NAME = TO_CHAR(ORG.ORGANIZATION_ID)
Columns
Name |
KEY_VALUE_ESTABLISHMENT |
ITEM_VALUE_ID |