APPS.FTE_PO_INTEGRATION_GRP dependencies on WSH_DELIVERY_ASSIGNMENTS_V

Line 105: from WSH_DELIVERY_ASSIGNMENTS_V wda,

101: WHERE WND.RCV_SHIPMENT_HEADER_ID = l_shipment_header_id
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

Line 161: WSH_DELIVERY_ASSIGNMENTS_V WDA2,

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'
165: AND wda2.delivery_id = tmp.delivery_id

Line 173: WSH_DELIVERY_ASSIGNMENTS_V WDA,

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
177: AND rsl.po_line_location_id = wdd.PO_SHIPMENT_LINE_ID

Line 212: WSH_DELIVERY_ASSIGNMENTS_V WDA,

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,
216: fte_estimate_rates_del_temp tmp

Line 266: WSH_DELIVERY_ASSIGNMENTS_V WDA,

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,
270: fte_estimate_rates_del_temp tmp

Line 316: (SELECT 1 FROM WSH_DELIVERY_ASSIGNMENTS_V WDA

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
317: WHERE WDD.DELIVERY_DETAIL_ID = WDA.DELIVERY_DETAIL_ID
318: START WITH WDA.DELIVERY_DETAIL_ID = l_parent_delivery_detail_id
319: CONNECT BY PRIOR WDA.DELIVERY_DETAIL_ID = WDA.PARENT_DELIVERY_DETAIL_ID)
320: */

Line 337: WSH_DELIVERY_ASSIGNMENTS_V WDA

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:
341: