APPS.CSP_PICK_UTILS dependencies on WSH_DELIVERY_DETAILS

Line 2383: wsh_delivery_details wdd

2379: SELECT distinct waybill,
2380: name
2381: FROM wsh_new_deliveries wnd,
2382: wsh_delivery_Assignments wda,
2383: wsh_delivery_details wdd
2384: WHERE wnd.delivery_id = wda.delivery_id
2385: AND wdd.delivery_detail_id = wda.delivery_Detail_id
2386: AND wdd.source_line_id = p_order_line_id
2387: AND wdd.source_code = 'OE';

Line 2471: FROM wsh_delivery_details

2467: l_status := p_flow_status_code;
2468:
2469: SELECT sum(decode(released_status, 'Y', 1, 0)), sum(1)
2470: INTO l_released_count, l_total_count
2471: FROM wsh_delivery_details
2472: WHERE source_line_id = p_order_line_id
2473: AND source_code = 'OE';
2474:
2475: IF l_released_count = l_total_count THEN