Query is not working

[pavanrp284]

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}