DBA Data[Home] [Help]

APPS.PJM_MASS_TRANSFER_PUB dependencies on MTL_SERIAL_NUMBERS

Line 297: INSERT INTO mtl_serial_numbers_interface

293: END IF;
294:
295: PJM_DEBUG.Debug('Creating Transaction Serial Information');
296:
297: INSERT INTO mtl_serial_numbers_interface
298: ( transaction_interface_id
299: , source_code
300: , source_line_id
301: , last_update_date

Line 320: , mtl_serial_numbers msn

316: , mti.last_update_login
317: , msn.serial_number
318: , msn.serial_number
319: FROM mtl_transactions_interface mti
320: , mtl_serial_numbers msn
321: WHERE mti.transaction_interface_id = txn_xface_id
322: AND msn.inventory_item_id = mti.inventory_item_id
323: AND msn.current_organization_id = mti.organization_id
324: AND msn.current_subinventory_code = mti.subinventory_code