DBA Data[Home] [Help]

APPS.WMS_PICK_DROP_PVT dependencies on OE_ORDER_HEADERS_ALL

Line 10530: , oe_order_headers_all ooha

10526: , COUNT(DISTINCT ooha.order_number)
10527: FROM wsh_delivery_assignments_v wda
10528: , wsh_delivery_details_ob_grp_v wdd
10529: , oe_order_lines_all oola
10530: , oe_order_headers_all ooha
10531: WHERE wda.delivery_id = p_del_id
10532: AND wda.delivery_detail_id = wdd.delivery_detail_id
10533: AND wdd.source_line_id = oola.line_id
10534: AND oola.header_id = ooha.header_id;