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. | |
LINE_NUMBER | NUMBER | 18 | Yes | Indicates the recall notice line number generated internally. | |
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. | |||
COMMENTS | VARCHAR2 | 2000 | Indicates the comments for withdrawal of a recall 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. | |
REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
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 |