SELECT meaning ORGANIZATION, -99 ORG_ID from ar_lookups WHERE lookup_type = 'ALL' UNION select hr.name ORGANIZATION, ar.org_id ORG_ID from hr_operating_units hr, ar_system_parameters ar where ar.org_id = hr.organization_id order by organization
SELECT MEANING ORGANIZATION
, -99 ORG_ID
FROM AR_LOOKUPS
WHERE LOOKUP_TYPE = 'ALL' UNION SELECT HR.NAME ORGANIZATION
, AR.ORG_ID ORG_ID
FROM HR_OPERATING_UNITS HR
, AR_SYSTEM_PARAMETERS AR
WHERE AR.ORG_ID = HR.ORGANIZATION_ID ORDER BY ORGANIZATION
|
|
|