How to Force-Logout Idle or Stuck Oracle EBS Users With One PL/SQL Package (Free Script Inside)

  How to Force-Logout Idle or Stuck Oracle EBS Users With One PL/SQL Package (Free Script Inside) If you've ever administered Oracle E-...

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