DBA Data[Home] [Help]

APPS.WSH_DCP_PVT dependencies on WSH_TRIP_STOPS

Line 670: wsh_trip_stops wts

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
673: and nvl(ol.shippable_flag, 'N') = 'Y'
674: and wdd.source_header_id = p_source_header_id

Line 706: wsh_trip_stops wts

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
709: and nvl(ol.shippable_flag, 'N') = 'Y'
710: and wdd.source_line_id = p_source_line_id

Line 741: wsh_trip_stops wts

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
744: and nvl(ol.shippable_flag, 'N') = 'Y'
745: and ol.header_id = oh.header_id

Line 777: wsh_trip_stops wts

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
780: and nvl(ol.shippable_flag, 'N') = 'Y'
781: and ol.header_id = oh.header_id