How to find Operating Units in Oracle Apps
SELECT hr.organization_id org_id, hr.NAME operating_unit,po_moac_utils_pvt.get_ou_shortcode (organization_id) ou_short_code
FROM hr_operating_units hr
WHERE po_moac_utils_pvt.check_access (hr.organization_id) = 'Y'
ORDER BY 1
===========================================================================
#Oracle Apps #EBS #OU #Operating Units
No comments:
Post a Comment