Adding location column in move order
Hello,
Adding location column to move order, exact name of the table to map the column from below query.
SELECT
mat.transaction_type_id,
-- mat.transaction_source_id,
TO_DATE(mat.transaction_date,'DD-MON-RRRR') trx_date,
mat.created_by,
mtxh.created_by requested,
mat.creation_date,
mat.transaction_set_id,
mat.transaction_source_id,
mat.transaction_id,
mat.inventory_item_id,
mat.transaction_quantity*-1 qty,
mat.transaction_uom uom,
mat.transaction_cost,
mat.actual_cost,
mat.organization_id,
mat.subinventory_code,
mat.locator_id,
mat.transfer_transaction_id,
mat.transfer_organization_id,
mat.transfer_subinventory,
mat.transfer_locator_id,