List of Operating Units
SELECT a.name,
a.organization_id,
a.creation_date,
a.last_update_date
FROM hr_organization_units a, hr_organization_information b
WHERE a.organization_id = b.organization_id
AND org_information1 = 'OPERATING_UNIT'
AND org_information2 = 'Y'
List of INV Organizations
SELECT a.name,
a.organization_id,
a.creation_date,
a.last_update_date
FROM hr_organization_units a, hr_organization_information b
WHERE a.organization_id = b.organization_id
AND org_information1 = 'INV'
AND org_information2 = 'Y'
No comments:
Post a Comment
Note: Only a member of this blog may post a comment.