WMS unpack/pack lpn in MTL_TRANSACTIONS_INTERFACE does not affect delivery?
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
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
0