ERPstuff - Oracle EBS Community

Hi,

In form INVTTMTX, function INV_INVTTMTX_MISC

I need some help with how to do forms personalization that sends a message whenever the folowing condition evaluates to true in an issuing transaction:

ENTERED TRANSACTION QUANTITY <= (select
sum(m.TRANSACTION_QUANTITY)
from
mtl_material_transactions m
where
ENTERED ATTRIBUTE3 =m.ATTRIBUTE3
and ENTERED ATTRIBUTE4 =m.ATTRIBUTE3
and m.ATTRIBUTE3 <> 'NULL'
and m.ATTRIBUTE4 <> 'NULL'
and m.TRANSACTION_ACTION_ID= 1 -- which refers to issuing transaction
Group by
m.ORGANIZATION_ID
,m.INVENTORY_ITEM_ID
,m.ATTRIBUTE3
,m.ATTRIBUTE4)

How can I do this?