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_TRX_INTERFACE dependencies on SO_PICKING_LINE_DETAILS

Line 215: so_picking_line_details_all sopld

211:
212: SELECT SOPLS.PICKING_HEADER_ID, SOPLS.SEQUENCE_NUMBER
213: FROM mtl_serial_numbers s,
214: so_picking_lines_all sopls,
215: so_picking_line_details_all sopld
216: WHERE sopld.picking_line_id = sopls.picking_line_id
217: and sopls.picking_line_ID <> :X_line_id
218: and sopls.inventory_item_id = :X_item_id
219: and nvl( sopls.warehouse_id,:X_warehouse_id ) = :X_warehouse_id

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 408: UPDATE SO_PICKING_LINE_DETAILS pld

404: with null (which means assigned) if any of X_DELIVERY_ID,X_DEPARTURE_ID,
405: pld.Departure_id,pld.Delivery_id is not null. Otherwise populate it with
406: x_dpw_assigned_flag.
407: */
408: UPDATE SO_PICKING_LINE_DETAILS pld
409: SET Last_update_date = sysdate,
410: Last_updated_by = fnd_global.user_id,
411: Last_update_login = fnd_global.user_id,
412: Warehouse_id = nvl(X_warehouse, warehouse_id),

Line 461: wsh_del_oi_core.println('BUT could not update so_picking_line_details.');

457: APP_EXCEPTION.Raise_Exception;
458: END;
459:
460: if sql%notfound then
461: wsh_del_oi_core.println('BUT could not update so_picking_line_details.');
462: error_code := '1';
463: end if;
464:
465: END;

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 534: -- 905046. Inserting pick_slip_number into so_picking_line_details.

530: ' dep:'||to_char(x_departure_id)||
531: ' del:'||to_char(x_delivery_id)||
532: ' container:'||to_char(x_container_id) );
533:
534: -- 905046. Inserting pick_slip_number into so_picking_line_details.
535:
536: INSERT INTO SO_PICKING_LINE_DETAILS(
537: PICKING_LINE_DETAIL_ID
538: , PICK_SLIP_NUMBER

Line 536: INSERT INTO SO_PICKING_LINE_DETAILS(

532: ' container:'||to_char(x_container_id) );
533:
534: -- 905046. Inserting pick_slip_number into so_picking_line_details.
535:
536: INSERT INTO SO_PICKING_LINE_DETAILS(
537: PICKING_LINE_DETAIL_ID
538: , PICK_SLIP_NUMBER
539: , LAST_UPDATE_DATE
540: , LAST_UPDATED_BY

Line 632: FROM SO_PICKING_LINE_DETAILS PLD,

628: x_departure_id,
629: x_delivery_id,
630: x_container_id,
631: NULL
632: FROM SO_PICKING_LINE_DETAILS PLD,
633: MTL_ITEM_LOCATIONS M
634: WHERE PLD.PICKING_LINE_DETAIL_ID = X_Parent_Detail_Id
635: AND m.inventory_location_id (+) = nvl(x_locator_id,pld.inventory_location_id);
636:

Line 681: UPDATE SO_PICKING_LINE_DETAILS pld

677: X_bo := 'TRUE';
678: wsh_del_oi_core.println('Update requested_quantity will NULL out the dep & del in sopld.');
679: END IF;
680: BEGIN
681: UPDATE SO_PICKING_LINE_DETAILS pld
682: SET requested_quantity = requested_quantity - X_shipped_quantity,
683: shipped_quantity = decode(X_bo, 'FALSE' ,NULL,shipped_quantity),
684: delivery_id = decode(X_bo, 'FALSE' ,NULL,delivery_id),
685: departure_id = decode(X_bo, 'FALSE' ,NULL, departure_id),

Line 986: so_picking_line_details SOPLD,

982: DECODE(X_Reservations,'Y',
983: DECODE(sopld.reservable_flag,'Y','Y','N'),'N') RESERVATION_PLACED
984:
985: FROM so_picking_lines_all SOPL,
986: so_picking_line_details SOPLD,
987: wsh_picking_details_interface SOPLDI
988: WHERE sopldi.transaction_id = X_transaction_id
989: and sopldi.picking_line_detail_id = sopld.picking_line_detail_id
990: and sopl.picking_line_id = sopld.picking_line_id

Line 1474: FROM SO_PICKING_LINE_DETAILS

1470: --------------------------------------------------------------------------
1471:
1472: SELECT picking_line_detail_id, shipped_quantity, requested_quantity, delivery_id, container_id
1473: INTO pl_pld_id, pl_shp_qty, pl_req_qty, pl_del, pl_cont
1474: FROM SO_PICKING_LINE_DETAILS
1475: WHERE picking_line_detail_id = oirec.picking_line_detail_id;
1476:
1477: wsh_del_oi_core.println('-----After selection from pld');
1478:

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,

Line 2008: from so_picking_line_details pld,

2004: x_order_header_id := fcrec.order_header_id;
2005:
2006: if x_order_header_id is NOT NULL then
2007: select max(ph.picking_header_id) into x_picking_header_id
2008: from so_picking_line_details pld,
2009: so_picking_lines_all pl,
2010: so_picking_headers_all ph,
2011: so_headers_all h
2012: where pld.delivery_id = x_delivery_id