SCH_DEF_ITEM_DETAILS_GT
This table stores the defective SKU details for a recall notice temporarily for a session during the execution of 'Locate Recalled Parts' scheduled process to trace the recalled parts.
Details
-
Schema: FUSION
-
Object owner: SCH
-
Object type: TABLE
-
Tablespace: DEFAULT
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| DEFECTIVE_ENTITY_ID | NUMBER | 18 | Yes | Defective SKU unique identifier that represents the recalled part captured in the recall notice. | |
| ORGANIZATION_ID | NUMBER | 18 | Defective organization unique identifier that represents the inventory organization in which the recalled part has been transacted. | ||
| INVENTORY_ITEM_ID | NUMBER | 18 | Inventory item unique identifer representing the inventory item that has been recalled. | ||
| SUBINVENTORY_CODE | VARCHAR2 | 10 | Indicates the defective subinventory code in which the recalled part has been transacted. | ||
| LOCATOR_ID | NUMBER | 18 | Defective locator unique identifier that represents the stock locator in which the recalled part has been transacted. | ||
| DEFECT_LEVEL | NUMBER | 18 | Indicates the level of occurrence of transaction for a recalled part in a particular subinventory or stock locator. | ||
| LOT_NUMBER | VARCHAR2 | 80 | Indicates the lot number that represents a potential recalled lot. | ||
| SERIAL_NUMBER | VARCHAR2 | 80 | Indicates the serial number that represents a potential recalled serial. | ||
| REVISION | VARCHAR2 | 18 | Indicates the item revision that represents a potential recalled item revision. |