Query to get move order details in oracle apps

Query to get move order details in oracle apps

In this post , We will be discuss about Query to get move order details in oracle apps. I will share the two queries for this . If your move order is not transact then you can use the First Query and if the move order Transact then you can use both of these two queries as per your Requirment. This post helps to get Query for move order details in oracle apps

 2 Important Query to get move order details in oracle apps

Ist SQL Query for Move order Details

SELECT
   mtrl.organization_id,
   mtrh.request_number,
   mtrh.header_id,
   mtrl.line_number,
   mtrl.line_id,
  mtrl.subinventory,
   mtrl.inventory_item_id,
   mtrh.description,
   mtrh.move_order_type,
   mtrl.line_status,
   mtrl.quantity,
   mtrl.quantity_delivered,
   mtrl.quantity_detailed
FROM mtl_txn_request_headers mtrh,
  mtl_txn_request_lines mtrl
 WHERE mtrh.header_id = mtrl.header_id
 AND mtrh.organization_id = mtrl.organization_id;

When a move order is allocated, a corresponding record is inserted into the pending table (MTL_MATERIAL_TRANSACTIONS_TEMP as well as lot/serial tables if required).  When the move order is transacted, the record moves from the pending table to the history table (MTL_MATERIAL_TRANSACTIONS).

 Second SQL Query for Move Orders Details

SELECT mmtt.transaction_temp_id,
   mtrl.organization_id,
   mtrh.request_number,
   mtrh.header_id,
   mtrl.line_number,
   mtrl.line_id,
  mtrl.subinventory,
   mtrl.inventory_item_id,
   mtrh.description,
   mtrh.move_order_type,
   mtrl.line_status,
   mtrl.quantity,
   mtrl.quantity_delivered,
   mtrl.quantity_detailed
FROM mtl_txn_request_headers mtrh,
  mtl_txn_request_lines mtrl
   mtl_material_transactions_temp mmtt
WHERE mtrh.header_id = mtrl.header_id
 AND mtrh.organization_id = mtrl.organization_id
 AND mtrl.line_id = mmtt.move_order_line_id