Move Order/Transfer Order tables in Oracle Fusion

 Move Order/Transfer Order table in Oracle Fusion

Hi friends , we are going to discuss about the Move Order/Transfer Order table in Oracle Fusion. We will share al the important Move order tables which store the complete move order details in oracle fusion. Move order and Transfer order both are the same. If we want to develop the Move order report in oracle fusion , then these more order tables tables we do use. In this post , we will share all the important tables including other inventory tables too which helps to develop the complete move order transfer report in oracle fusion. Please find below the complete details about Move Order/Transfer Order table in Oracle Fusion.

5 Important tables  of Move Order/Transfer Order table in Oracle Fusion

1.INV_TRANSFER_ORDER_HEADERS 

2.INV_TRANSFER_ORDER_LINES 

3.INV_TRANSFER_ORDER_DISTRIBS 

4.egp_system_items_vl  

5.inv_units_of_measure_vl 

Detail sql Query to extract the Move order data in Oracle Fusion

Here below we are sharing the important move order/transfer order sql query which helps to extract the complete move order data in oracle fusion.

SELECT DISTINCT

ITH.HEADER_NUMBER,

ITL.SUPPLY_ORDER_REFERENCE_NUMBER,

ITL.LINE_NUMBER,

ESI.ITEM_NUMBER,

ESI.DESCRIPTION,

UOM.UNIT_OF_MEASURE,

ITL.SHIPPED_QTY,

ITL.UNIT_PRICE,

ITL.SHIPPED_QTY * ITL.UNIT_PRICE AS Amount,

ITL.STATUS_LOOKUP

from

INV_TRANSFER_ORDER_HEADERS ITH ,

INV_TRANSFER_ORDER_LINES ITL ,

INV_TRANSFER_ORDER_DISTRIBS ITD,

egp_system_items_vl  ESI,

inv_units_of_measure_vl UOM

where

ITH.HEADER_ID = ITL.HEADER_ID

----AND  ITH.HEADER_NUMBER = '1003223'

AND  ITL.INVENTORY_ITEM_ID = ESI.INVENTORY_ITEM_ID

AND QTY_UOM_CODE=UOM.UOM_CODE

AND ITD.LINE_ID=ITL.LINE_ID

AND ESI.ORGANIZATION_CODE =:P_ORG

and ITL.STATUS_LOOKUP = 'CLOSED'

order by ITH.HEADER_NUMBER,ITL.LINE_NUMBER