INVENTORY_PART_API to get PART STATUS

Inventory_Part_API.Get_Part_Status(contract_, part_no_)

Hi @ronhu,

The method is Inventory_Part_API.Get_Part_Status.

FUNCTION Get_Part_Status (
   contract_ IN VARCHAR2,
   part_no_ IN VARCHAR2 ) RETURN VARCHAR2

Hope this helps!

@Charith Epitawatta Cool! I believe it will work. Thank you.

@Technical Outlaws Thank you very much.

@Charith Epitawatta 

@Technical Outlaws 

would you be able to do me a favor, the Inventory_Part_API.Get_Part_Status(contract_, part_no_) API is returning only the status code, for example “A”, but I need description, “A”= “Active”.  what is the code for fetching the description? 

Thank you.

Hello,

I think Inventory_Part_Status_Par_API.Get_Description(part_status)  will work

OR

You can use CASE clause in your queries like;

SELECT  PART_STATUS ,     

(CASE

            WHEN PART_STATUS = 'A' THEN 'Active'
             WHEN PART_STATUS = 'P' THEN 'Pasive'

END) PART_STATUS_DESC

FROM INVENTORY_PART

Kind Regards

Ozgun Bal

@Ozgun BAL Wonderful, it’s working. Thank you.