Pls. help me out by correcting the following coding in “purchasing Requisition” using formula on lin

Hi,

Can anyone fine tune the below personalization condition.

Formula :   Required Quantity <= Maximum Level – (On Hand Quantity + Outstanding MRP Quantity + Outstanding PO Quantity

Trigger Event  WHEN-VALIDATE-RECORD

Trigger Object  LINES

Condition 

   NVL((SELECT (A.MAX_LEVEL) - (B.OHQ + C.OS_MRP_QTY + D.OS_PO_QTY) 

            ALLOWED_QTY

           FROM(select msi.MAX_MINMAX_QUANTITY 

                        MAX_LEVEL

                        from mtl_system_items_b msi

                        where msi.INVENTORY_ITEM_STATUS_CODE='Active'

                        and msi.ORGANIZATION_ID=347

                        and msi.MAX_MINMAX_QUANTITY IS NOT NULL

                        and MSI.INVENTORY_ITEM_ID=${item.LINES.ITEM_id.value}) A,

             (select NVL(SUM(moq.transaction_quantity),0) OHQ

              from mtl_onhand_quantities_detail moq