APPS.WSH_SC_TRX_INTERFACE dependencies on SO_PICKING_LINES_ALL

Line 214: so_picking_lines_all sopls,

210: /*** for debugging this is the statement so far
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

Line 244: X_Stmt := X_Stmt || ' so_picking_lines_all sopls, ';

240: if X_SERIAL_NUMBER_CONTROL_CODE in ('Y','D') then
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:

Line 985: FROM so_picking_lines_all SOPL,

981:
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

Line 2009: so_picking_lines_all pl,

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
2013: and pld.picking_line_id = pl.picking_line_id