Skip to main content

I am new to Cloud, we are on 24R2 (not live yet).  I’m trying to fix some one of my lobbies that was converted with an IFS script.  It should return one record but it returns 0.  Any help would be appreciated. 

 

Hi ​@Elaineebi,

Could you share the WHERE condition? I’ll check and see if I can help you out.

Thanks,

Sarasi

Hi Sarasi, 

The view is Shipment_Line_Ovw and the where statement is:

&AO.Shipment_Source_Utility_API.Get_Line_Planned_Ship_Date__(SOURCE_REF1,SOURCE_REF2,SOURCE_REF3,SOURCE_REF4, SOURCE_REF_TYPE_DB) between trunc(to_date( '#TODAY#', 'YYYY-MM-DD-HH24:MI:SS' )) and trunc(to_date( '#TODAY#', 'YYYY-MM-DD-HH24:MI:SS' )) + ( 1 - 1/ ( 60*60*24 ) ) and (CONTRACT = '2210' or CONTRACT = '2220') AND upper( SHIPMENT_STATE ) = upper( 'Preliminary' )

 

Thank you for any help you can provide

Reply


Terms & ConditionsCookie settings