APPS.SHP_PICKING_BATCHES_PKG dependencies on SO_PICKING_HEADERS_ALL
Line 659: FROM so_picking_headers_all
655: x_num_open := 0;
656:
657: SELECT count(*)
658: INTO x_num_open 659: FROM so_picking_headers_all 660: WHERE status_code||'' not in ('PENDING','CLOSED','IN PROGRESS')
661: AND batch_id = X_batch_id;
662:
663: IF (x_num_open > 0) THEN