eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WSH_SC_DELIVERY_PVT dependencies on SO_PICKING_LINE_DETAILS

Line 206: -- make departure id in so_picking_line_details in correct

202: SET waybill_num = x_waybill
203: WHERE delivery_id = del_id;
204: END IF;
205:
206: -- make departure id in so_picking_line_details in correct
207: UPDATE so_picking_line_details
208: SET departure_id = dep_id
209: WHERE delivery_id = del_id;
210:

Line 207: UPDATE so_picking_line_details

203: WHERE delivery_id = del_id;
204: END IF;
205:
206: -- make departure id in so_picking_line_details in correct
207: UPDATE so_picking_line_details
208: SET departure_id = dep_id
209: WHERE delivery_id = del_id;
210:
211: -- clear any serial number entered in MTL_SERIAL_NUMBERS_TEMP

Line 323: -- update shipped quantity in so_picking_line_details

319: dep_id NUMBER;
320: return_msg1 varchar2(2000);
321: BEGIN
322:
323: -- update shipped quantity in so_picking_line_details
324: wsh_sc_del_lines.update_shp_qty (del_id, 'BACKORDER_ALL');
325:
326: -- clear any charges entered in SO_FREIGHT_CHARGES
327: delete from so_freight_charges

Line 340: UPDATE so_picking_line_details

336: IF ( c1%ISOPEN) THEN
337: CLOSE c1;
338: END IF;
339:
340: UPDATE so_picking_line_details
341: SET departure_id = dep_id,
342: container_id = NULL,
343: shipped_quantity = 0
344: WHERE delivery_id = del_id;

Line 362: FROM so_picking_lines_all pl, so_picking_line_details pld

358: UPDATE so_picking_headers_all
359: SET status_code = 'PENDING'
360: WHERE picking_header_id in
361: (SELECT distinct pl.picking_header_id
362: FROM so_picking_lines_all pl, so_picking_line_details pld
363: WHERE pld.delivery_id = del_id
364: AND pl.picking_line_id = pld.picking_line_id
365: AND pl.picking_header_id+0 > 0);
366:

Line 409: UPDATE so_picking_line_details

405:
406: --We need to take out the containers off the Delivery Lines and set the Shipped
407: --quantity to null on them.
408:
409: UPDATE so_picking_line_details
410: SET container_id = null
411: WHERE delivery_id = Del_Id;
412:
413: --Now look at the souce code of the delivery ie who created it - DPW or SC

Line 759: FROM so_picking_lines_all pl, so_picking_line_details pld

755:
756: --declare the picking header cursor
757: CURSOR c1(del_id NUMBER) IS
758: SELECT distinct pl.picking_header_id picking_header_id
759: FROM so_picking_lines_all pl, so_picking_line_details pld
760: WHERE pld.delivery_id = del_id
761: AND pld.picking_line_id = pl.picking_line_id
762: AND pl.picking_header_id > 0;
763:

Line 788: FROM so_picking_line_details pld, so_picking_lines_all pl

784: WHERE picking_header_id = ph_id;
785:
786: SELECT COUNT(*)
787: into num_found
788: FROM so_picking_line_details pld, so_picking_lines_all pl
789: WHERE pl.picking_header_id = ph_id
790: AND pl.picking_line_id = pld.picking_line_id
791: AND ( pld.delivery_id <> del_id OR
792: pld.delivery_id IS NULL ) ;

Line 817: FROM so_picking_line_details

813: -- begin picking line loop
814:
815: SELECT COUNT(*)
816: INTO num_found
817: FROM so_picking_line_details
818: WHERE picking_line_id = pl_id
819: AND ( delivery_id <> del_id OR
820: delivery_id IS NULL ) ;
821:

Line 826: FROM so_picking_line_details

822: IF num_found > 0 then -- outer if condition
823:
824: SELECT COUNT(*)
825: INTO num_found
826: FROM so_picking_line_details
827: WHERE picking_line_id = pl_id
828: AND delivery_id = del_id;
829:
830: IF num_found > 0 then -- inner if condition

Line 844: UPDATE so_picking_line_details

840:
841: insert_pl_row (pl_id, new_pl_id, new_ph_id);
842:
843:
844: UPDATE so_picking_line_details
845: SET picking_line_id = new_pl_id
846: WHERE picking_line_id = pl_id
847: AND delivery_id = del_id;
848:

Line 852: FROM so_picking_line_details

848:
849: -- now update the shipped and requested quantities on this new picking line
850: SELECT sum(nvl(shipped_quantity,0)), sum(nvl(requested_quantity,0))
851: INTO shp_qty, req_qty
852: FROM so_picking_line_details
853: WHERE picking_line_id = new_pl_id
854: GROUP BY picking_line_id;
855:
856: UPDATE so_picking_lines_all

Line 865: FROM so_picking_line_details

861:
862: -- also update the shipped and requested quantities on the old picking line
863: SELECT sum(nvl(shipped_quantity,0)), sum(nvl(requested_quantity,0))
864: INTO shp_qty, req_qty
865: FROM so_picking_line_details
866: WHERE picking_line_id = pl_id
867: GROUP BY picking_line_id;
868:
869: UPDATE so_picking_lines_all

Line 1092: SELECT container_id FROM so_picking_line_details

1088: FUNCTION Delete_Container_Contents( x_container_id IN NUMBER)
1089: RETURN BOOLEAN IS
1090:
1091: CURSOR c1( x_cid NUMBER) IS
1092: SELECT container_id FROM so_picking_line_details
1093: WHERE container_id = x_cid
1094: FOR UPDATE OF picking_line_detail_id NOWAIT;
1095: dummy_id NUMBER;
1096: record_locked EXCEPTION;

Line 1104: UPDATE so_picking_line_details

1100: OPEN c1(x_container_id);
1101: FETCH c1 INTO dummy_id;
1102: CLOSE c1;
1103:
1104: UPDATE so_picking_line_details
1105: SET container_id = NULL
1106: WHERE container_id = x_container_id;
1107:
1108: RETURN TRUE;