INV Move Order Upload – Oracle EBS SQL Report

Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.

Overview

Creates and updates move order requisitions with their lines, approves them, and cancels or closes move order lines, as the Move Orders window (Inventory > Move Orders > Move Orders).

Each row carries the move order header and one line. Rows with the same Move Order belong to one move order; leave Move Order blank on new rows to have the number generated, rows with a blank number and the same header values then form one move order.

Approve submits the move order for approval as the Approve button of the form: it is approved immediately unless the organization’s move order approval timeout requires the approval workflow. Allocating and transacting the approved lines is done in the Transact Move Orders window.

Run this report in Excel in seconds: download Blitz Report™ free (your first 30 reports are free) or try it in the online demo.

Report Parameters

Upload Mode, Organization Code, Move Order, Header Status, Item

Oracle EBS Tables Used

mtl_transaction_types, mtl_item_locations_kfv, gl_code_combinations_kfv, hr_locations_all, mtl_transaction_reasons, mtl_txn_request_headers, mtl_txn_request_lines, mtl_parameters, mtl_system_items_vl, org_access_view

Report Categories

Enginatics, R12 only, Upload

Running This SQL Without Blitz Report

The SQL source can be run in any SQL client. Some Oracle EBS SQL reports in this library use functions from the utility package xxen_util – install it first. Blitz Report™ adds parameters, Excel output with pivots, scheduling and security on top.

Download & Import Options

Resource Link
Excel Example Output Example
Blitz Report™ XML Import INV_Move_Order_Upload.xml
SQL Source INV Move Order Upload.sql
Full Report on Enginatics www.enginatics.com/reports/inv-move-order-upload/

© Enginatics GmbH