Hi,as this is not function but procedure, you cannot use it in CF.you can write your own function like below and that one can be used directly in CF.and better is not via select.CREATE OR REPLACE FUNCTION c_return_delivery_date ( contract_ VARCHAR2, arrival_date_ DATE, Transport_Lead_Time_ NUMBER) RETURN DATEAS delivery_date_ DATE;BEGIN Pur_Ord_Date_Calculation_API.Fetch_Calendar_Start_Date(delivery_date_, IFSAPP.Site_API.Get_Dist_Calendar_Id(contract_), arrival_date_ , Transport_Lead_Time_); IF delivery_date_ IS NULL THEN delivery_date_ := SYSDATE; END IF; RETURN delivery_date_;END c_return_delivery_date; And the best will be put that function into some custom api, that you can grant it to the users.Tomas
Hi,my misunderstanding. Here it is:as OUT is: deliery_date_ (your date what you want)IN parameters:contract_ - this you knowarrival_date_ = sysdateTransport_Lead_Time_ can be nullIFSAPP.Pur_Ord_Date_Calculation_API.Fetch_Calendar_Start_Date(deliery_date_ , IFSAPP.Site_API.Get_Dist_Calendar_Id(contract_), arrival_date_ , Transport_Lead_Time_ ); Tomas
HI,no for V9 is valid this one:PURCHASE_RECEIPT_API.Get_Arrival_Date(order_no_ => , line_no_ => , release_no_ => , receipt_no_ => ) or PURCHASE_RECEIPT_API.Get_Delivery_Date(order_no_ => , line_no_ => , release_no_ => , receipt_no_ => ) not sure which one you need to see.Tomas
Hi,did you check supplier setup:or you have to check which conditions are used for that row directly in report via report designer. Tomas
HI,RECEIPT_INFO_API.Get_Delivery_Date(receipt_sequence); Tomas
Hi,there are several options:Part Lines have setup on Purchase Part window. In this window you can force in list of values from saved search No Part lines - the same you can do similar saved search and the best iscreate custom enumeration with 2 valuse create Custom Field (enumeration from point 1) in purchase groups with two values like “PART” and “NO PART” btw, this type can be used in search, too then create Custome Events (new, update) (all windows: Purchase Part, Purchase requisition/order no Lines Part / no Part)which will block user to use different purchase group as this type as presetup. this will allow users to add groups and setup where can be used. example of event for Purchase Order line EVENT ACTION ACTION FOR PART NO and result for user Tomas
Already have an account? Login
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.