Inventory Management - EBS (MOSC)

MOSC Banner

Oracle Apps 11i Personlization

edited May 3, 2010 7:43PM in Inventory Management - EBS (MOSC) 1 commentAnswered
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?

 

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center