Query ORG_ID vs ORGANIZATION_ID
select FSP.INVENTORY_ORGANIZATION_ID,
FSP.ORG_ID ,
HOU.name ,
mp.organization_code
from FINANCIALS_SYSTEM_PARAMS_ALL FSP,
HR_OPERATING_UNITS HOU ,
mtl_parameters mp
where 1=1
and FSP.ORG_ID = HOU.ORGANIZATION_ID
and FSP.INVENTORY_ORGANIZATION_ID = MP.ORGANIZATION_ID(+);
and mp.organization_code = 'MAS';
FSP.ORG_ID ,
HOU.name ,
mp.organization_code
from FINANCIALS_SYSTEM_PARAMS_ALL FSP,
HR_OPERATING_UNITS HOU ,
mtl_parameters mp
where 1=1
and FSP.ORG_ID = HOU.ORGANIZATION_ID
and FSP.INVENTORY_ORGANIZATION_ID = MP.ORGANIZATION_ID(+);
and mp.organization_code = 'MAS';
No comments:
Post a Comment