Query is not working

0

Please help me with the below query.

EstimateAmount is available in XXYSS_Forwarding.V_Estimations Table and ShipmentSeq, Qty, ETDDate, ETADate are available in XXYSS_Forwarding.jv_Transport_order.

Data is coming from Transport_order file in jasper report, but data is not coming from V_Estimations.

Please find queries for both tables below:

Transport Order Query:

Select SHIPMENTSEQ, QTY,ETDDATE,ETADATE from "XXYSS_FORWARDING"."JV_TRANSPORT_ORDER"where SHIPMENTSEQ = $P{P_SEQ}

V_Estimations Query:

Select ESTIMATEAMOUNT from "XXYSS_FORWARDING"."V_ESTIMATIONS"Where SHIPMENTSEQ = $P{P_SHIPMENTSEQ}

 
 
 
pavanrp284's picture
Joined: Apr 13 2020 - 11:39pm
Last seen: 1 week 6 days ago

0 Answers:

No answers yet
Feedback
randomness