DBA Data[Home] [Help]

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