Showing posts with label Form Personalization (Purchase Order) : Show the Last Unit Price of the Item at PO Line Level.. Show all posts
Showing posts with label Form Personalization (Purchase Order) : Show the Last Unit Price of the Item at PO Line Level.. Show all posts

Monday, 26 October 2015

Form Personalization (Purchase Order) : Show the Last Unit Price of the Item at PO Line Level.



FORM PERSONALIZATION (PURCHASE ORDER).
Show the Last Unit Price of the Item at PO Line Level.

Step : 1 


Create From Personalization Name and Sequence.
Then chose Condition Tab
Trigger Event: WHEN-NEW-ITEM-INSTANCE
Trigger Object: PO_LINES.UNIT_PRICE


  

Step : 2


Step : 3


= 'Last Unit Price' || ' Rs. ' || (select to_char(unit_price)
from po_lines_all
where creation_date=(select max(creation_date)from po_lines_all) and rownum=1
and item_id= (select distinct inventory_item_id from mtl_system_items where segment1  =:PO_LINES.ITEM_NUMBER ))
 
 Step :4

How to Call a Seeded Oracle Form from a Custom Form (Step-by-Step Guide)

  How to Call a Seeded Oracle Form from a Custom Form (Step-by-Step Guide) Introduction In Oracle E-Business Suite, it is a common requirem...