SCH_REC_LINES
This table stores the line information of a product recall notice which includes manufacturer part details such as part number, model or brand.It also stores the internal master item details such as item number,item description and item category. Each line will have reference to ITEM_VALIDATION_ORG_ID which is derived based on the business unit in which recall notice is created.
Details
-
Schema: FUSION
-
Object owner: SCH
-
Object type: TABLE
-
Tablespace: Default
Primary Key
Name | Columns |
---|---|
SCH_REC_LINES_PK |
LINE_ID |
Columns
Name | Datatype | Length | Precision | Not-null | Comments |
---|---|---|---|---|---|
LINE_ID | NUMBER | 18 | Yes | Recall Notice Line unique identifier. | |
PO_VENDOR_PART_LINE_ID | NUMBER | 18 | Indicates the PO Line Identifier corresponding to the standard purchase order that stores the Supplier Part Number. | ||
LINE_NUMBER | NUMBER | 18 | Yes | Indicates the recall notice line number generated internally. | |
VENDOR_PART_ID | NUMBER | 18 | Supplier Part Number unique identifier. | ||
HEADER_ID | NUMBER | 18 | Yes | Recall Notice Header Unique identifier. | |
PRODUCT_TYPE | VARCHAR2 | 600 | A free text where the User can enter the type of the product as per the classification done by Regulatory Authority for the product being recalled. | ||
NDC_CODE | VARCHAR2 | 60 | National Drug Code for the recalled part. | ||
MANUFACTURER_PART_ID | NUMBER | 18 | Unique Identifier of the Trading partner item number with relationship type as Manufacturer. | ||
BPA_MANUFACTURER_PART_LINE_ID | NUMBER | 18 | Indicates the PO Line Identifier corresponding to the Blanket Purchase Agreement that stores the Manufacturer Part Number. | ||
MANUFACTURER_PART_NUM | VARCHAR2 | 700 | Manufacturer Part Number for which there is a product recall. | ||
INVENTORY_ITEM_ID | NUMBER | 18 | Inventory Item ID is a Master Item unique identifier. | ||
ITEM_CATEGORY_ID | NUMBER | 18 | Purchasing Item Category unique identifier. | ||
BRAND_NAME | VARCHAR2 | 60 | Free text where the user can enter the brand name for the recalled product. | ||
MODEL_NAME | VARCHAR2 | 60 | Free text where the user can enter the model name for the recalled product. | ||
ITEM_VALIDATION_ORG_ID | NUMBER | 18 | Unique Identifier of the Item Validation Organization for the Business Unit. | ||
RECALL_QUANTITY | NUMBER | This column is no more used in this table. | |||
RECALL_UOM | VARCHAR2 | 30 | This column is no more used in this table. | ||
RECALL_CLASSIFICATION_TYPE | VARCHAR2 | 30 | This column is no more used in this table. | ||
RECALL_CLOSING_DATE | TIMESTAMP | Indicates the closing date of recall notice line. | |||
REPLACEMENT_TYPE | VARCHAR2 | 30 | This column is no more used in this table. | ||
RECALL_LINE_STATUS | VARCHAR2 | 30 | Indicates the status of recall notice line. These values are retrieved from the seeded lookup type ORA_SCH_RECALL_LINE_STATUS. | ||
ORIGINAL_LINE_ID | NUMBER | 18 | Unique identifier of original recall notice line that gets updated for a recall notice line marked as duplicate. | ||
RECALL_TRACK_START_DATE | DATE | This column is no more used in this table. | |||
RECALL_TRACK_END_DATE | DATE | This column is no more used in this table. | |||
VENDOR_PRODUCT_NUM | VARCHAR2 | 300 | Indicates the supplier part number that is recalled. | ||
COMMENTS | VARCHAR2 | 2000 | Used to update any comments for a recall notice line. | ||
OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | 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. | |
PRODUCT_DESCRIPTION | VARCHAR2 | 4000 | Indicates the description of the recalled product provided by the source who initiated the recall. | ||
GTIN | VARCHAR2 | 255 | Indicates the Global Trade Identification Number of the recalled product. | ||
REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
UDI | VARCHAR2 | 255 | Indicates the Unique Device Identification number of the recalled product. | ||
PART_NUMBER | VARCHAR2 | 700 | Indicates the part number of the recalled product provided by the source who initiated the recall. | ||
ADDITIONAL_INFORMATION | VARCHAR2 | 4000 | Used to enter attributes that can be defined as descriptive flex fields at the recall notice line level. | ||
PRODUCT_TYPE_CODE | VARCHAR2 | 30 | Indicates the categorisation of the product that is recalled usually provided by the source who initiates the recall. | ||
JOB_DEFINITION_NAME | VARCHAR2 | 100 | Enterprise Service Scheduler: indicates the name of the job that created or last updated the row. | ||
JOB_DEFINITION_PACKAGE | VARCHAR2 | 900 | Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row. | ||
CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
ATTRIBUTE_CATEGORY | VARCHAR2 | 80 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR1 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR2 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR3 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR4 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR5 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR6 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR7 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR8 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR9 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR10 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR11 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR12 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR13 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR14 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR15 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR16 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR17 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR18 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR19 | VARCHAR2 | 240 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR20 | VARCHAR2 | 240 | 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_DATE6 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_DATE7 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_DATE8 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_DATE9 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_DATE10 | 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. | |||
ATTRIBUTE_TIMESTAMP6 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_TIMESTAMP7 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_TIMESTAMP8 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_TIMESTAMP9 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_TIMESTAMP10 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. |
Foreign Keys
Table | Foreign Table | Foreign Key Column |
---|---|---|
SCH_REC_LINES | sch_rec_headers | HEADER_ID |
sch_rec_trace_status | sch_rec_lines | LINE_ID |
sch_rec_serial_numbers | sch_rec_lines | LINE_ID |
sch_rec_lot_numbers | sch_rec_lines | LINE_ID |
Indexes
Index | Uniqueness | Tablespace | Columns |
---|---|---|---|
SCH_REC_LINES_N1 | Non Unique | Default | HEADER_ID |
SCH_REC_LINES_N2 | Non Unique | DEFAULT | INVENTORY_ITEM_ID |
SCH_REC_LINES_U1 | Unique | Default | LINE_ID |