[Home] [Help]
View: HR_BARGAINING_UNITS_V
Product: | PER - Human Resources |
Description: | HR_BARGAINING_UNITS_V lists the organizations which have been identified as Bargaining Units. |
Implementation/DBA Data: |
APPS.HR_BARGAINING_UNITS_V
|
View Text
SELECT OU1.ORGANIZATION_ID
, OU1.BUSINESS_GROUP_ID
, OU1.NAME
, OU1.DATE_FROM
, OU1.DATE_TO
, OU1.INTERNAL_ADDRESS_LINE
, OU1.LOCATION_ID
, OU1.COMMENTS
, OI1.ORG_INFORMATION2
FROM HR_ORGANIZATION_INFORMATION OI1
, HR_ALL_ORGANIZATION_UNITS OU1
WHERE OU1.ORGANIZATION_ID = OI1.ORGANIZATION_ID
AND OI1.ORG_INFORMATION_CONTEXT || '' = 'CLASS'
AND OI1.ORG_INFORMATION1 = 'BARGAINING_UNIT'
AND OI1.ORG_INFORMATION2 = 'Y'
Columns
Name |
ORGANIZATION_ID |
BUSINESS_GROUP_ID |
NAME |
DATE_FROM |
DATE_TO |
INTERNAL_ADDRESS_LINE |
LOCATION_ID |
COMMENTS |
ENABLED |