[Home] [Help]
View: HR_HK_MPF_TRUSTEE_V
View Text
SELECT HOU.ORGANIZATION_ID
, HOU.BUSINESS_GROUP_ID + 0 BUSINESS_GROUP_ID
, HOU.NAME
, HOU.COMMENTS
, HOU.LOCATION_ID
FROM HR_ORGANIZATION_UNITS HOU
, HR_ORGANIZATION_INFORMATION HOI1
WHERE HOU.ORGANIZATION_ID = HOI1.ORGANIZATION_ID
AND HOI1.ORG_INFORMATION1 = 'HK_MPF'
Columns
Name |
ORGANIZATION_ID |
BUSINESS_GROUP_ID |
NAME |
COMMENTS |
LOCATION_ID |