APPS.INV_MGD_MVT_STATS_PROC dependencies on WSH_DELIVERY_DETAILS_OB_GRP_V

Line 1456: FROM wsh_delivery_details_ob_grp_v

1452: IF l_movement_transaction.picking_line_detail_id IS NOT NULL
1453: THEN
1454: SELECT mvt_stat_status
1455: INTO l_mvt_stat_status
1456: FROM wsh_delivery_details_ob_grp_v
1457: WHERE delivery_detail_id = l_movement_transaction.picking_line_detail_id;
1458: END IF;
1459:
1460: IF (l_mvt_stat_status IS NOT NULL

Line 2300: , wsh_delivery_details_ob_grp_v wdd

2296: , MAX(wdd.delivery_detail_id) picking_line_detail_id
2297: , MAX(wdd.organization_id) shipping_organization_id
2298: FROM
2299: oe_order_lines_all oola
2300: , wsh_delivery_details_ob_grp_v wdd
2301: WHERE oola.order_source_id = 10 --combine 1st and 2nd condition to use index 11
2302: AND oola.orig_sys_document_ref = l_req_number
2303: AND oola.source_document_line_id = l_movement_transaction.requisition_line_id
2304: AND oola.line_id = wdd.source_line_id;