FND Design Data [Home] [Help]

Table: MTL_PHYSICAL_ADJUSTMENTS

Product: INV - Inventory
Description: Physical inventory adjustments
Implementation/DBA Data: TableINV.MTL_PHYSICAL_ADJUSTMENTS
Primary Key: MTL_PHYSICAL_ADJUSTMENTS_PK
  1. ColumnADJUSTMENT_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
MTL_PHYSICAL_ADJUSTMENTS FK Joins to TableMTL_PHYSICAL_INVENTORIES MTL_PHYSICAL_ADJUSTMENTS.ORGANIZATION_ID
MTL_PHYSICAL_ADJUSTMENTS.PHYSICAL_INVENTORY_ID
MTL_PHYSICAL_ADJUSTMENTS FK Joins to TableWMS_LICENSE_PLATE_NUMBERS MTL_PHYSICAL_ADJUSTMENTS.OUTERMOST_LPN_ID
MTL_PHYSICAL_ADJUSTMENTS FK Joins to TableCST_COST_GROUPS MTL_PHYSICAL_ADJUSTMENTS.COST_GROUP_ID
MTL_PHYSICAL_ADJUSTMENTS FK Joins to TableWMS_LICENSE_PLATE_NUMBERS MTL_PHYSICAL_ADJUSTMENTS.PARENT_LPN_ID
MTL_PHYSICAL_ADJUSTMENTS FK Joins to TableMTL_SYSTEM_ITEMS_B MTL_PHYSICAL_ADJUSTMENTS.INVENTORY_ITEM_ID
MTL_PHYSICAL_ADJUSTMENTS.ORGANIZATION_ID
MTL_PHYSICAL_ADJUSTMENTS FK Joins to TableMTL_SECONDARY_INVENTORIES MTL_PHYSICAL_ADJUSTMENTS.SUBINVENTORY_NAME
MTL_PHYSICAL_ADJUSTMENTS.ORGANIZATION_ID
MTL_PHYSICAL_ADJUSTMENTS FK Joins to TableMTL_ITEM_REVISIONS_B MTL_PHYSICAL_ADJUSTMENTS.INVENTORY_ITEM_ID
MTL_PHYSICAL_ADJUSTMENTS.ORGANIZATION_ID
MTL_PHYSICAL_ADJUSTMENTS.REVISION
MTL_PHYSICAL_ADJUSTMENTS FK Joins to TableGL_CODE_COMBINATIONS MTL_PHYSICAL_ADJUSTMENTS.GL_ADJUST_ACCOUNT
MTL_PHYSICAL_ADJUSTMENTS FK Joins to TableMTL_LOT_NUMBERS MTL_PHYSICAL_ADJUSTMENTS.INVENTORY_ITEM_ID
MTL_PHYSICAL_ADJUSTMENTS.ORGANIZATION_ID
MTL_PHYSICAL_ADJUSTMENTS.LOT_NUMBER
MTL_PHYSICAL_ADJUSTMENTS FK Joins to TableMTL_SERIAL_NUMBERS MTL_PHYSICAL_ADJUSTMENTS.SERIAL_NUMBER
MTL_PHYSICAL_ADJUSTMENTS.INVENTORY_ITEM_ID
MTL_PHYSICAL_ADJUSTMENTS.ORGANIZATION_ID
TableMTL_MATERIAL_TRANSACTIONS FK Joins to MTL_PHYSICAL_ADJUSTMENTS MTL_MATERIAL_TRANSACTIONS.PHYSICAL_ADJUSTMENT_ID
TableMTL_PHYSICAL_INVENTORY_TAGS FK Joins to MTL_PHYSICAL_ADJUSTMENTS MTL_PHYSICAL_INVENTORY_TAGS.ADJUSTMENT_ID
TableMTL_PHYSICAL_INVENTORY_TAGS FK Joins to MTL_PHYSICAL_ADJUSTMENTS MTL_PHYSICAL_INVENTORY_TAGS.ADJUSTMENT_ID