APPS.WMS_POSTALLOC_PVT dependencies on MTL_TRANSACTION_LOTS_TEMP

Line 4111: INSERT INTO mtl_transaction_lots_temp

4107: END IF;
4108:
4109: -- Bulk insert MTLT records for the parent tasks
4110: FORALL ii IN tbl_transaction_temp_id.FIRST .. tbl_transaction_temp_id.LAST
4111: INSERT INTO mtl_transaction_lots_temp
4112: ( transaction_temp_id
4113: , lot_number
4114: , transaction_quantity
4115: , primary_quantity

Line 4134: FROM mtl_transaction_lots_temp mtlt, mtl_material_transactions_temp mmtt

4130: , g_user_id
4131: , SYSDATE
4132: , g_user_id
4133: , NULL
4134: FROM mtl_transaction_lots_temp mtlt, mtl_material_transactions_temp mmtt
4135: WHERE mtlt.transaction_temp_id = mmtt.transaction_temp_id
4136: AND mmtt.parent_line_id = tbl_transaction_temp_id(ii) -- child task
4137: AND mmtt.transaction_temp_id <> tbl_transaction_temp_id(ii) -- not parent task
4138: AND l_lot_control_code(ii) = 2

Line 4779: DELETE FROM mtl_transaction_lots_temp

4775: wms_task_dispatch_engine.insert_mmtt(l_task_new_rec);
4776:
4777: IF p_mmtt_temp_id = l_parent_line_id THEN --{
4778: -- Delete MTLT records created in task consolidation
4779: DELETE FROM mtl_transaction_lots_temp
4780: WHERE transaction_temp_id = p_mmtt_temp_id;
4781:
4782: l_child_total_qty := 0;
4783: LOOP --{

Line 5858: FROM mtl_transaction_lots_temp mtlt

5854: , 'S'
5855: , t_last_update_date(kk)
5856: , t_last_updated_by(kk)
5857: , t_last_update_login(kk)
5858: FROM mtl_transaction_lots_temp mtlt
5859: WHERE mtlt.transaction_temp_id = t_transaction_temp_id(kk)
5860: AND t_dev_id(kk) IS NOT NULL
5861: AND t_lot_serial_capable_flag(kk) <> 'N'
5862: AND mtlt.serial_transaction_temp_id IS NULL

Line 5923: FROM mtl_transaction_lots_temp mtlt, mtl_serial_numbers_temp msnt

5919: , 'S'
5920: , t_last_update_date(kk)
5921: , t_last_updated_by(kk)
5922: , t_last_update_login(kk)
5923: FROM mtl_transaction_lots_temp mtlt, mtl_serial_numbers_temp msnt
5924: WHERE mtlt.transaction_temp_id = t_transaction_temp_id(kk)
5925: AND mtlt.serial_transaction_temp_id = msnt.transaction_temp_id
5926: AND t_dev_id(kk) IS NOT NULL
5927: AND t_lot_serial_capable_flag(kk) <> 'N' );

Line 6188: FROM mtl_transaction_lots_temp mtlt

6184: , 'S'
6185: , t_last_update_date(nn)
6186: , t_last_updated_by(nn)
6187: , t_last_update_login(nn)
6188: FROM mtl_transaction_lots_temp mtlt
6189: WHERE mtlt.transaction_temp_id = t_transaction_temp_id(nn)
6190: AND t_dev_id(nn) IS NOT NULL
6191: AND t_lot_serial_capable_flag(nn) <> 'N'
6192: AND mtlt.serial_transaction_temp_id IS NULL

Line 6253: FROM mtl_transaction_lots_temp mtlt, mtl_serial_numbers_temp msnt

6249: , 'S'
6250: , t_last_update_date(nn)
6251: , t_last_updated_by(nn)
6252: , t_last_update_login(nn)
6253: FROM mtl_transaction_lots_temp mtlt, mtl_serial_numbers_temp msnt
6254: WHERE mtlt.transaction_temp_id = t_transaction_temp_id(nn)
6255: AND mtlt.serial_transaction_temp_id = msnt.transaction_temp_id
6256: AND t_dev_id(nn) IS NOT NULL
6257: AND t_lot_serial_capable_flag(nn) <> 'N' );