How to link hr_operating_units and hz_cust_acct_sites_all in oracle
Solution:-
The hr_operating_units table having the unique column that is ORGANIZATION_ID and hz_cust_acct_sites_all having the column ORG_ID which is used to join the hr_operating_units for getting customer operating_unit or getting customer details.
Example:-
select hou.name operating_unit,hcas.cust_acct_id
from hr_operating_units hou,hz_cust_acct_sites_all hcas
where hou.ORGANIZATION_ID=hcas.ORG_ID
No comments:
Post a Comment