APPS.FTE_PO_INTEGRATION_GRP dependencies on WSH_DELIVERY_DETAILS

Line 106: wsh_delivery_details wdd,

102: AND WND.RCV_SHIPMENT_HEADER_ID is not null
103: union
104: select distinct wda.DELIVERY_ID, 'Y' RATE_AVAILABLE_FLAG,'N' MATCHING_FLAG
105: from WSH_DELIVERY_ASSIGNMENTS_V wda,
106: wsh_delivery_details wdd,
107: rcv_shipment_lines rsl
108: where wda.delivery_detail_id=wdd.delivery_detail_id
109: and wdd.rcv_shipment_line_id is null
110: and rsl.shipment_header_id = l_shipment_header_id

Line 160: FROM WSH_DELIVERY_DETAILS WDD,

156: wdd.ship_from_site_id vendor_site_id,
157: wdd.source_line_id,
158: wdd.po_shipment_line_id,
159: wdd.rcv_shipment_line_id
160: FROM WSH_DELIVERY_DETAILS WDD,
161: WSH_DELIVERY_ASSIGNMENTS_V WDA2,
162: fte_estimate_rates_del_temp tmp
163: WHERE WDA2.delivery_detail_id = wdd.delivery_detail_id
164: AND tmp.RATE_AVAILABLE_FLAG = 'N' and tmp.MATCHING_FLAG = 'Y'

Line 172: FROM WSH_DELIVERY_DETAILS WDD,

168: wdd.ship_from_site_id vendor_site_id,
169: wdd.source_line_id,
170: wdd.po_shipment_line_id,
171: rsl.shipment_line_id
172: FROM WSH_DELIVERY_DETAILS WDD,
173: WSH_DELIVERY_ASSIGNMENTS_V WDA,
174: rcv_shipment_lines rsl,
175: fte_estimate_rates_del_temp tmp2
176: WHERE WDA.delivery_detail_id = wdd.delivery_detail_id

Line 211: WSH_DELIVERY_DETAILS WDD,

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,
214: WSH_TRIP_STOPS WTS1,
215: WSH_TRIP_STOPS WTS2,

Line 265: WSH_DELIVERY_DETAILS WDD,

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,
268: WSH_TRIP_STOPS WTS1,
269: WSH_TRIP_STOPS WTS2,

Line 312: FROM WSH_DELIVERY_DETAILS WDD

308: WDD.RCV_SHIPMENT_LINE_ID,
309: WDD.CURRENCY_CODE,
310: WDD.NET_WEIGHT,
311: WDD.WEIGHT_UOM_CODE
312: FROM WSH_DELIVERY_DETAILS WDD
313: WHERE
314: WDD.CONTAINER_FLAG='N'
315: AND EXISTS
316: (SELECT 1 FROM WSH_DELIVERY_ASSIGNMENTS_V WDA

Line 336: FROM WSH_DELIVERY_DETAILS WDD,

332: WDD.CURRENCY_CODE,
333: WDD.INVENTORY_ITEM_ID,
334: WDD.NET_WEIGHT,
335: WDD.WEIGHT_UOM_CODE
336: FROM WSH_DELIVERY_DETAILS WDD,
337: WSH_DELIVERY_ASSIGNMENTS_V WDA
338: WHERE WDD.DELIVERY_DETAIL_ID = WDA.DELIVERY_DETAIL_ID
339: and WDA.PARENT_DELIVERY_DETAIL_ID = l_parent_delivery_detail_id;
340: