APPS.WSH_DCP_PVT dependencies on WSH_DELIVERY_ASSIGNMENTS_V

Line 667: wsh_delivery_assignments_v wda,

663: wnd.delivery_id, wnd.status_code dlvy_status_code, wts.status_code stop_status_code, wdl.delivery_leg_id
664: from wsh_delivery_details wdd,
665: oe_order_lines_all ol,
666: oe_order_headers_all oh,
667: wsh_delivery_assignments_v wda,
668: wsh_new_deliveries wnd,
669: wsh_delivery_legs wdl,
670: wsh_trip_stops wts
671: where wdd.source_code = 'OE'

Line 703: wsh_delivery_assignments_v wda,

699: wnd.delivery_id, wnd.status_code dlvy_status_code, wts.status_code stop_status_code, wdl.delivery_leg_id
700: from wsh_delivery_details wdd,
701: oe_order_lines_all ol,
702: oe_order_headers_all oh,
703: wsh_delivery_assignments_v wda,
704: wsh_new_deliveries wnd,
705: wsh_delivery_legs wdl,
706: wsh_trip_stops wts
707: where wdd.source_code = 'OE'

Line 738: wsh_delivery_assignments_v wda,

734: wnd.delivery_id, wnd.status_code dlvy_status_code, wts.status_code stop_status_code, wdl.delivery_leg_id
735: from wsh_delivery_details wdd,
736: oe_order_lines_all ol,
737: oe_order_headers_all oh,
738: wsh_delivery_assignments_v wda,
739: wsh_new_deliveries wnd,
740: wsh_delivery_legs wdl,
741: wsh_trip_stops wts
742: where wdd.source_code = 'OE'

Line 774: wsh_delivery_assignments_v wda,

770: wnd.delivery_id, wnd.status_code dlvy_status_code, wts.status_code stop_status_code, wdl.delivery_leg_id
771: from wsh_delivery_details wdd,
772: oe_order_lines_all ol,
773: oe_order_headers_all oh,
774: wsh_delivery_assignments_v wda,
775: wsh_new_deliveries wnd,
776: wsh_delivery_legs wdl,
777: wsh_trip_stops wts
778: where wdd.source_code = 'OE'

Line 830: wsh_delivery_assignments_v wda

826: CURSOR c2_dlvy IS
827: select wdd.source_header_number, wdd.source_line_number, wdd.delivery_detail_id
828: from wsh_delivery_details wdd,
829: oe_order_lines_all ol,
830: wsh_delivery_assignments_v wda
831: where wdd.source_code = 'OE'
832: and wdd.source_line_id = ol.line_id
833: and nvl(wdd.ship_tolerance_above,0) = 0
834: and nvl(wdd.ship_tolerance_below,0) = 0

Line 909: wsh_delivery_assignments_v wda,

905:
906: CURSOR C12_dlvy IS
907: select wdd.source_header_number, wdd.source_line_number, wdd.delivery_detail_id
908: from wsh_delivery_details wdd,
909: wsh_delivery_assignments_v wda,
910: oe_order_lines_all ol
911: where wdd.source_code = 'OE'
912: and wdd.source_line_id = ol.line_id
913: and wdd.delivery_detail_id = wda.delivery_detail_id