DBA Data[Home] [Help]

APPS.WSH_UPGRADE_PICK_SLIP_DATA_NEW dependencies on SO_PICKING_LINES_ALL

Line 208: FROM SO_PICKING_LINES_ALL

204: WHERE HEADER_ID = x_header_id;
205:
206: CURSOR count_shipped_pls (x_header_id IN BINARY_INTEGER) IS
207: SELECT count(*)
208: FROM SO_PICKING_LINES_ALL
209: WHERE picking_header_id = x_header_id
210: AND nvl(shipped_quantity,0) > 0;
211:
212: p_order_header_id BINARY_INTEGER;

Line 685: so_picking_lines_all pl

681: WHERE picking_line_detail_id IN
682: ( SELECT pld.picking_line_detail_id
683: FROM
684: so_picking_line_details pld,
685: so_picking_lines_all pl
686: WHERE pl.picking_header_id = u_picking_header_id
687: AND pld.picking_line_id = pl.picking_line_id );
688: END IF;
689: