Skip to main content

Hi all,

I would like to add the field Coordinator from the Purchase Order header in the menu Project Miscellaneous Parts. I have experience with adding Custom Fields with Implementation Type ‘Reference’ but not with a SQL statement. And since there is no possibility to add the field via a reference, I will need a SQL statement to do so. I tried some things but I was not able to get it right.

I would appreciate your help!

We are on APPS10 Update 7.

 

 

Hi @BZNSIMON,

Here is an example of a custom field from our implementation.  The select statement uses references to the form where the field is embedded:

select x from y where order_no = :order_no and contract = :contract

In your case, I guess the select statement would be something like:

select 
IFSAPP.PURCHASE_ORDER_API.GET_AUTHORIZE_CODE(:order_no)
from dual

I hope this helps.

Hi @GPIE,

With your input I managed to fill in the correct statement. Thanks alot!

 

 

Reply


Terms & ConditionsCookie settings