DBA Data[Home] [Help]

APPS.WMS_TASK_DISPATCH_PUT_AWAY dependencies on MTL_TRANSACTION_LOTS_INTERFACE

Line 2920: * Helper routine to create MTL_TRANSACTION_LOTS_INTERFACE records

2916: RETURN FALSE;
2917: END insert_dup_msnt;
2918:
2919: /* FP-J Lot/Serial Support Enhancement
2920: * Helper routine to create MTL_TRANSACTION_LOTS_INTERFACE records
2921: * for the lot and quantity corresponding to the drop quantity
2922: * Called for a receiving LPN when INV and PO patch levels are J or higher
2923: */
2924: FUNCTION insert_mtli_helper(

Line 4652: FROM mtl_transaction_lots_interface

4648: IF (l_is_crossdocked) THEN
4649: IF (l_lot_code > 1) THEN
4650: SELECT serial_transaction_temp_id
4651: INTO l_msnt_temp_id
4652: FROM mtl_transaction_lots_interface
4653: WHERE lot_number = p_lot
4654: AND product_transaction_id = l_product_transaction_id;
4655: ELSE
4656: l_msnt_temp_id := p_temp_id;