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