eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WSH_SHIP_CONFIRM_ACTIONS dependencies on WSH_DELIVERY_DETAILS

Line 71: from wsh_delivery_details dd,

67: msnt.attribute13,
68: msnt.attribute14,
69: msnt.attribute15, -- End of Bug 3628620
70: dd.inventory_item_id -- 3704188
71: from wsh_delivery_details dd,
72: wsh_delivery_assignments_v da,
73: wsh_delivery_legs dg,
74: wsh_new_deliveries dl,
75: wsh_trip_stops st,

Line 111: from wsh_delivery_details dd,

107: msnt.attribute13,
108: msnt.attribute14,
109: msnt.attribute15, -- End of Bug 3628620
110: dd.inventory_item_id -- 3704188
111: from wsh_delivery_details dd,
112: wsh_delivery_assignments_v da,
113: wsh_delivery_legs dg,
114: wsh_new_deliveries dl,
115: wsh_trip_stops st,

Line 151: from wsh_delivery_details dd,

147: msn.attribute13,
148: msn.attribute14,
149: msn.attribute15, -- End of Bug 3628620
150: dd.inventory_item_id -- 3704188
151: from wsh_delivery_details dd,
152: wsh_delivery_assignments_v da,
153: wsh_delivery_legs dg,
154: wsh_new_deliveries dl,
155: wsh_trip_stops st,

Line 191: from wsh_delivery_details dd,

187: msn.attribute13,
188: msn.attribute14,
189: msn.attribute15, -- End of Bug 3628620
190: dd.inventory_item_id -- 3704188
191: from wsh_delivery_details dd,
192: wsh_delivery_assignments_v da,
193: wsh_delivery_legs dg,
194: wsh_new_deliveries dl,
195: wsh_trip_stops st,

Line 422: -- and updating wsh_delivery_details only when p_transfer_param is 'WDD'

418:
419:
420: ins_rows := ins_rows + sql%rowcount;
421: -- Bug 6625172: Removing Delete of msnt for each transaction_temp_id from here
422: -- and updating wsh_delivery_details only when p_transfer_param is 'WDD'
423: IF p_transfer_param = 'WDD' THEN
424: /* FORALL i IN 1 .. cur_fetch
425: DELETE FROM mtl_serial_numbers_temp
426: WHERE transaction_temp_id = l_transaction_temp_id(i)

Line 432: UPDATE wsh_delivery_details

428:
429: del_rows := del_rows + sql%rowcount;
430: ELSE*/
431: FORALL i IN 1 .. cur_fetch
432: UPDATE wsh_delivery_details
433: SET serial_number = NULL,
434: transaction_temp_id = l_transaction_temp_id(i)
435: WHERE delivery_detail_id = l_delivery_detail_id(i);
436:

Line 452: from wsh_delivery_details dd,

