1. Tables and Views for SCM
  2. INV_LOT_NUMBERS_

INV_LOT_NUMBERS_

INV_LOT_NUMBERS_ stores the audit trail definition of the lot number master. When you create a lot, a new row is inserted in the lot master table INV_LOT_NUMBERS and it also inserts a row in the audit table INV_LOT_NUMBERS_. When a lot attribute is modified, a new row is inserted in INV_LOT_NUMBERS_ with the modified value of attributes.

Details

  • Schema: FUSION

  • Object owner: INV

  • Object type: TABLE

  • Tablespace: FUSION_TS_TX_DATA

Primary Key

Name Columns

INV_LOT_NUMBER_PK_

LAST_UPDATE_DATE, LAST_UPDATED_BY, INVENTORY_ITEM_ID, ORGANIZATION_ID, LOT_NUMBER

Columns

Name Datatype Length Precision Not-null Comments Status
INVENTORY_ITEM_ID NUMBER 18 Yes This identifies the inventory item. Active
UNIQUE_DEVICE_IDENTIFIER VARCHAR2 150 The unique device identifier (UDI) is a unique alphanumeric or numeric code identifying a medical device.
ORGANIZATION_ID NUMBER 18 Yes This identifies the inventory organization. Active
LOT_NUMBER VARCHAR2 80 Yes This number identifies an inventory lot. Active
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row. Active
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row. Active
CREATION_DATE TIMESTAMP Who column: indicates the date and time of the creation of the row. Active
CREATED_BY VARCHAR2 64 Who column: indicates the user who created the row. Active
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row. Active
EXPIRATION_DATE DATE This is the date of the lot expiration. Active
DISABLE_FLAG VARCHAR2 30 Flag indicates whether the lot number is disabled. Active
ATTRIBUTE_CATEGORY VARCHAR2 30 Descriptive Flexfield: structure definition of the user descriptive flexfield. Active
ATTRIBUTE1 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE2 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE3 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE4 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE5 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE6 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE7 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE8 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE9 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE10 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE11 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE12 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE13 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE14 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE15 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. Active
GEN_OBJECT_ID NUMBER 18 This identifies the genealogy object. Active
DESCRIPTION VARCHAR2 256 Description for the Lot Number - Used by WMS only Active
VENDOR_ID NUMBER 18 Supplier identification (from po_vendors table) - Used by WMS Only Active
SUPPLIER_LOT_NUMBER VARCHAR2 150 Lot number given by the supplier for PO receipts - Used By WMS Only Active
TERRITORY_CODE VARCHAR2 30 Territory Code for Country of Origin Active
GRADE_CODE VARCHAR2 150 This indicates the lot grade. Used by WMS only. Active
ORIGINATION_DATE DATE Lot creation date (as in the BRD) - Used By WMS Only Active
DATE_CODE VARCHAR2 150 A code identifying the date of packaging or assembly. Used by WMS only. Active
STATUS_ID NUMBER 18 Status identifier - Used by WMS only Active
CHANGE_DATE DATE Last modified date (as in the BRD) - Used By WMS Only Active
AGE NUMBER The age of the lot or sublot in days after the creation date - Used By WMS Only Active
RETEST_DATE DATE This is the retest date. Used by WMS only. Active
MATURITY_DATE DATE The date on which the item matures - Used By WMS Only Active
LOT_ATTRIBUTE_CATEGORY VARCHAR2 30 Lot attributes descriptive flexfield structure defining column Active
ITEM_SIZE NUMBER The size of a given product, determined by visual inspection. - Used By WMS Only Active
COLOR VARCHAR2 150 Name of the color. Used by WMS only. Active
LOT_VOLUME NUMBER The volume of the lot or sublot- Used By WMS Only Active
VOLUME_UOM VARCHAR2 3 When defining the volume attribute the ability to identify a volume unit of measure such as cubic inches or cubic centimeters should also be included. - Used By WMS Only Active
PLACE_OF_ORIGIN VARCHAR2 150 Country of Origin- Used By WMS Only Active
BEST_BY_DATE DATE The date on or before which the lot or sublot is best used.- Used By WMS Only Active
LOT_LENGTH NUMBER The length dimension of the lot or sublot.- Used By WMS Only Active
LENGTH_UOM VARCHAR2 3 Unit of measure for measuring lenght- Used By WMS Only Active
RECYCLED_CONTENT NUMBER The content, usually expressed as a percentage, of the product that is made up of recycled materials- Used By WMS Only Active
LOT_THICKNESS NUMBER The thickness dimension of the lot.- Used By WMS Only Active
THICKNESS_UOM VARCHAR2 3 UOM to measure thickness- Used By WMS Only Active
LOT_WIDTH NUMBER The width dimension of the lot.- Used By WMS Only Active
WIDTH_UOM VARCHAR2 3 UOM to measure width dimension of the lot.- Used By WMS Only Active
CURL_WRINKLE_FOLD VARCHAR2 150 This attribute is used in the pulp and paper industry to identify potential problems when feeding the paper through machinery.- Used By WMS Only Active
C_ATTRIBUTE1 VARCHAR2 150 Descriptive flexfield segment- Used By WMS Only Active
C_ATTRIBUTE2 VARCHAR2 150 Descriptive flexfield segment- Used By WMS Only Active
C_ATTRIBUTE3 VARCHAR2 150 Descriptive flexfield segment- Used By WMS Only Active
C_ATTRIBUTE4 VARCHAR2 150 Descriptive flexfield segment- Used By WMS Only Active
C_ATTRIBUTE5 VARCHAR2 150 Descriptive flexfield segment- Used By WMS Only Active
C_ATTRIBUTE6 VARCHAR2 150 Descriptive flexfield segment- Used By WMS Only Active
C_ATTRIBUTE7 VARCHAR2 150 Descriptive flexfield segment- Used By WMS Only Active
C_ATTRIBUTE8 VARCHAR2 150 Descriptive flexfield segment- Used By WMS Only Active
C_ATTRIBUTE9 VARCHAR2 150 Descriptive flexfield segment- Used By WMS Only Active
C_ATTRIBUTE10 VARCHAR2 150 Descriptive flexfield segment- Used By WMS Only Active
C_ATTRIBUTE11 VARCHAR2 150 Descriptive flexfield segment- Used By WMS Only Active
C_ATTRIBUTE12 VARCHAR2 150 Descriptive flexfield segment- Used By WMS Only Active
C_ATTRIBUTE13 VARCHAR2 150 Descriptive flexfield segment- Used By WMS Only Active
C_ATTRIBUTE14 VARCHAR2 150 Descriptive flexfield segment- Used By WMS Only Active
C_ATTRIBUTE15 VARCHAR2 150 Descriptive flexfield segment- Used By WMS Only Active
C_ATTRIBUTE16 VARCHAR2 150 Descriptive flexfield segment- Used By WMS Only Active
C_ATTRIBUTE17 VARCHAR2 150 Descriptive flexfield segment- Used By WMS Only Active
C_ATTRIBUTE18 VARCHAR2 150 Descriptive flexfield segment- Used By WMS Only Active
C_ATTRIBUTE19 VARCHAR2 150 Descriptive flexfield segment- Used By WMS Only Active
C_ATTRIBUTE20 VARCHAR2 150 Descriptive flexfield segment- Used By WMS Only Active
D_ATTRIBUTE1 DATE Descriptive flexfield segment- Used By WMS Only Active
D_ATTRIBUTE2 DATE Descriptive flexfield segment- Used By WMS Only Active
D_ATTRIBUTE3 DATE Descriptive flexfield segment- Used By WMS Only Active
D_ATTRIBUTE4 DATE Descriptive flexfield segment- Used By WMS Only Active
D_ATTRIBUTE5 DATE Descriptive flexfield segment- Used By WMS Only Active
D_ATTRIBUTE6 DATE Descriptive flexfield segment- Used By WMS Only Active
D_ATTRIBUTE7 DATE Descriptive flexfield segment- Used By WMS Only Active
D_ATTRIBUTE8 DATE Descriptive flexfield segment- Used By WMS Only Active
D_ATTRIBUTE9 DATE Descriptive flexfield segment- Used By WMS Only Active
D_ATTRIBUTE10 DATE Descriptive flexfield segment- Used By WMS Only Active
N_ATTRIBUTE1 NUMBER Descriptive flexfield segment- Used By WMS Only Active
N_ATTRIBUTE2 NUMBER Descriptive flexfield segment- Used By WMS Only Active
N_ATTRIBUTE3 NUMBER Descriptive flexfield segment- Used By WMS Only Active
N_ATTRIBUTE4 NUMBER Descriptive flexfield segment- Used By WMS Only Active
N_ATTRIBUTE5 NUMBER Descriptive flexfield segment- Used By WMS Only Active
N_ATTRIBUTE6 NUMBER Descriptive flexfield segment- Used By WMS Only Active
N_ATTRIBUTE7 NUMBER Descriptive flexfield segment- Used By WMS Only Active
N_ATTRIBUTE8 NUMBER Descriptive flexfield segment- Used By WMS Only Active
N_ATTRIBUTE9 NUMBER Descriptive flexfield segment- Used By WMS Only Active
N_ATTRIBUTE10 NUMBER Descriptive flexfield segment- Used By WMS Only Active
T_ATTRIBUTE1 TIMESTAMP Descriptive flexfield segment- Used By WMS Only
T_ATTRIBUTE2 TIMESTAMP Descriptive flexfield segment- Used By WMS Only
T_ATTRIBUTE3 TIMESTAMP Descriptive flexfield segment- Used By WMS Only
T_ATTRIBUTE4 TIMESTAMP Descriptive flexfield segment- Used By WMS Only
T_ATTRIBUTE5 TIMESTAMP Descriptive flexfield segment- Used By WMS Only
CYCLES_SINCE_NEW VARCHAR2 240 Cycles since new. Used by WMS only. Active
CYCLES_SINCE_OVERHAUL VARCHAR2 240 Cycles since overhaul. Used by WMS only. Active
TIME_SINCE_REPAIR VARCHAR2 240 Time since the last repair. Used by WMS only. Active
CYCLES_SINCE_REPAIR VARCHAR2 240 Cycles since repair. Used by WMS only. Active
TIME_SINCE_VISIT VARCHAR2 240 Time since the last visit. Used by WMS only. Active
CYCLES_SINCE_VISIT VARCHAR2 240 Cycles since visit. Used by WMS only. Active
TIME_SINCE_MARK VARCHAR2 240 Time since the last mark. Used by WMS only. Active
CYCLES_SINCE_MARK VARCHAR2 240 Cycles since mark. Used by WMS only. Active
NUMBER_OF_REPAIRS VARCHAR2 240 Number of repairs for MRO industry. Used by WMS only. Active
VENDOR_NAME VARCHAR2 240 Name of the supplier in case the material is consigned. Active
PARENT_LOT_NUMBER VARCHAR2 80 This is the parent lot number. Used by WMS only. Active
ORIGINATION_TYPE VARCHAR2 30 This is the type of origination. Active
AVAILABILITY_TYPE NUMBER This code indicates the type of availability. Active
EXPIRATION_ACTION_CODE VARCHAR2 32 Code indicates the expiration action. Active
EXPIRATION_ACTION_DATE DATE Date for the expiration action. Active
HOLD_DATE DATE This date defines the hold date. Active
INVENTORY_ATP_CODE NUMBER Code indicates inventory available to promise. Active
RESERVABLE_TYPE NUMBER Indicates hard reservation eligibility. Active
SAMPLING_EVENT_ID NUMBER 18 This is the latest OPM Quality sampling event tested against the lot Active
JOB_DEFINITION_NAME VARCHAR2 100 Enterprise Service Scheduler: indicates the name of the job that created or last updated the row. Active
JOB_DEFINITION_PACKAGE VARCHAR2 900 Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row. Active
OBJECT_VERSION_NUMBER NUMBER 9 Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. Active
ATTRIBUTE16 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE17 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE18 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE19 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE20 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER1 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER2 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER3 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER4 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER5 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER6 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER7 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER8 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER9 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER10 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE1 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE2 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE3 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE4 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE5 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_TIMESTAMP1 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_TIMESTAMP2 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_TIMESTAMP3 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_TIMESTAMP4 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_TIMESTAMP5 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield.
AUDIT_ACTION_TYPE_ VARCHAR2 10 Action Type - have values like INSERT, UPDATE and DELETE.
AUDIT_CHANGE_BIT_MAP_ VARCHAR2 1000 Used to store a bit map of 1s and 0s for each column in the table.
AUDIT_IMPERSONATOR_ VARCHAR2 64 This column will store the original impersonator user.
LOT_ITEM_DISABLE_FLAG VARCHAR2 1 Flag indicates whether the lot number is disabled to be used for the item number.

Indexes

Index Uniqueness Tablespace Columns
INV_LOT_NUMBERSN1_ Non Unique Default INVENTORY_ITEM_ID, ORGANIZATION_ID, LOT_NUMBER, LAST_UPDATE_DATE
INV_LOT_NUMBERS_U1_ Unique FUSION_TS_TX_IDX LAST_UPDATE_DATE, LAST_UPDATED_BY, INVENTORY_ITEM_ID, ORGANIZATION_ID, LOT_NUMBER