Inventory Management - EBS (MOSC)

MOSC Banner

WMS unpack/pack lpn in MTL_TRANSACTIONS_INTERFACE does not affect delivery?

edited Aug 17, 2009 1:49PM in Inventory Management - EBS (MOSC) 1 comment
Hi all,
I tried following the directions in Metalink Note: 357535.1 scenarios 8 and 9.

Unpack:
Insert into inv.mtl_transactions_interface(
transaction_uom,
transaction_date,
source_code,
source_line_id,
source_header_id,
process_flag ,
transaction_mode ,
lock_flag ,
locator_id ,
last_update_date ,
last_updated_by ,
creation_date ,
created_by ,
inventory_item_id ,
subinventory_code,
organization_id,
transaction_quantity ,
primary_quantity ,
transaction_type_id ,
lpn_id
)
VALUES (
'EA', --transaction uom
SYSDATE, --transaction date
'Container UnPack', --source code
3844249, --source line id
2395464, --source header id
1, --process flag
3 , --transaction mode
2 , --lock flag
4633 , --locator id
SYSDATE , --last update date
0, --last updated by
SYSDATE , --creation date

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