APPS.WSH_SC_TRX_INTERFACE dependencies on SO_PICKING_LINE_DETAILS_S

Line 245: X_Stmt := X_Stmt || ' so_picking_line_details sopld ';

241: X_Stmt := X_Stmt || ' SELECT SOPLS.PICKING_HEADER_ID, ';
242: X_Stmt := X_Stmt || ' SOPLS.SEQUENCE_NUMBER ';
243: X_Stmt := X_Stmt || ' FROM mtl_serial_numbers s, ';
244: X_Stmt := X_Stmt || ' so_picking_lines_all sopls, ';
245: X_Stmt := X_Stmt || ' so_picking_line_details sopld ';
246: X_Stmt := X_Stmt || ' WHERE sopld.picking_line_id = sopls.picking_line_id ';
247: X_Stmt := X_Stmt || ' AND sopld.picking_line_detail_id <> :X_line_detail_id ';
248:
249: if check_item then

Line 519: SELECT SO_PICKING_LINE_DETAILS_S.NEXTVAL into new_pld_id from DUAL;

515: x_att9 in varchar2, x_att10 in varchar2, x_att11 in varchar2, x_att12 in varchar2,
516: x_att13 in varchar2, x_att14 in varchar2, x_att15 in varchar2) is
517: BEGIN
518:
519: SELECT SO_PICKING_LINE_DETAILS_S.NEXTVAL into new_pld_id from DUAL;
520:
521: wsh_del_oi_core.println('creating pld with pld_id:'||to_char(new_pld_id)||
522: 'pick_slip_number:'||to_char(X_pick_slip_number)||
523: ' parent_id:'||to_char(X_parent_detail_id)||

Line 1556: UPDATE SO_PICKING_LINE_DETAILS SET

1552:
1553: BEGIN
1554: wsh_del_oi_core.println('Into reseting pld after reservation split. pld:'||
1555: to_char(new_pld_id) );
1556: UPDATE SO_PICKING_LINE_DETAILS SET
1557: DELIVERY_ID = nvl(DELIVERY_ID,x_delivery_id),
1558: DEPARTURE_ID = nvl(DEPARTURE_ID,x_departure_id),
1559: SERIAL_NUMBER = nvl(SERIAL_NUMBER,oirec.sn),
1560: SHIPPED_QUANTITY = NVL(SHIPPED_QUANTITY,0) + oirec.shipped_quantity,