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?
Oracle Apps 11i Personlization
Who is online
Users browsing this forum: No registered users and 5 guests