448: --{
449: DELETE mtl_serial_numbers_temp
450: WHERE transaction_temp_id IN
451: ( SELECT DISTINCT dd.transaction_temp_id
452: from wsh_delivery_details dd,
453: wsh_delivery_assignments da,
454: wsh_delivery_legs dg,
455: wsh_new_deliveries dl,
456: wsh_trip_stops st,

Line 485: from wsh_delivery_details dd,

481: --{
482: DELETE mtl_serial_numbers_temp
483: WHERE transaction_temp_id IN
484: ( SELECT DISTINCT dd.transaction_temp_id
485: from wsh_delivery_details dd,
486: wsh_delivery_assignments da,
487: wsh_delivery_legs dg,
488: wsh_new_deliveries dl,
489: wsh_trip_stops st,

Line 512: ', Number of rows updated in wsh_delivery_details: '|| to_char(upd_rows) );

508:
509: IF l_debug_on THEN
510: WSH_DEBUG_SV.log(l_module_name,'Numbers of rows inserted into wsh_serial_numbers: '|| to_char(ins_rows) ||
511: ', Number of rows deleted from mtl_serial_numbers_temp: '|| to_char(del_rows) ||
512: ', Number of rows updated in wsh_delivery_details: '|| to_char(upd_rows) );
513: WSH_DEBUG_SV.pop(l_module_name);
514: END IF;
515:
516: EXCEPTION

Line 596: -- Case III : 'Serial Number' is present in wsh_delivery_details

592: p_batch_id => p_batch_id,
593: p_interfacing => p_interfacing,
594: x_return_status => x_return_status );
595:
596: -- Case III : 'Serial Number' is present in wsh_delivery_details
597: transfer_serial_numbers_pvt(
598: p_transfer_param => 'WDD',
599: p_batch_id => p_batch_id,
600: p_interfacing => p_interfacing,

Line 878: wsh_delivery_details wdd,

874: wsh_delivery_legs wdl,
875: wsh_delivery_legs wdl2,
876: wsh_delivery_assignments_v wda,
877: wsh_delivery_assignments_v wda2,
878: wsh_delivery_details wdd,
879: wsh_delivery_details wdd2
880: WHERE wts.batch_id = p_batch_id
881: AND wts.stop_id = wdl.pick_up_stop_id
882: AND wda.delivery_id = wdl.delivery_id

Line 879: wsh_delivery_details wdd2

875: wsh_delivery_legs wdl2,
876: wsh_delivery_assignments_v wda,
877: wsh_delivery_assignments_v wda2,
878: wsh_delivery_details wdd,
879: wsh_delivery_details wdd2
880: WHERE wts.batch_id = p_batch_id
881: AND wts.stop_id = wdl.pick_up_stop_id
882: AND wda.delivery_id = wdl.delivery_id
883: AND wda.delivery_detail_id = wdd.delivery_detail_id

Line 2740: FROM wsh_delivery_details dd,

2736: --added for BUG 4538005
2737: dd.ship_from_location_id ship_from_location_id,
2738: dd.ship_to_site_use_id ship_to_site_use_id
2739: --
2740: FROM wsh_delivery_details dd,
2741: wsh_delivery_assignments_v da,
2742: wsh_delivery_legs dg,
2743: wsh_new_deliveries dl,
2744: wsh_trip_stops st,

Line 2747: wsh_delivery_details dd1,

2743: wsh_new_deliveries dl,
2744: wsh_trip_stops st,
2745: wsh_trips tr,
2746: wsh_carriers wcv,
2747: wsh_delivery_details dd1,
2748: wsh_delivery_assignments_v da1
2749: WHERE st.stop_id = dg.pick_up_stop_id
2750: AND st.batch_id = p_batch_id
2751: AND st.stop_location_id = dl.initial_pickup_location_id

Line 3893: UPDATE wsh_delivery_details

3889: END IF;
3890:
3891: IF (l_delivery_detail_tbl.count > 0) THEN
3892: FORALL i IN l_delivery_detail_tbl.first..l_delivery_detail_tbl.last
3893: UPDATE wsh_delivery_details
3894: SET inv_interfaced_flag = c_inv_int_full
3895: WHERE delivery_detail_id = l_delivery_detail_tbl(i)
3896: AND container_flag = 'N';
3897: END IF;

Line 4205: update wsh_delivery_details dd

4201: -- Bug#7271241 :removed source_code from where clause as DDs can be
4202: -- associated to OKE system.
4203: IF (nvl(l_detail_ids_count,0) > 0) THEN
4204: FORALL i in l_detail_ids_tbl.FIRST..l_detail_ids_tbl.LAST
4205: update wsh_delivery_details dd
4206: set inv_interfaced_flag = 'N'
4207: where inv_interfaced_flag = 'P'
4208: and not exists (
4209: select picking_line_id

Line 4437: from wsh_delivery_details dd,

4433:
4434: FUNCTION More_Shipment_Exist(p_delivery_id number, p_source_code varchar2, p_source_line_id number) RETURN BOOLEAN is
4435: cursor assigned_line_total is
4436: SELECT count(*) total
4437: from wsh_delivery_details dd,
4438: wsh_delivery_assignments_v da,
4439: wsh_new_deliveries ds
4440: where dd.delivery_detail_id = da.delivery_detail_id
4441: and da.delivery_id = ds.delivery_id

Line 4452: from wsh_delivery_details dd,

4448: and dd.released_status <> 'D' ; /* H integration: wrudge */
4449: l_assigned_total assigned_line_total%ROWTYPE;
4450: cursor unassigned_line_total is
4451: SELECT count(*) total
4452: from wsh_delivery_details dd,
4453: wsh_delivery_assignments_v da
4454: where dd.delivery_detail_id = da.delivery_detail_id
4455: and da.delivery_id is NULL
4456: and dd.source_line_id = p_source_line_id

Line 4542: from wsh_delivery_details wdd,

4538: -- Shipment Cancellation Request or Shipment Requested
4539:
4540: cursor other_batch_delivery_details is
4541: select sum(nvl(wdd.picked_quantity, wdd.requested_quantity))
4542: from wsh_delivery_details wdd,
4543: wsh_delivery_assignments_v da,
4544: wsh_new_deliveries wnd
4545: where wdd.source_line_id=p_source_line_id and
4546: wdd.source_code = 'OE' and

Line 4752: from wsh_delivery_details

4748: WSH_DEBUG_SV.log(l_module_name,'P_SOURCE_LINE_ID',P_SOURCE_LINE_ID);
4749: END IF;
4750: --
4751: SELECT count(*) into l_count
4752: from wsh_delivery_details
4753: where top_model_line_id is not null
4754: and source_line_id = p_source_line_id
4755: and source_code = p_source_code
4756: and container_flag = 'N'

Line 4804: from wsh_delivery_details

4800: END IF;
4801: --
4802: if (part_of_pto(p_source_code,p_source_line_id) = TRUE) THEN
4803: SELECT distinct top_model_line_id into l_top_id
4804: from wsh_delivery_details
4805: where source_line_id = p_source_line_id
4806: and source_code = p_source_code
4807: and container_flag = 'N'
4808: and released_status <> 'D' ; /* H integration: wrudge */

Line 4865: update wsh_delivery_details dd

4861: --
4862: WSH_DEBUG_SV.log(l_module_name,'p_batch_id',p_batch_id);
4863: END IF;
4864: --
4865: update wsh_delivery_details dd
4866: set inv_interfaced_flag = c_inv_int_full
4867: where (exists (
4868: SELECT mmt.picking_line_id
4869: FROM mtl_material_transactions mmt

Line 5033: FROM wsh_delivery_Details dd,

5029: -- have failed interface to OM.
5030:
5031: CURSOR c_failed_stops (p_batch_id NUMBER) IS
5032: SELECT DISTINCT stop_id
5033: FROM wsh_delivery_Details dd,
5034: wsh_delivery_assignments_v da ,
5035: wsh_delivery_legs dg,
5036: wsh_new_deliveries dl,
5037: wsh_trip_stops st

Line 5447: FROM wsh_delivery_details wdd

5443:
5444:
5445: CURSOR top_model_line_csr(p_batch_id NUMBER, p_top_model_line_id NUMBER, p_source_header_id NUMBER) IS
5446: SELECT delivery_detail_id
5447: FROM wsh_delivery_details wdd
5448: WHERE wdd.top_model_line_id = p_top_model_line_id
5449: AND wdd.source_header_id = p_source_header_id -- bug 3642085
5450: AND wdd.source_code = 'OE' -- bug 3642085
5451: MINUS

Line 5453: from wsh_delivery_details wdd,

5449: AND wdd.source_header_id = p_source_header_id -- bug 3642085
5450: AND wdd.source_code = 'OE' -- bug 3642085
5451: MINUS
5452: SELECT wdd.delivery_detail_id
5453: from wsh_delivery_details wdd,
5454: wsh_delivery_assignments_v wda,
5455: wsh_delivery_legs wdl,
5456: wsh_trip_stops wts
5457: where wts.batch_id = p_batch_id

Line 5469: from wsh_delivery_details wdd

5465: and wdd.top_model_line_id = p_top_model_line_id;
5466:
5467: CURSOR ship_set_line_csr(p_batch_id NUMBER, p_ship_set_id NUMBER, p_source_header_id NUMBER) IS
5468: Select delivery_detail_id
5469: from wsh_delivery_details wdd
5470: WHERE wdd.ship_set_id = p_ship_set_id
5471: AND wdd.source_header_id = p_source_header_id -- bug 3642085
5472: AND wdd.source_code = 'OE' -- bug 3642085
5473: MINUS

Line 5475: from wsh_delivery_details wdd,

5471: AND wdd.source_header_id = p_source_header_id -- bug 3642085
5472: AND wdd.source_code = 'OE' -- bug 3642085
5473: MINUS
5474: select wdd.delivery_detail_id
5475: from wsh_delivery_details wdd,
5476: wsh_delivery_assignments_v wda,
5477: wsh_delivery_legs wdl,
5478: wsh_trip_stops wts
5479: where wts.batch_id = p_batch_id

Line 5490: from wsh_delivery_details wdd

5486: and wdd.ship_set_id = p_ship_set_id;
5487:
5488: CURSOR std_item_line_csr (p_batch_id NUMBER, p_source_line_id NUMBER) IS
5489: SELECT delivery_detail_id
5490: from wsh_delivery_details wdd
5491: WHERE wdd.source_line_id = p_source_line_id
5492: AND wdd.source_code = 'OE' -- bug 3642085
5493: MINUS
5494: SELECT wdd.delivery_detail_id

Line 5495: from wsh_delivery_details wdd,

5491: WHERE wdd.source_line_id = p_source_line_id
5492: AND wdd.source_code = 'OE' -- bug 3642085
5493: MINUS
5494: SELECT wdd.delivery_detail_id
5495: from wsh_delivery_details wdd,
5496: wsh_delivery_assignments_v wda,
5497: wsh_delivery_legs wdl,
5498: wsh_trip_stops wts
5499: where wts.batch_id = p_batch_id

Line 5969: FROM wsh_delivery_details wdd,

5965: ORDER BY stop_id ;
5966:
5967: CURSOR c_get_stop_lines (p_stop_id NUMBER) IS
5968: SELECT wdd.source_line_id
5969: FROM wsh_delivery_details wdd,
5970: wsh_trip_stops wts,
5971: wsh_delivery_legs wdl,
5972: wsh_delivery_assignments_v wda
5973: WHERE wts.stop_id = p_stop_id

Line 6242: UPDATE wsh_delivery_details dd

6238: l_source_code := 'OE';
6239: l_released_status := 'D';
6240: -- bug 3761090
6241: FORALL i IN l_start_index..l_end_index
6242: UPDATE wsh_delivery_details dd
6243: SET oe_interfaced_flag = l_oe_interfaced_flag
6244: WHERE source_line_id = p_bulk_ship_line.line_id(i)
6245: and container_flag = l_container_flag
6246: and source_code = l_source_code

Line 6330: UPDATE wsh_delivery_details dd

6326: l_container_flag := 'N';
6327: l_source_code := 'OE';
6328: l_released_status := 'D';
6329:
6330: UPDATE wsh_delivery_details dd
6331: set oe_interfaced_flag = l_oe_interfaced_flag
6332: where delivery_detail_id in (
6333: SELECT da.delivery_detail_id
6334: FROM wsh_delivery_assignments_v da ,

Line 6361: UPDATE wsh_delivery_details dd

6357: l_source_code := 'OE';
6358: l_released_status := 'D';
6359:
6360: FORALL i IN l_start_index..l_end_index
6361: UPDATE wsh_delivery_details dd
6362: SET oe_interfaced_flag = l_oe_interfaced_flag
6363: WHERE source_line_id = p_bulk_ship_line.line_id(i)
6364: and container_flag = l_container_flag
6365: and source_code = l_source_code

Line 6420: UPDATE wsh_delivery_details dd

6416: l_container_flag := 'N';
6417: l_source_code := 'OE';
6418: l_released_status := 'D';
6419: FORALL i IN l_start_index..l_end_index
6420: UPDATE wsh_delivery_details dd
6421: SET oe_interfaced_flag = Decode(p_bulk_ship_line.error_flag(i),'Y','N','Y')
6422: WHERE source_line_id = p_bulk_ship_line.line_id(i)
6423: and container_flag = l_container_flag
6424: and source_code = l_source_code

Line 6804: FROM wsh_delivery_Details dd,

6800: --Bug 2177678 ,removed the use of oe_order_lines_all
6801: --Now OM locks oe_order_lines_all table for the associated lines
6802: CURSOR lock_delivery_line(p_batch_id NUMBER,c_source_header_id NUMBER,c_source_line_id NUMBER) IS
6803: SELECT dd.source_line_id
6804: FROM wsh_delivery_Details dd,
6805: wsh_delivery_assignments_v da ,
6806: wsh_delivery_legs dg,
6807: wsh_new_deliveries dl,
6808: wsh_trip_stops st

Line 6827: FROM wsh_delivery_details wdd

6823: CURSOR lock_dds_line_set(c_source_header_id NUMBER,
6824: c_source_line_set_id NUMBER,
6825: c_batch_id NUMBER) IS
6826: SELECT wdd.delivery_detail_id
6827: FROM wsh_delivery_details wdd
6828: WHERE wdd.source_code = 'OE'
6829: AND wdd.source_header_id = c_source_header_id
6830: AND wdd.source_line_set_id = c_source_line_set_id
6831: AND wdd.released_status <> 'D'

Line 6845: FROM wsh_delivery_details wdd

6841:
6842: CURSOR lock_dds_line(c_source_header_id NUMBER, c_source_line_id NUMBER,
6843: c_batch_id NUMBER) IS
6844: SELECT wdd.delivery_detail_id
6845: FROM wsh_delivery_details wdd
6846: WHERE wdd.source_code = 'OE'
6847: AND wdd.source_header_id = c_source_header_id
6848: AND wdd.source_line_id = c_source_line_id
6849: AND wdd.released_status <> 'D'

Line 6863: FROM wsh_delivery_details dd

6859:
6860:
6861: CURSOR c_remain_detail_id(c_source_line_id NUMBER) IS
6862: SELECT delivery_detail_id
6863: FROM wsh_delivery_details dd
6864: WHERE source_line_id = c_source_line_id AND
6865: source_code = 'OE' AND
6866: released_status IN ('R', 'B', 'N', 'S', 'X') AND
6867: NVL(container_flag, 'N') = 'N';

Line 6873: from wsh_delivery_details wdd

6869: CURSOR c_remain_lines(c_source_line_set_id NUMBER,
6870: c_source_header_id NUMBER,
6871: p_batch_id NUMBER) IS
6872: SELECT DISTINCT wdd.source_line_id
6873: from wsh_delivery_details wdd
6874: where wdd.source_header_id = c_source_header_id
6875: and wdd.source_code = 'OE'
6876: and wdd.source_line_set_id = c_source_line_set_id
6877: and not exists (

Line 6894: from wsh_delivery_details wdd,

6890:
6891: CURSOR c_picked_dd(c_source_line_id NUMBER,
6892: c_source_header_id NUMBER) IS
6893: select 'x'
6894: from wsh_delivery_details wdd,
6895: wsh_delivery_assignments_v wda,
6896: wsh_new_deliveries wnd
6897: where wdd.source_line_id = c_source_line_id
6898: and wdd.source_code = 'OE'

Line 6964: from wsh_delivery_details

6960: --HVOP heali
6961: /*
6962: CURSOR check_bulk_csr (cp_batch_id NUMBER) IS
6963: select 'X'
6964: from wsh_delivery_details
6965: where source_line_id in (select source_line_id
6966: from wsh_delivery_details wdd,
6967: wsh_delivery_assignments_v wda,
6968: wsh_delivery_legs wdl,

Line 6966: from wsh_delivery_details wdd,

6962: CURSOR check_bulk_csr (cp_batch_id NUMBER) IS
6963: select 'X'
6964: from wsh_delivery_details
6965: where source_line_id in (select source_line_id
6966: from wsh_delivery_details wdd,
6967: wsh_delivery_assignments_v wda,
6968: wsh_delivery_legs wdl,
6969: wsh_trip_stops wts
6970: where wts.batch_id = cp_batch_id

Line 6979: from wsh_delivery_details wdd,

6975: and wdd.source_code = 'OE'
6976: )
6977: and (delivery_detail_id not in
6978: (select wdd.delivery_detail_id
6979: from wsh_delivery_details wdd,
6980: wsh_delivery_assignments_v wda,
6981: wsh_delivery_legs wdl,
6982: wsh_trip_stops wts
6983: where wts.batch_id = cp_batch_id

Line 7005: wsh_delivery_details wdd

7001: select 'X'
7002: from wsh_trip_stops wts,
7003: wsh_delivery_legs wdl,
7004: wsh_delivery_assignments wda ,
7005: wsh_delivery_details wdd
7006: where wts.batch_id = cp_batch_id
7007: and wdl.pick_up_stop_id = wts.stop_id
7008: and wda.delivery_id = wdl.delivery_id
7009: and wdd.delivery_detail_id = wda.delivery_detail_id

Line 7013: from wsh_delivery_details wdd2

7009: and wdd.delivery_detail_id = wda.delivery_detail_id
7010: and wdd.container_flag = 'N'
7011: and wdd.source_code = 'OE'
7012: and (EXISTS (select 'any non-cancelled line outside batch'
7013: from wsh_delivery_details wdd2
7014: where wdd2.source_line_id = wdd.source_line_id
7015: and wdd2.source_code = 'OE'
7016: and wdd2.container_flag = 'N'
7017: and wdd2.released_status <> 'D'

Line 7023: wsh_delivery_details wdd3

7019: (select wda3.delivery_detail_id
7020: from wsh_delivery_assignments wda3 ,
7021: wsh_delivery_legs wdl3,
7022: wsh_trip_stops wts3,
7023: wsh_delivery_details wdd3
7024: where wts3.batch_id = cp_batch_id
7025: and wdl3.pick_up_stop_id = wts3.stop_id
7026: and wda3.delivery_id = wdl3.delivery_id
7027: and wdd3.delivery_detail_id = wda3.delivery_detail_id

Line 7056: FROM wsh_delivery_Details dd,

7052: ol.ordered_quantity2 ordered_quantity2,
7053: ol.org_id org_id,
7054: sum( nvl(dd.shipped_quantity,0) ) shipping_quantity,
7055: sum( nvl(dd.shipped_quantity2, 0 )) shipping_quantity2
7056: FROM wsh_delivery_Details dd,
7057: wsh_delivery_assignments_v da ,
7058: wsh_delivery_legs dg,
7059: wsh_new_deliveries dl,
7060: wsh_trip_stops st,

Line 7122: FROM wsh_delivery_Details dd,

7118: sum( dd.requested_quantity ) total_requested_quantity,
7119: sum( dd.requested_quantity2 ) total_requested_quantity2,
7120: sum( nvl(dd.shipped_quantity, 0 )) total_shipped_quantity ,
7121: sum( nvl(dd.shipped_quantity2, 0 )) total_shipped_quantity2
7122: FROM wsh_delivery_Details dd,
7123: wsh_delivery_assignments_v da ,
7124: wsh_delivery_legs dg,
7125: wsh_new_deliveries dl,
7126: wsh_trip_stops st,

Line 7596: FROM wsh_delivery_Details dd,

7592: SELECT SUM(dd.requested_quantity),
7593: SUM( nvl(dd.shipped_quantity, 0 ))
7594: INTO l_tot_dd_req_qty,
7595: l_tot_dd_shp_qty
7596: FROM wsh_delivery_Details dd,
7597: wsh_delivery_assignments_v da ,
7598: wsh_delivery_legs dg,
7599: wsh_new_deliveries dl,
7600: wsh_trip_stops st

Line 8378: update wsh_delivery_details

8374: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
8375: -- mark all 'N' as 'P'
8376:
8377: /* record is already processed by inventory */
8378: update wsh_delivery_details
8379: set inv_interfaced_flag = 'P'
8380: where delivery_detail_id in (
8381: SELECT da.delivery_detail_id
8382: FROM wsh_delivery_assignments_v da ,

Line 8528: SELECT source_line_id, organization_id, org_id from wsh_delivery_details

8524: IS
8525:
8526: -- CSUN 01/19/2000 need to modify this cursor once we want to include containers
8527: CURSOR C_Details(p_del_detail_id number) is
8528: SELECT source_line_id, organization_id, org_id from wsh_delivery_details
8529: where delivery_detail_id = p_del_detail_id
8530: and container_flag = 'N'
8531: and released_status <> 'D' ; /* H integration: wrudge */
8532: l_detail_rec c_details%ROWTYPE;

Line 8785: wsh_delivery_details wdd

8781: SELECT wdd.delivery_detail_id
8782: FROM wsh_trip_stops wts,
8783: wsh_delivery_legs wdl,
8784: wsh_delivery_assignments_v wda,
8785: wsh_delivery_details wdd
8786: WHERE wdd.inv_interfaced_flag IN ('N', 'P')
8787: AND wts.batch_id = p_batch_id
8788: AND wts.stop_location_id = wdd.ship_from_location_id
8789: AND wts.stop_id = wdl.pick_up_stop_id

Line 8853: wsh_delivery_details wdd

8849: SELECT wdd.delivery_detail_id
8850: FROM wsh_trip_stops wts,
8851: wsh_delivery_legs wdl,
8852: wsh_delivery_assignments_v wda,
8853: wsh_delivery_details wdd
8854: WHERE wdd.oe_interfaced_flag <> 'Y'
8855: AND wts.batch_id = p_batch_id
8856: AND wts.stop_location_id = wdd.ship_from_location_id
8857: AND wts.stop_id = wdl.pick_up_stop_id