126:
127: cursor c_get_no_rates_del IS
128: select distinct tmp.delivery_id
129: FROM fte_estimate_rates_del_temp tmp,
130: WSH_DELIVERY_LEGS wdl
131: WHERE tmp.DELIVERY_ID = WDL.DELIVERY_ID
132: AND ( NVL(WDL.REPRICE_REQUIRED,'N') = 'Y'
133: OR NOT EXISTS
134: (SELECT WFC.DELIVERY_LEG_ID
205: sum(nvl(wdd.received_quantity, nvl(wdd.shipped_quantity,
206: NVL(wdd.picked_quantity, wdd.requested_quantity)))) TOTAL_SHIP_QTY,
207: SUM(TOTAL_AMOUNT) TOTAL_COST
208: FROM WSH_NEW_DELIVERIES WND,
209: WSH_DELIVERY_LEGS WDL,
210: WSH_FREIGHT_COSTS WFC,
211: WSH_DELIVERY_DETAILS WDD,
212: WSH_DELIVERY_ASSIGNMENTS_V WDA,
213: WSH_TRIPS WT,
259: WDD.CURRENCY_CODE PO_CURRENCY_CODE,
260: WFC.CURRENCY_CODE,
261: SUM(TOTAL_AMOUNT) TOTAL_COST
262: FROM WSH_NEW_DELIVERIES WND,
263: WSH_DELIVERY_LEGS WDL,
264: WSH_FREIGHT_COSTS WFC,
265: WSH_DELIVERY_DETAILS WDD,
266: WSH_DELIVERY_ASSIGNMENTS_V WDA,
267: WSH_TRIPS WT,