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.
Best answer by GPIE
Hi
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 dualI hope this helps.
+11Hi
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 = :contractIn your case, I guess the select statement would be something like:
select
IFSAPP.PURCHASE_ORDER_API.GET_AUTHORIZE_CODE(:order_no)
from dualI hope this helps.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
