APPS.WSH_DELIVERY_UTIL dependencies on WSH_DELIVERY_DETAILS

Line 221: from wsh_delivery_details wdd,

217: where delivery_id =p_delivery_id;
218:
219: cursor det_tpw_cur is
220: select 'X'
221: from wsh_delivery_details wdd,
222: wsh_delivery_assignments_v wda
223: where wdd.delivery_detail_id = wda.delivery_detail_id
224: and wdd.container_flag='N'
225: and wdd.source_code ='WSH'

Line 407: wsh_delivery_details wdd

403: cursor del_cur ( p_source_line_id IN NUMBER ) is
404: select count(*)
405: from wsh_new_deliveries wnd,
406: wsh_delivery_assignments_v wda,
407: wsh_delivery_details wdd
408: where wnd.status_code in ('SR','SC')
409: --and wnd.planned_flag = 'Y'
410: and wda.delivery_id = wnd.delivery_id
411: and wda.delivery_detail_id = wdd.delivery_detail_id

Line 419: from wsh_delivery_details

415:
416: cursor det_org_cur ( p_source_line_id IN NUMBER ) is
417: select organization_id,
418: delivery_detail_id
419: from wsh_delivery_details
420: where source_code= p_source_code
421: and source_line_id = p_source_line_id
422: and rownum = 1;
423:

Line 613: from wsh_delivery_details

609: cursor det_cur(p_del_det_id IN NUMBER ) is
610: select organization_id,
611: source_code,
612: container_flag
613: from wsh_delivery_details
614: where delivery_detail_id = p_del_det_id;
615:
616:
617: cursor del_to_det_cur( p_delivery_id IN NUMBER ) is

Line 619: from wsh_delivery_details wdd,

615:
616:
617: cursor del_to_det_cur( p_delivery_id IN NUMBER ) is
618: select distinct 'X'
619: from wsh_delivery_details wdd,
620: wsh_delivery_assignments_v wda
621: where wda.delivery_id = p_delivery_id
622: and wdd.delivery_detail_id = wda.delivery_detail_id
623: and wdd.source_code = 'WSH'

Line 629: from wsh_delivery_details wdd,

625:
626: --performance fix - no need to join to wnd
627: cursor stop_to_det_cur( p_stop_id IN NUMBER ) is
628: select 'X'
629: from wsh_delivery_details wdd,
630: wsh_delivery_assignments_v wda,
631: wsh_delivery_legs wdl
632: where wdl.pick_up_stop_id = p_stop_id
633: and wda.delivery_id is not null

Line 642: from wsh_delivery_details wdd,

638: and rownum=1;
639:
640: cursor trip_to_det_cur( p_trip_id IN NUMBER ) is
641: select distinct 'X'
642: from wsh_delivery_details wdd,
643: wsh_new_deliveries wnd,
644: wsh_delivery_assignments_v wda,
645: wsh_delivery_legs wdl,
646: wsh_trip_stops wts1,

Line 662: from wsh_delivery_details wdd,

658: and wdd.container_flag = 'N';
659:
660: cursor det_stat_cur( p_delivery_id IN NUMBER) is
661: select distinct 'X'
662: from wsh_delivery_details wdd,
663: wsh_delivery_assignments_v wda
664: where wdd.source_code = 'WSH'
665: and wdd.container_flag = 'N'
666: and wdd.delivery_detail_id = wda.delivery_detail_id