SELECT O.ORGANIZATION_ID , O.BUSINESS_GROUP_ID + 0 , O.NAME , O.COMMENTS , O.LOCATION_ID FROM HR_ORGANIZATION_INFORMATION OI, HR_ORGANIZATION_UNITS O WHERE OI.ORGANIZATION_ID = O.ORGANIZATION_ID AND OI.ORG_INFORMATION1= 'US_CARRIER'
SELECT O.ORGANIZATION_ID
, O.BUSINESS_GROUP_ID + 0
, O.NAME
, O.COMMENTS
, O.LOCATION_ID
FROM HR_ORGANIZATION_INFORMATION OI
, HR_ORGANIZATION_UNITS O
WHERE OI.ORGANIZATION_ID = O.ORGANIZATION_ID
AND OI.ORG_INFORMATION1= 'US_CARRIER'
|
|
|