APPS.CSP_PICK_UTILS dependencies on WSH_DELIVERY_DETAILS

Line 2487: wsh_delivery_details wdd

2483: SELECT distinct waybill,
2484: name
2485: FROM wsh_new_deliveries wnd,
2486: wsh_delivery_Assignments wda,
2487: wsh_delivery_details wdd
2488: WHERE wnd.delivery_id = wda.delivery_id
2489: AND wdd.delivery_detail_id = wda.delivery_Detail_id
2490: AND wdd.source_line_id = p_order_line_id
2491: AND wdd.source_code = 'OE';

Line 2600: FROM wsh_delivery_details

2596: l_status := p_flow_status_code;
2597:
2598: SELECT sum(decode(released_status, 'Y', 1, 0)), sum(1)
2599: INTO l_released_count, l_total_count
2600: FROM wsh_delivery_details
2601: WHERE source_line_id = p_order_line_id
2602: AND source_code = 'OE';
2603:
2604: IF l_released_count = l_total_count THEN