Inventory Management - EBS (MOSC)

MOSC Banner

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,

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center