In the ship set process, the user would like to ship group of order lines from same warehouse to same location. If Order Lines are grouped under ship set, then until all lines in the ship set satisfy the demand, you cannot ship the goods to customer.
In the arrival set process, the customer requests
specific order lines to arrive together.
MTL_TXN_REQUEST_HEADERS
Move order headers, this stores the move order number in column
(REQUEST_NUMBER). It has a status, but this is not used as much as the lines
status to drive functionality.
MTL_TXN_REQUEST_LINES
Move order lines, this is the one that drives most queries and status checks
for the move order as each line can be transacted individually.
MTL_MATERIAL_TRANSACTIONS_TEMP
Pending material transactions table also called the transaction temporary
table, this holds allocations that act like reservations on inventory. An
allocation is where you pick a specific item in inventory down to the lot,
locator, serial, revision to move, but you do not actually perform. The move
yet.
Field move_order_header_id and
move_order_line_id provided in this table, which related to
MTL_TXN_REQUEST_HEADERS and
MTL_TXN_REQUEST_LINES.
MTL_MATERIAL_TRANSACTIONS
This is the store of transact move order transactions. And there were some
queries related with it.
For some additional notes:
When a move order is allocated, a
corresponding record is inserted into the pending table
(MTL_MATERIAL_TRANSACTIONS_TEMP as well as lot/serial tables if required).
When the move order is transacted, the
record moves from the pending table to the history table
(MTL_MATERIAL_TRANSACTIONS).
If both purchased and purchasable attribute are enabled, we can create new purchasing documents and approve and receive the items.
If purchased is enabled and purchasable
is disabled, we cannot create purchasing documents and approve but we can
receive the item against approved purchasing documents.
We can enable purchasable only when
purchased is enabled.
