Intra Org (Sub Inventory) Inventory Transfer |
This transaction is triggered when Kanban card has been shipped for internal replenishment. This transaction has both source Kanban card and destination Kanban card information. This is achieved through Ultriva’s Pick List functionality.
 Note |
|---|
From Parameters (like From Sub Inventory code, From Location Code) are retrieved from Source Kanban Card object. To Parameters (like Sub Inventory Code, Location Code) are retrieved from Kanban Card object. |
| Note |
|---|
The Oracle interface table for this transaction is MTL_TRANSACTIONS_INTERFACE. |
The following table(s) illustrate(s) the data mapping between Ultriva and Oracle.
ULTRIVA field | Oracle Lookup | Lookup Field | Field/Value | Oracle Field |
|---|---|---|---|---|
NA | NA | NA | mtl_material_transactions_s.NEXTVAL | TRANSACTION_INTERFACE_ID |
UNIT_OF_MEASURE | mtl_units_of_measure | UOM_CODE = TRIM(p_unit_of_measure) OR unit_of_measure = TRIM(p_unit_of_measure) | .unit_of_measure | TRANSACTION_UOM |
ACTION_DATE | NA | NA | NA | TRANSACTION_DATE |
NA | NA | NA | 'UEKXFER' | SOURCE_CODE |
NA | NA | NA | -1 | SOURCE_LINE_ID |
NA | NA | NA | -1 | SOURCE_HEADER_ID |
NA | NA | NA | 1 | PROCESS_FLAG |
NA | NA | NA | 3 | TRANSACTION_MODE |
NA | NA | NA | 2 | LOCK_FLAG |
FROM_LOCATION_CODE | mtl_item_locations_kfv | organization_id = p_ship_to_org_id AND subinventory_code = p_subinventory AND nvl(disable_date,sysdate+1) > sysdate AND concatenated_segments = p_locator | inventory_location_id | LOCATOR_ID |
NA | NA | NA | SYSDATE | LAST_UPDATE_DATE |
TRANSACTION_BY | fnd_user | upper(user_name) = upper(TRANSACTION_BY) | user_id | LAST_UPDATED_BY |
NA | NA | NA | SYSDATE | CREATION_DATE |
TRANSACTION_BY | fnd_user | upper(user_name) = upper(TRANSACTION_BY) | user_id | CREATED_BY |
ITEM_NUM | mtl_system_items_kfv | concatenated_segments = TRIM(p_item_num) AND organization_id = p_ship_to_organization_id | NA | INVENTORY_ITEM_ID |
FROM_SUBINVENTORY | NA | NA | NA | SUBINVENTORY_CODE |
FROM_BUSINESS_CODE | NA | NA | NA | ORGANIZATION_ID |
Quantity | NA | NA | NA | TRANSACTION_QUANTITY |
Quantity | NA | NA | NA | PRIMARY_QUANTITY |
SUB INVENTORY | mtl_transaction_types | UPPER(transaction_type_name) = UPPER(p_transaction_type_name) | transaction_type_id | TRANSACTION_TYPE_ID |
TO_SUBINVENTORY | NA | NA | NA | TRANSFER_SUBINVENTORY |
TO_LOCATION_CODE | mtl_item_locations_kfv | organization_id = p_ship_to_org_id AND subinventory_code = p_subinventory AND nvl(disable_date,sysdate+1) > sysdate AND concatenated_segments = p_locator | inventory_location_id | TRANSFER_LOCATOR |
Ultriva Staging Table's Primary Key field | NA | NA | NA | ATTRIBUTE1 |
DESTINATION_KANBAN_RELEASE_ID | NA | NA | NA | ATTRIBUTE2 |
SOURCE_KANBAN_RELEASE_ID | NA | NA | NA | ATTRIBUTE3 |
ITEM_REVISION | NA | NA | NA | REVISION |
DESTINATION_KANBAN_RELEASE_ID | NA | NA | NA | TRANSACTION_REFERENCE |
Ultriva Staging Table's Primary Key field | NA | NA | NA | SHIPMENT_NUMBER |