APPS.WSH_SC_TRX_INTERFACE dependencies on WSH_PICKING_DETAILS_INTERFACE

Line 58: wsh_picking_details_interface dtl

54:
55: CURSOR DUP_CHECK is
56: SELECT del.transaction_id
57: FROM wsh_deliveries_interface del,
58: wsh_picking_details_interface dtl
59: WHERE nvl( dtl.shipped_quantity, 0 ) <> 0
60: AND dtl.rowid <> chartorowid(x_rowid)
61: AND del.transaction_id = dtl.transaction_id
62: AND del.process_flag = 1

Line 987: wsh_picking_details_interface SOPLDI

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
991: ORDER BY sopl.inventory_item_id;

Line 1679: DELETE from wsh_picking_details_interface

1675: <>
1676:
1677: error_code := '0';
1678:
1679: DELETE from wsh_picking_details_interface
1680: WHERE picking_line_detail_id = oirec.picking_line_detail_id and rowid = oirec.row_id;
1681:
1682: COMMIT;
1683: