Rest api to Extract Items type data

Summary:

Hi,

I need to get Item type as can be fetched from the SQL query for an custom integration use case. Basically we need to determine it is a standard or modal item for the given item name and organization code.

Content (please ensure you mask any confidential information):

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):

select ESIB.ITEM_NUMBER,IOP.ORGANIZATION_CODE,

--FLV.LOOKUP_CODE,

FLV.MEANING

--,ESIB.ORGANIZATION_ID

from EGP_SYSTEM_ITEMS_B ESIB,

FND_LOOKUP_VALUES FLV,

inv_org_parameters IOP