Product: | INV - Inventory |
---|---|
Description: | Subinventory definitions |
Implementation/DBA Data: |
![]() |
Table | |
Foreign Table | Foreign Key Column |
---|---|---|---|
MTL_SECONDARY_INVENTORIES | ![]() |
![]() |
MTL_SECONDARY_INVENTORIES.MATERIAL_ACCOUNT |
MTL_SECONDARY_INVENTORIES | ![]() |
![]() |
MTL_SECONDARY_INVENTORIES.NOTIFY_LIST_ID |
MTL_SECONDARY_INVENTORIES | ![]() |
![]() |
MTL_SECONDARY_INVENTORIES.SOURCE_ORGANIZATION_ID |
MTL_SECONDARY_INVENTORIES | ![]() |
![]() |
MTL_SECONDARY_INVENTORIES.SOURCE_SUBINVENTORY
MTL_SECONDARY_INVENTORIES.SOURCE_ORGANIZATION_ID |
MTL_SECONDARY_INVENTORIES | ![]() |
![]() |
MTL_SECONDARY_INVENTORIES.ENCUMBRANCE_ACCOUNT |
MTL_SECONDARY_INVENTORIES | ![]() |
![]() |
MTL_SECONDARY_INVENTORIES.STATUS_ID |
MTL_SECONDARY_INVENTORIES | ![]() |
![]() |
MTL_SECONDARY_INVENTORIES.DEFAULT_COST_GROUP_ID |
MTL_SECONDARY_INVENTORIES | ![]() |
![]() |
MTL_SECONDARY_INVENTORIES.RESOURCE_ACCOUNT |
MTL_SECONDARY_INVENTORIES | ![]() |
![]() |
MTL_SECONDARY_INVENTORIES.MATERIAL_OVERHEAD_ACCOUNT |
MTL_SECONDARY_INVENTORIES | ![]() |
![]() |
MTL_SECONDARY_INVENTORIES.OVERHEAD_ACCOUNT |
MTL_SECONDARY_INVENTORIES | ![]() |
![]() |
MTL_SECONDARY_INVENTORIES.OUTSIDE_PROCESSING_ACCOUNT |
MTL_SECONDARY_INVENTORIES | ![]() |
![]() |
MTL_SECONDARY_INVENTORIES.EXPENSE_ACCOUNT |
MTL_SECONDARY_INVENTORIES | ![]() |
![]() |
MTL_SECONDARY_INVENTORIES.ORGANIZATION_ID |
![]() |
![]() |
MTL_SECONDARY_INVENTORIES |
AHL_WORKORDER_MTL_TXNS.SUBINVENTORY_CODE
AHL_WORKORDER_MTL_TXNS.ORGANIZATION_ID |
![]() |
![]() |
MTL_SECONDARY_INVENTORIES |
BOM_OPERATIONAL_ROUTINGS.COMPLETION_SUBINVENTORY
BOM_OPERATIONAL_ROUTINGS.ORGANIZATION_ID |
![]() |
![]() |
MTL_SECONDARY_INVENTORIES |
CSP_CURR_SUP_DEM_SUMS.SUBINVENTORY_CODE
CSP_CURR_SUP_DEM_SUMS.ORGANIZATION_ID |
![]() |
![]() |
MTL_SECONDARY_INVENTORIES |
CSP_EXCESS_LISTS.SUBINVENTORY_CODE
CSP_EXCESS_LISTS.ORGANIZATION_ID |
![]() |
![]() |
MTL_SECONDARY_INVENTORIES |
CSP_INV_LOC_ASSIGNMENTS.SUBINVENTORY_CODE
CSP_INV_LOC_ASSIGNMENTS.ORGANIZATION_ID |
![]() |
![]() |
MTL_SECONDARY_INVENTORIES |
CSP_PACKLIST_HEADERS.SUBINVENTORY_CODE
CSP_PACKLIST_HEADERS.ORGANIZATION_ID |
![]() |
![]() |
MTL_SECONDARY_INVENTORIES |
CSP_PLANNING_PARAMETERS.SECONDARY_INVENTORY
CSP_PLANNING_PARAMETERS.ORGANIZATION_ID |
![]() |
![]() |
MTL_SECONDARY_INVENTORIES |
CSP_REQUIREMENT_LINES.SOURCE_SUBINVENTORY
CSP_REQUIREMENT_LINES.SOURCE_ORGANIZATION_ID |
![]() |
![]() |
MTL_SECONDARY_INVENTORIES |
CSP_SEC_INVENTORIES.SECONDARY_INVENTORY_NAME
CSP_SEC_INVENTORIES.ORGANIZATION_ID |
![]() |
![]() |
MTL_SECONDARY_INVENTORIES |
CSP_SUPPLY_CHAIN.SECONDARY_INVENTORY
CSP_SUPPLY_CHAIN.ORGANIZATION_ID |
![]() |
![]() |
MTL_SECONDARY_INVENTORIES |
CSP_USAGE_HEADERS.SECONDARY_INVENTORY
CSP_USAGE_HEADERS.ORGANIZATION_ID |
![]() |
![]() |
MTL_SECONDARY_INVENTORIES |
CSP_USAGE_HISTORIES.SUBINVENTORY_CODE
CSP_USAGE_HISTORIES.ORGANIZATION_ID |
![]() |
![]() |
MTL_SECONDARY_INVENTORIES |
FLM_KANBAN_SUMMARY.SUBINVENTORY_NAME
FLM_KANBAN_SUMMARY.SOURCE_ORGANIZATION_ID |
![]() |
![]() |
MTL_SECONDARY_INVENTORIES |
JA_AU_SUBINV_LOC_ASSOCS.SUBINVENTORY_NAME
JA_AU_SUBINV_LOC_ASSOCS.ORGANIZATION_ID |
![]() |
![]() |
MTL_SECONDARY_INVENTORIES |
MRP_SUB_INVENTORIES.SUB_INVENTORY_CODE
MRP_SUB_INVENTORIES.ORGANIZATION_ID |
![]() |
![]() |
MTL_SECONDARY_INVENTORIES |
MTL_ABC_ASSIGNMENT_GROUPS.SECONDARY_INVENTORY
MTL_ABC_ASSIGNMENT_GROUPS.ORGANIZATION_ID |
![]() |
![]() |
MTL_SECONDARY_INVENTORIES |
MTL_ABC_COMPILES.SECONDARY_INVENTORY
MTL_ABC_COMPILES.ORGANIZATION_ID |
![]() |
![]() |
MTL_SECONDARY_INVENTORIES |
MTL_ABC_COMPILE_HEADERS.SECONDARY_INVENTORY
MTL_ABC_COMPILE_HEADERS.ORGANIZATION_ID |
![]() |
![]() |
MTL_SECONDARY_INVENTORIES |
MTL_CC_ENTRIES_INTERFACE.SUBINVENTORY
MTL_CC_ENTRIES_INTERFACE.ORGANIZATION_ID |
![]() |
![]() |
MTL_SECONDARY_INVENTORIES |
MTL_CYCLE_COUNT_ENTRIES.SUBINVENTORY
MTL_CYCLE_COUNT_ENTRIES.ORGANIZATION_ID |
![]() |
![]() |
MTL_SECONDARY_INVENTORIES |
MTL_DEMAND.SUBINVENTORY
MTL_DEMAND.ORGANIZATION_ID |
![]() |
![]() |
MTL_SECONDARY_INVENTORIES |
MTL_DEMAND_INTERFACE.SUBINVENTORY
MTL_DEMAND_INTERFACE.ORGANIZATION_ID |
![]() |
![]() |
MTL_SECONDARY_INVENTORIES |
MTL_ITEM_LOCATIONS.SUBINVENTORY_CODE
MTL_ITEM_LOCATIONS.ORGANIZATION_ID |
![]() |
![]() |
MTL_SECONDARY_INVENTORIES |
MTL_ITEM_LOC_DEFAULTS.SUBINVENTORY_CODE
MTL_ITEM_LOC_DEFAULTS.ORGANIZATION_ID |
![]() |
![]() |
MTL_SECONDARY_INVENTORIES |
MTL_ITEM_SUB_DEFAULTS.SUBINVENTORY_CODE
MTL_ITEM_SUB_DEFAULTS.ORGANIZATION_ID |
![]() |
![]() |
MTL_SECONDARY_INVENTORIES |
MTL_ITEM_SUB_INVENTORIES.SECONDARY_INVENTORY
MTL_ITEM_SUB_INVENTORIES.ORGANIZATION_ID |
![]() |
![]() |
MTL_SECONDARY_INVENTORIES |
MTL_ITEM_SUB_INVENTORIES.SOURCE_SUBINVENTORY
MTL_ITEM_SUB_INVENTORIES.SOURCE_ORGANIZATION_ID |
![]() |
![]() |
MTL_SECONDARY_INVENTORIES |
MTL_KANBAN_CARDS.SUBINVENTORY_NAME
MTL_KANBAN_CARDS.ORGANIZATION_ID |
![]() |
![]() |
MTL_SECONDARY_INVENTORIES |
MTL_KANBAN_CARDS.SOURCE_SUBINVENTORY
MTL_KANBAN_CARDS.SOURCE_ORGANIZATION_ID |
![]() |
![]() |
MTL_SECONDARY_INVENTORIES |
MTL_KANBAN_CARD_ACTIVITY.SUBINVENTORY_NAME
MTL_KANBAN_CARD_ACTIVITY.ORGANIZATION_ID |
![]() |
![]() |
MTL_SECONDARY_INVENTORIES |
MTL_KANBAN_CARD_ACTIVITY.SOURCE_SUBINVENTORY
MTL_KANBAN_CARD_ACTIVITY.SOURCE_ORGANIZATION_ID |
![]() |
![]() |
MTL_SECONDARY_INVENTORIES |
MTL_KANBAN_PULL_SEQUENCES.SUBINVENTORY_NAME
MTL_KANBAN_PULL_SEQUENCES.ORGANIZATION_ID |
![]() |
![]() |
MTL_SECONDARY_INVENTORIES |
MTL_KANBAN_PULL_SEQUENCES.SOURCE_SUBINVENTORY
MTL_KANBAN_PULL_SEQUENCES.SOURCE_ORGANIZATION_ID |
![]() |
![]() |
MTL_SECONDARY_INVENTORIES |
MTL_MATERIAL_STATUS_HISTORY.ZONE_CODE
MTL_MATERIAL_STATUS_HISTORY.ORGANIZATION_ID |
![]() |
![]() |
MTL_SECONDARY_INVENTORIES |
MTL_MATERIAL_TRANSACTIONS.SUBINVENTORY_CODE
MTL_MATERIAL_TRANSACTIONS.ORGANIZATION_ID |
![]() |
![]() |
MTL_SECONDARY_INVENTORIES |
MTL_MATERIAL_TRANSACTIONS_TEMP.TRANSFER_SUBINVENTORY
MTL_MATERIAL_TRANSACTIONS_TEMP.TRANSFER_ORGANIZATION |
![]() |
![]() |
MTL_SECONDARY_INVENTORIES |
MTL_MATERIAL_TRANSACTIONS_TEMP.SUBINVENTORY_CODE
MTL_MATERIAL_TRANSACTIONS_TEMP.ORGANIZATION_ID |
![]() |
![]() |
MTL_SECONDARY_INVENTORIES |
MTL_ONHAND_QUANTITIES.SUBINVENTORY_CODE
MTL_ONHAND_QUANTITIES.ORGANIZATION_ID |
![]() |
![]() |
MTL_SECONDARY_INVENTORIES |
MTL_ONHAND_QUANTITY_TEMP.SUBINVENTORY
MTL_ONHAND_QUANTITY_TEMP.ORGANIZATION_ID |
![]() |
![]() |
MTL_SECONDARY_INVENTORIES |
MTL_PARAMETERS.SOURCE_SUBINVENTORY
MTL_PARAMETERS.SOURCE_ORGANIZATION_ID |
![]() |
![]() |
MTL_SECONDARY_INVENTORIES |
MTL_PERIOD_SUMMARY.SECONDARY_INVENTORY
MTL_PERIOD_SUMMARY.ORGANIZATION_ID |
![]() |
![]() |
MTL_SECONDARY_INVENTORIES |
MTL_PHYSICAL_ADJUSTMENTS.SUBINVENTORY_NAME
MTL_PHYSICAL_ADJUSTMENTS.ORGANIZATION_ID |
![]() |
![]() |
MTL_SECONDARY_INVENTORIES |
MTL_PHYSICAL_INVENTORY_TAGS.SUBINVENTORY
MTL_PHYSICAL_INVENTORY_TAGS.ORGANIZATION_ID |
![]() |
![]() |
MTL_SECONDARY_INVENTORIES |
MTL_PHYSICAL_SUBINVENTORIES.SUBINVENTORY
MTL_PHYSICAL_SUBINVENTORIES.ORGANIZATION_ID |
![]() |
![]() |
MTL_SECONDARY_INVENTORIES |
MTL_REPLENISH_HEADERS.SUBINVENTORY_CODE
MTL_REPLENISH_HEADERS.ORGANIZATION_ID |
![]() |
![]() |
MTL_SECONDARY_INVENTORIES |
MTL_REPLENISH_HEADERS_INT.SUBINVENTORY_CODE
MTL_REPLENISH_HEADERS_INT.ORGANIZATION_ID |
![]() |
![]() |
MTL_SECONDARY_INVENTORIES |
MTL_REPLENISH_LINES.SOURCE_SUBINVENTORY
MTL_REPLENISH_LINES.ORGANIZATION_ID |
![]() |
![]() |
MTL_SECONDARY_INVENTORIES |
MTL_RESERVATIONS.SUBINVENTORY_CODE
MTL_RESERVATIONS.ORGANIZATION_ID |
![]() |
![]() |
MTL_SECONDARY_INVENTORIES |
MTL_RESERVATIONS_INTERFACE.SUBINVENTORY_CODE
MTL_RESERVATIONS_INTERFACE.ORGANIZATION_ID |
![]() |
![]() |
MTL_SECONDARY_INVENTORIES |
MTL_RESERVATIONS_INTERFACE.TO_SUBINVENTORY_CODE
MTL_RESERVATIONS_INTERFACE.ORGANIZATION_ID |
![]() |
![]() |
MTL_SECONDARY_INVENTORIES |
MTL_SECONDARY_INVENTORIES.SOURCE_SUBINVENTORY
MTL_SECONDARY_INVENTORIES.SOURCE_ORGANIZATION_ID |
![]() |
![]() |
MTL_SECONDARY_INVENTORIES |
MTL_SERIAL_NUMBERS.CURRENT_SUBINVENTORY_CODE
MTL_SERIAL_NUMBERS.CURRENT_ORGANIZATION_ID |
![]() |
![]() |
MTL_SECONDARY_INVENTORIES |
MTL_SUPPLY.FROM_SUBINVENTORY
MTL_SUPPLY.FROM_ORGANIZATION_ID |
![]() |
![]() |
MTL_SECONDARY_INVENTORIES |
MTL_SUPPLY.TO_SUBINVENTORY
MTL_SUPPLY.TO_ORGANIZATION_ID |
![]() |
![]() |
MTL_SECONDARY_INVENTORIES |
MTL_SUPPLY.MRP_TO_SUBINVENTORY
MTL_SUPPLY.MRP_TO_ORGANIZATION_ID |
![]() |
![]() |
MTL_SECONDARY_INVENTORIES |
MTL_SYSTEM_ITEMS_B.SOURCE_SUBINVENTORY
MTL_SYSTEM_ITEMS_B.SOURCE_ORGANIZATION_ID |
![]() |
![]() |
MTL_SECONDARY_INVENTORIES |
MTL_SYSTEM_ITEMS_B.WIP_SUPPLY_SUBINVENTORY
MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID |
![]() |
![]() |
MTL_SECONDARY_INVENTORIES |
MTL_TRANSACTIONS_INTERFACE.SUBINVENTORY_CODE
MTL_TRANSACTIONS_INTERFACE.ORGANIZATION_ID |
![]() |
![]() |
MTL_SECONDARY_INVENTORIES |
MTL_TRANSACTIONS_INTERFACE.TRANSFER_SUBINVENTORY
MTL_TRANSACTIONS_INTERFACE.TRANSFER_ORGANIZATION |
![]() |
![]() |
MTL_SECONDARY_INVENTORIES |
MTL_TXN_REQUEST_HEADERS.FROM_SUBINVENTORY_CODE
MTL_TXN_REQUEST_HEADERS.ORGANIZATION_ID |
![]() |
![]() |
MTL_SECONDARY_INVENTORIES |
MTL_TXN_REQUEST_HEADERS.TO_SUBINVENTORY_CODE
MTL_TXN_REQUEST_HEADERS.ORGANIZATION_ID |
![]() |
![]() |
MTL_SECONDARY_INVENTORIES |
MTL_TXN_REQUEST_LINES.FROM_SUBINVENTORY_CODE
MTL_TXN_REQUEST_LINES.ORGANIZATION_ID |
![]() |
![]() |
MTL_SECONDARY_INVENTORIES |
MTL_TXN_REQUEST_LINES.TO_SUBINVENTORY_CODE
MTL_TXN_REQUEST_LINES.ORGANIZATION_ID |
![]() |
![]() |
MTL_SECONDARY_INVENTORIES |
MTL_UNIT_TRANSACTIONS.SUBINVENTORY_CODE
MTL_UNIT_TRANSACTIONS.ORGANIZATION_ID |
![]() |
![]() |
MTL_SECONDARY_INVENTORIES |
PJM_DEFAULT_TASKS.SUBINVENTORY_CODE
PJM_DEFAULT_TASKS.ORGANIZATION_ID |
![]() |
![]() |
MTL_SECONDARY_INVENTORIES |
PO_DISTRIBUTIONS_ARCHIVE_ALL.DESTINATION_SUBINVENTORY
PO_DISTRIBUTIONS_ARCHIVE_ALL.DESTINATION_ORGANIZATION_ID |
![]() |
![]() |
MTL_SECONDARY_INVENTORIES |
PO_DISTRIBUTIONS_DRAFT_ALL.DESTINATION_SUBINVENTORY
PO_DISTRIBUTIONS_DRAFT_ALL.DESTINATION_ORGANIZATION_ID |
![]() |
![]() |
MTL_SECONDARY_INVENTORIES |
PO_DISTRIBUTIONS_ALL.DESTINATION_SUBINVENTORY
PO_DISTRIBUTIONS_ALL.DESTINATION_ORGANIZATION_ID |
![]() |
![]() |
MTL_SECONDARY_INVENTORIES |
PO_REQUISITIONS_INTERFACE_ALL.SOURCE_SUBINVENTORY
PO_REQUISITIONS_INTERFACE_ALL.SOURCE_ORGANIZATION_ID |
![]() |
![]() |
MTL_SECONDARY_INVENTORIES |
PO_REQUISITIONS_INTERFACE_ALL.DESTINATION_SUBINVENTORY
PO_REQUISITIONS_INTERFACE_ALL.DESTINATION_ORGANIZATION_ID |
![]() |
![]() |
MTL_SECONDARY_INVENTORIES |
RCV_SHIPMENT_LINES.TO_SUBINVENTORY
RCV_SHIPMENT_LINES.TO_ORGANIZATION_ID |
![]() |
![]() |
MTL_SECONDARY_INVENTORIES |
RCV_SUPPLY.FROM_SUBINVENTORY
RCV_SUPPLY.FROM_ORGANIZATION_ID |
![]() |
![]() |
MTL_SECONDARY_INVENTORIES |
RCV_SUPPLY.TO_SUBINVENTORY
RCV_SUPPLY.TO_ORGANIZATION_ID |
![]() |
![]() |
MTL_SECONDARY_INVENTORIES |
RCV_TRANSACTIONS.SUBINVENTORY
RCV_TRANSACTIONS.ORGANIZATION_ID |
![]() |
![]() |
MTL_SECONDARY_INVENTORIES |
RCV_TRANSACTIONS_INTERFACE.SUBINVENTORY
RCV_TRANSACTIONS_INTERFACE.TO_ORGANIZATION_ID |
![]() |
![]() |
MTL_SECONDARY_INVENTORIES |
WIP_DISCRETE_JOBS.COMPLETION_SUBINVENTORY
WIP_DISCRETE_JOBS.ORGANIZATION_ID |
![]() |
![]() |
MTL_SECONDARY_INVENTORIES |
WIP_PARAMETERS.DEFAULT_PULL_SUPPLY_SUBINV
WIP_PARAMETERS.ORGANIZATION_ID |
![]() |
![]() |
MTL_SECONDARY_INVENTORIES |
WIP_REPETITIVE_ITEMS.COMPLETION_SUBINVENTORY
WIP_REPETITIVE_ITEMS.ORGANIZATION_ID |
![]() |
![]() |
MTL_SECONDARY_INVENTORIES |
WIP_REQUIREMENT_OPERATIONS.SUPPLY_SUBINVENTORY
WIP_REQUIREMENT_OPERATIONS.ORGANIZATION_ID |
![]() |
![]() |
MTL_SECONDARY_INVENTORIES |
WMS_DEPARTMENT_SUBINVENTORIES.SUBINVENTORY_CODE
WMS_DEPARTMENT_SUBINVENTORIES.ORGANIZATION_ID |
![]() |
![]() |
MTL_SECONDARY_INVENTORIES |
WMS_EXCEPTIONS.SUBINVENTORY_CODE
WMS_EXCEPTIONS.ORGANIZATION_ID |
![]() |
![]() |
MTL_SECONDARY_INVENTORIES |
WMS_LICENSE_PLATE_NUMBERS.SUBINVENTORY_CODE
WMS_LICENSE_PLATE_NUMBERS.ORGANIZATION_ID |
![]() |
![]() |
MTL_SECONDARY_INVENTORIES |
WMS_LPN_HISTORIES.SUBINVENTORY_CODE
WMS_LPN_HISTORIES.ORGANIZATION_ID |
![]() |
![]() |
MTL_SECONDARY_INVENTORIES |
WMS_LPN_INTERFACE.SUBINVENTORY_CODE
WMS_LPN_INTERFACE.ORGANIZATION_ID |
![]() |
![]() |
MTL_SECONDARY_INVENTORIES |
WMS_SKIP_TASK_EXCEPTIONS.SUBINVENTORY_CODE
WMS_SKIP_TASK_EXCEPTIONS.ORGANIZATION_ID |
![]() |
![]() |
MTL_SECONDARY_INVENTORIES |
WSM_CO_PRODUCTS.SUPPLY_SUBINVENTORY
WSM_CO_PRODUCTS.ORGANIZATION_ID |
![]() |
![]() |
MTL_SECONDARY_INVENTORIES |
WSM_LOT_JOB_INTERFACE.COMPLETION_SUBINVENTORY
WSM_LOT_JOB_INTERFACE.ORGANIZATION_ID |
![]() |
![]() |
MTL_SECONDARY_INVENTORIES |
WSM_RESULTING_LOTS_INTERFACE.SUBINVENTORY_CODE
WSM_RESULTING_LOTS_INTERFACE.ORGANIZATION_ID |
![]() |
![]() |
MTL_SECONDARY_INVENTORIES |
WSM_SM_STARTING_LOTS.SUBINVENTORY_CODE
WSM_SM_STARTING_LOTS.ORGANIZATION_ID |
![]() |
![]() |
MTL_SECONDARY_INVENTORIES |
WSM_STARTING_LOTS_INTERFACE.SUBINVENTORY_CODE
WSM_STARTING_LOTS_INTERFACE.ORGANIZATION_ID |
![]() |
![]() |
MTL_SECONDARY_INVENTORIES |
WSM_SUBINVENTORY_EXTENSIONS.SECONDARY_INVENTORY_NAME
WSM_SUBINVENTORY_EXTENSIONS.ORGANIZATION_ID |
|
|
|