DBA Data[Home] [Help]

APPS.WMS_TASK_DISPATCH_PUT_AWAY dependencies on MTL_SERIAL_NUMBERS_INTERFACE

Line 3012: * Helper routine to create MTL_SERIAL_NUMBERS_INTERFACE records

3008: RETURN FALSE;
3009: END insert_mtli_helper;
3010:
3011: /* FP-J Lot/Serial Support Enhancement
3012: * Helper routine to create MTL_SERIAL_NUMBERS_INTERFACE records
3013: * for the serials corresponding to the dropped quantity
3014: * Called for a receiving LPN when INV and PO patch levels are J or higher
3015: */
3016: FUNCTION insert_msni_helper(

Line 3598: FROM mtl_serial_numbers_interface msni

3594: , n_attribute7
3595: , n_attribute8
3596: , n_attribute9
3597: , n_attribute10
3598: FROM mtl_serial_numbers_interface msni
3599: -- Bug# 3281512 - Performance Fixes
3600: -- Since this cursor is only used for receiving, the product code
3601: -- will always be 'RCV'. This is needed in order to use the index.
3602: WHERE msni.product_code = 'RCV'