[Home] [Help]
View: PA_PRM_ORGANIZATIONS_V
Product: | PA - Projects |
Description: | PA_PRM_ORGANIZATIONS_V is a view that shows all organizations
along with their business_group. |
Implementation/DBA Data: |
APPS.PA_PRM_ORGANIZATIONS_V
|
View Text
SELECT HRORG.NAME
, HRORG.ORGANIZATION_ID
, HRORG.DATE_FROM
, HRORG.DATE_TO
, HRBUS.NAME
, HRORG.BUSINESS_GROUP_ID
FROM HR_ORGANIZATION_UNITS HRORG
, HR_ORGANIZATION_UNITS HRBUS
WHERE HRORG.BUSINESS_GROUP_ID = HRBUS.ORGANIZATION_ID
Columns
Name |
ORGANIZATION_NAME |
ORGANIZATION_ID |
START_DATE |
END_DATE |
BUSINESS_GROUP_NAME |
BUSINESS_GROUP_ID |