Inventory Items (APC/PLM/PIM) - EBS (MOSC)

MOSC Banner

Need API to remove allocated LPN of Move order

edited Apr 2, 2015 10:00AM in Inventory Items (APC/PLM/PIM) - EBS (MOSC) 1 commentAnswered

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center