Oracle Apps 11i Personlization

Purchasing & Inventory forum can be used to discuss all features/issues related to Oracle Purchasing & Inventory.
Post Reply
AIMAM
Posts: 139
Joined: Thu May 17, 2007 6:04 am
Location: Egypt

Oracle Apps 11i Personlization

Post by AIMAM »

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?
Post Reply

Who is online

Users browsing this forum: No registered users and 6 guests