How Pass the multiple parameters in Execute Query

Hi all,

My Query is
SELECT PH_TXN_CODE PO_TXN_CODE,PH_COMP_CODE PO_COMP_CODE, GH_TXN_CODE GRN_Txn_Code,GH_NO GRN_Doc_No,GH_DT GRN_Doc_Dt,GH_SUPP_CODE Supplier_Code,SUPP_NAME Supplier_Name,GH_SUPP_DEL_REF DO_Ref_No,GH_SUPP_INV_REF Inv_Ref_No
FROM OT_GR_HEAD,OT_GR_REF,OM_SUPPLIER,OT_PO_HEAD
WHERE GR_GH_SYS_ID = GH_SYS_ID AND GH_SUPP_CODE = SUPP_CODE AND PH_SYS_ID = GH_REF_SYS_ID
AND GH_SUPP_CODE = ‘S001762’ AND GR_REF_NO = :PO_NO AND NVL(GH_SUPP_DEL_REF,GH_SUPP_INV_REF) = :DO_NO
AND EXISTS (SELECT 1 FROM OT_GR_ITEM WHERE GI_GH_SYS_ID = GH_SYS_ID

Passing Parameters as

But it returns empty values
If i’ try with manually entered values in Query it extracted the values

Please help me…

check this video if it helps you: https://youtu.be/-dFmsly_cJI

I need answer Dude…
in that PO_NO is not working

try keeping the variable name same as the column name in the database.

I don’t know about Queries
The Query is shared by Database expert. so i must need to use this query only

please provide solution for this query

Have you found the solution…? @nagavelly.naveen