Table: MTL_ITEM_REVISIONS_B

Product:	INV - Inventory
Description:	Item revisions
Implementation/DBA Data:	INV.MTL_ITEM_REVISIONS_B

Primary Key: MTL_ITEM_REVISIONS_B_PK

1. INVENTORY_ITEM_ID
2. ORGANIZATION_ID
3. REVISION_ID

Primary Key: MTL_ITEM_REVISIONS_PK

1. INVENTORY_ITEM_ID
2. ORGANIZATION_ID
3. REVISION

Foreign Keys

Table		Foreign Table	Foreign Key Column
MTL_ITEM_REVISIONS_B		MTL_SYSTEM_ITEMS_B	MTL_ITEM_REVISIONS_B.INVENTORY_ITEM_ID MTL_ITEM_REVISIONS_B.ORGANIZATION_ID
MTL_ITEM_REVISIONS_B		ENG_ENGINEERING_CHANGES	MTL_ITEM_REVISIONS_B.CHANGE_NOTICE MTL_ITEM_REVISIONS_B.ORGANIZATION_ID
MTL_ITEM_REVISIONS_B		MTL_PARAMETERS	MTL_ITEM_REVISIONS_B.ORGANIZATION_ID
CSI_ITEM_INSTANCES		MTL_ITEM_REVISIONS_B	CSI_ITEM_INSTANCES.INVENTORY_ITEM_ID CSI_ITEM_INSTANCES.INV_MASTER_ORGANIZATION_ID CSI_ITEM_INSTANCES.INVENTORY_REVISION
CS_CUSTOMER_PRODUCTS_ALL		MTL_ITEM_REVISIONS_B	CS_CUSTOMER_PRODUCTS_ALL.MIB_INVENTORY_ITEM_ID CS_CUSTOMER_PRODUCTS_ALL.MIB_ORGANIZATION_ID CS_CUSTOMER_PRODUCTS_ALL.MIB_REVISION_ID
MRP_REPETITIVE_SCHEDULES		MTL_ITEM_REVISIONS_B	MRP_REPETITIVE_SCHEDULES.INVENTORY_ITEM_ID MRP_REPETITIVE_SCHEDULES.ORGANIZATION_ID MRP_REPETITIVE_SCHEDULES.REVISION
MRP_RESERVATIONS		MTL_ITEM_REVISIONS_B	MRP_RESERVATIONS.INVENTORY_ITEM_ID MRP_RESERVATIONS.ORGANIZATION_ID MRP_RESERVATIONS.REVISION
MRP_SYSTEM_ITEMS		MTL_ITEM_REVISIONS_B	MRP_SYSTEM_ITEMS.INVENTORY_ITEM_ID MRP_SYSTEM_ITEMS.ORGANIZATION_ID MRP_SYSTEM_ITEMS.REVISION
MTL_CC_ENTRIES_INTERFACE		MTL_ITEM_REVISIONS_B	MTL_CC_ENTRIES_INTERFACE.INVENTORY_ITEM_ID MTL_CC_ENTRIES_INTERFACE.ORGANIZATION_ID MTL_CC_ENTRIES_INTERFACE.REVISION
MTL_CYCLE_COUNT_ENTRIES		MTL_ITEM_REVISIONS_B	MTL_CYCLE_COUNT_ENTRIES.INVENTORY_ITEM_ID MTL_CYCLE_COUNT_ENTRIES.ORGANIZATION_ID MTL_CYCLE_COUNT_ENTRIES.REVISION
MTL_DEMAND		MTL_ITEM_REVISIONS_B	MTL_DEMAND.INVENTORY_ITEM_ID MTL_DEMAND.ORGANIZATION_ID MTL_DEMAND.REVISION
MTL_DEMAND_INTERFACE		MTL_ITEM_REVISIONS_B	MTL_DEMAND_INTERFACE.INVENTORY_ITEM_ID MTL_DEMAND_INTERFACE.ORGANIZATION_ID MTL_DEMAND_INTERFACE.REVISION
MTL_ITEM_REVISIONS_TL		MTL_ITEM_REVISIONS_B	MTL_ITEM_REVISIONS_TL.INVENTORY_ITEM_ID MTL_ITEM_REVISIONS_TL.ORGANIZATION_ID MTL_ITEM_REVISIONS_TL.REVISION_ID
MTL_MATERIAL_TRANSACTIONS		MTL_ITEM_REVISIONS_B	MTL_MATERIAL_TRANSACTIONS.INVENTORY_ITEM_ID MTL_MATERIAL_TRANSACTIONS.ORGANIZATION_ID MTL_MATERIAL_TRANSACTIONS.REVISION
MTL_MATERIAL_TRANSACTIONS_TEMP		MTL_ITEM_REVISIONS_B	MTL_MATERIAL_TRANSACTIONS_TEMP.INVENTORY_ITEM_ID MTL_MATERIAL_TRANSACTIONS_TEMP.ORGANIZATION_ID MTL_MATERIAL_TRANSACTIONS_TEMP.REVISION
MTL_ONHAND_QUANTITIES		MTL_ITEM_REVISIONS_B	MTL_ONHAND_QUANTITIES.INVENTORY_ITEM_ID MTL_ONHAND_QUANTITIES.ORGANIZATION_ID MTL_ONHAND_QUANTITIES.REVISION
MTL_PHYSICAL_ADJUSTMENTS		MTL_ITEM_REVISIONS_B	MTL_PHYSICAL_ADJUSTMENTS.INVENTORY_ITEM_ID MTL_PHYSICAL_ADJUSTMENTS.ORGANIZATION_ID MTL_PHYSICAL_ADJUSTMENTS.REVISION
MTL_PHYSICAL_INVENTORY_TAGS		MTL_ITEM_REVISIONS_B	MTL_PHYSICAL_INVENTORY_TAGS.INVENTORY_ITEM_ID MTL_PHYSICAL_INVENTORY_TAGS.ORGANIZATION_ID MTL_PHYSICAL_INVENTORY_TAGS.REVISION
MTL_RESERVATIONS		MTL_ITEM_REVISIONS_B	MTL_RESERVATIONS.INVENTORY_ITEM_ID MTL_RESERVATIONS.ORGANIZATION_ID MTL_RESERVATIONS.REVISION
MTL_RESERVATIONS_INTERFACE		MTL_ITEM_REVISIONS_B	MTL_RESERVATIONS_INTERFACE.INVENTORY_ITEM_ID MTL_RESERVATIONS_INTERFACE.ORGANIZATION_ID MTL_RESERVATIONS_INTERFACE.REVISION
MTL_RESERVATIONS_INTERFACE		MTL_ITEM_REVISIONS_B	MTL_RESERVATIONS_INTERFACE.INVENTORY_ITEM_ID MTL_RESERVATIONS_INTERFACE.ORGANIZATION_ID MTL_RESERVATIONS_INTERFACE.TO_REVISION
MTL_SERIAL_NUMBERS		MTL_ITEM_REVISIONS_B	MTL_SERIAL_NUMBERS.INVENTORY_ITEM_ID MTL_SERIAL_NUMBERS.CURRENT_ORGANIZATION_ID MTL_SERIAL_NUMBERS.REVISION
MTL_SUPPLY		MTL_ITEM_REVISIONS_B	MTL_SUPPLY.ITEM_ID MTL_SUPPLY.TO_ORGANIZATION_ID MTL_SUPPLY.ITEM_REVISION
MTL_TXN_REQUEST_LINES		MTL_ITEM_REVISIONS_B	MTL_TXN_REQUEST_LINES.INVENTORY_ITEM_ID MTL_TXN_REQUEST_LINES.ORGANIZATION_ID MTL_TXN_REQUEST_LINES.REVISION
PJM_BORROW_TRANSACTIONS		MTL_ITEM_REVISIONS_B	PJM_BORROW_TRANSACTIONS.INVENTORY_ITEM_ID PJM_BORROW_TRANSACTIONS.ORGANIZATION_ID PJM_BORROW_TRANSACTIONS.REVISION
WIP_DISCRETE_JOBS		MTL_ITEM_REVISIONS_B	WIP_DISCRETE_JOBS.PRIMARY_ITEM_ID WIP_DISCRETE_JOBS.ORGANIZATION_ID WIP_DISCRETE_JOBS.BOM_REVISION
WIP_FLOW_SCHEDULES		MTL_ITEM_REVISIONS_B	WIP_FLOW_SCHEDULES.PRIMARY_ITEM_ID WIP_FLOW_SCHEDULES.ORGANIZATION_ID WIP_FLOW_SCHEDULES.BOM_REVISION
WMS_EXCEPTIONS		MTL_ITEM_REVISIONS_B	WMS_EXCEPTIONS.INVENTORY_ITEM_ID WMS_EXCEPTIONS.ORGANIZATION_ID WMS_EXCEPTIONS.REVISION
WMS_LICENSE_PLATE_NUMBERS		MTL_ITEM_REVISIONS_B	WMS_LICENSE_PLATE_NUMBERS.INVENTORY_ITEM_ID WMS_LICENSE_PLATE_NUMBERS.ORGANIZATION_ID WMS_LICENSE_PLATE_NUMBERS.REVISION
WMS_LPN_CONTENTS		MTL_ITEM_REVISIONS_B	WMS_LPN_CONTENTS.INVENTORY_ITEM_ID WMS_LPN_CONTENTS.ORGANIZATION_ID WMS_LPN_CONTENTS.REVISION
WMS_LPN_HISTORIES		MTL_ITEM_REVISIONS_B	WMS_LPN_HISTORIES.INVENTORY_ITEM_ID WMS_LPN_HISTORIES.ORGANIZATION_ID WMS_LPN_HISTORIES.REVISION
WMS_SKIP_TASK_EXCEPTIONS		MTL_ITEM_REVISIONS_B	WMS_SKIP_TASK_EXCEPTIONS.INVENTORY_ITEM_ID WMS_SKIP_TASK_EXCEPTIONS.ORGANIZATION_ID WMS_SKIP_TASK_EXCEPTIONS.REVISION