1 Reply Latest reply: Nov 18, 2013 8:37 AM by Neeraj_Shrivastava RSS

    Help with Move Orders please

    979205


      Hello,

      I need a SQL that keeps the history of Move Order includes the move order lines please

      thanks to all the responds

        • 1. Re: Help with Move Orders please
          Neeraj_Shrivastava

          Hi,

           

          mtl_txn_request_headers  Table stores Move Order Header information and mtl_txn_request_lines holds all the line level information.

           

           

              SELECT MTRH.move_order_type 

                    ,MTRH.request_number Move_order_number

                    ,MTRL.*

              FROM   mtl_txn_request_lines   MTRL

                    ,mtl_txn_request_headers MTRH

              WHERE   MTRL.header_id   = MTRH.header_id;

           

          Thanks,

          Neeraj.