Is there an API call to get the Actual Delivery Date that we get on Register Purchase Order Arrival ?
Solved
API call for Actual Delivery Date
Best answer by geminirajesh
Hi Tomas,
For some reason I’m not able to use this API call in a select statement.
I’m trying to do
SELECT
Pur_Ord_Date_Calculation_API.Fetch_Calendar_Start_Date(return_date,IFSAPP.Site_API.Get_Dist_Calendar_Id('1000'),sysdate,ifsapp.Pur_Ord_Date_Calculation_API.Get_Transport_Leadtime('P102108','1','1'))
from dual;
Is there anyway we can get the return_date via a Select statement ? I want to use it in a custom field
+3HI,
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 Tomas,
This is the API call for the field from Purchase Receipt view
But I want the API call for calculating the actual delivery date in the Register Arrival entry view.
+3Hi,
my misunderstanding. Here it is:
as OUT is: deliery_date_ (your date what you want)
IN parameters:
contract_ - this you know
arrival_date_ = sysdate
Transport_Lead_Time_ can be null
IFSAPP.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 Tomas,
For some reason I’m not able to use this API call in a select statement.
I’m trying to do
SELECT
Pur_Ord_Date_Calculation_API.Fetch_Calendar_Start_Date(return_date,IFSAPP.Site_API.Get_Dist_Calendar_Id('1000'),sysdate,ifsapp.Pur_Ord_Date_Calculation_API.Get_Transport_Leadtime('P102108','1','1'))
from dual;
Is there anyway we can get the return_date via a Select statement ? I want to use it in a custom field
+3Hi,
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 DATE
AS
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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.