DBA Data[Home] [Help]

APPS.RCV_WSH_INTERFACE_PKG dependencies on MTL_SERIAL_NUMBERS_INTERFACE

Line 2393: INSERT INTO mtl_serial_numbers_interface

2389: AND length(serial_number) = length(wsn_rec.fm_serial_number); -- Bug 10120533
2390: END IF;
2391:
2392: -- This will be changed to pick from WSN once shipping patch is ready.
2393: INSERT INTO mtl_serial_numbers_interface
2394: ( transaction_interface_id,
2395: product_code,
2396: product_transaction_id,
2397: last_update_date,

Line 2911: DELETE FROM mtl_serial_numbers_interface

2907: BEGIN
2908:
2909: -- Deleting errored RTI/MSNI/MTLI
2910: BEGIN
2911: DELETE FROM mtl_serial_numbers_interface
2912: WHERE product_transaction_id IN
2913: (SELECT interface_transaction_id
2914: FROM rcv_transactions_interface
2915: WHERE group_id = p_group_id