Need API to remove allocated LPN of Move order
Hi Everyone,
Can anyone please provide API to remove allocated_lpn_id of move order.
We can get records from below query-
SELECT mtrh.header_id,
mtrh.request_number,
mtrh.move_order_type,
mtrh.organization_id,
mtrl.line_id,
mtrl.line_number,
mtrl.inventory_item_id,
mtrl.lot_number,
mtrl.quantity
FROM mtl_txn_request_lines mtrl,
mtl_txn_request_headers mtrh,
mtl_material_transactions_temp mmt
WHERE 1 = 1
AND mtrh.header_id = mtrl.header_id
AND mmt.move_order_line_id = mtrl.line_id
and mmt.ALLOCATED_LPN_ID IS NOT NULL
;
Any help is appreciated.
Thanks,
Suraj