[Home] [Help]
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'
672: and wdd.source_line_id = ol.line_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'
708: and wdd.source_line_id = ol.line_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'
743: and wdd.source_line_id = ol.line_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'
779: and wdd.source_line_id = ol.line_id
1547: END IF;
1548: END Check_ITS;
1549:
1550: Procedure Check_Delivery(p_action_code IN VARCHAR2,
1551: p_dlvy_table IN WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type)
1552: IS
1553: l_debug_on BOOLEAN;
1554: l_data_inconsistent VARCHAR2(1) := 'N';
1555: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'CHECK_DELIVERY';