Inter Org Inventory Transfer |
This transaction is triggered when Kanban card has been shipped between two sister plants replenishment. This transaction may have source Kanban card information if the transaction is triggered through Ultriva’s pick list feature.
 Note |
|---|
From Parameters (like From Business Unit, From Sub Inventory code, From Location Code) are retrieved from Source Kanban Card object. To Parameters (like To Business Unit, Sub Inventory Code, Location Code) are retrieved from Kanban Card object. |
| Note |
|---|
If the supplying plant is not using Ultriva’s pick list feature then connector derives the source inventory information using following approach: The Workcenter Code is used for subinventory code translation. Source Locator (Location Code) is captured during Ship transaction. |
| Note |
|---|
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 |