[Home] [Help]
View: PER_ORGANIZATION_UNITS_PERF
View Text
SELECT O.ORGANIZATION_ID
, O.BUSINESS_GROUP_ID
, O.NAME
, O.DATE_FROM
, O.DATE_TO
, O.INTERNAL_ADDRESS_LINE
, O.COMMENTS
, O.INTERNAL_EXTERNAL_FLAG
, O.TYPE
, O.LOCATION_ID
, O.COST_ALLOCATION_KEYFLEX_ID
, O.SOFT_CODING_KEYFLEX_ID
FROM HR_ORGANIZATION_UNITS O
, HR_ORGANIZATION_INFORMATION O3
WHERE O.ORGANIZATION_ID = O3.ORGANIZATION_ID
AND O3.ORG_INFORMATION_CONTEXT || '' = 'CLASS'
AND O3.ORG_INFORMATION1 = 'HR_ORG'
AND O3.ORG_INFORMATION2 = 'Y'
Columns
| Name |
| ORGANIZATION_ID |
| BUSINESS_GROUP_ID |
| NAME |
| DATE_FROM |
| DATE_TO |
| INTERNAL_ADDRESS_LINE |
| COMMENTS |
| INTERNAL_EXTERNAL_FLAG |
| TYPE |
| LOCATION_ID |
| COST_ALLOCATION_KEYFLEX_ID |
| SOFT_CODING_KEYFLEX_ID |
APPS.PER_ORGANIZATION_UNITS_PERF