Link Server Query Example

 SELECT ORG_ID, SUBINVENTORY, SUBINV_TYPE

FROM OPENQUERY(CAROL,

'select to_number(substr(flv.lookup_code,1,4)) org_id,

flv.description subinventory,

flv.tag subinv_type

from apps.fnd_lookup_values_vl flv

where flv.lookup_type = ''EMR_ETR_MRB_SUBINV''

and flv.tag = ''MRB''')

select * from openquery(PUMA,'SELECT * FROM DWH_CALENDAR_DIM');