1. Tables and Views for SCM
  2. SCH_REC_TRACE_STATUS

SCH_REC_TRACE_STATUS

SCH_REC_TRACE_STATUS stores the product traceability header information for a recalled product when the Locate' action is executed on the recall notice line. One recall notice line can have multiple product traceability header records in this table depending on which all traceability status the recalled product has and where all they reside. The product traceability status includes PAR, EXPENSE, IN STOCK, RECEIVING, IN TRANSIT and SOLD. For each traceability status in which the recalled part in the recall notice line exists or for each warehouse or location or sub inventory where the recalled part resides, there will be unique product traceability header record which gets created. If the product traceability status is EXPENSE, the traceability header record can be unique for each requester who is supposed to consume the recalled parts. PRODUCT_TRACE_ID is the unique system generated primary key in this table.

Details

  • Schema: FUSION

  • Object owner: SCH

  • Object type: TABLE

  • Tablespace: Default

Primary Key

Name Columns

SCH_REC_TRACE_STATUS_PK

PRODUCT_TRACE_ID

Columns

Name Datatype Length Precision Not-null Comments
PRODUCT_TRACE_ID NUMBER 18 Yes Product Recall Traceability Header Unique Identifier.
VENDOR_PRODUCT_NUM VARCHAR2 300 Indicates the supplier part number that is recalled.
LINE_ID NUMBER 18 Yes Recall Notice Line unique identifier.
HEADER_ID NUMBER 18 Yes Recall Notice Unique identifier.
INVENTORY_ITEM_ID NUMBER 18 Unique identifier of the Master Item.
INVENTORY_ORGANIZATION_ID NUMBER 18 Inventory Organization unique identifier.
PRODUCT_TRACE_STATUS VARCHAR2 30 Indicates the product traceability status of a recalled product.These values are retrieved from the seeded lookup type ORA_SCH_TRACE_STATUS.
DELIVER_TO_LOCATION_ID NUMBER 18 Unique identifier for a Location.
SUBINVENTORY VARCHAR2 60 Indicates the Subinventory Name where the recalled parts reside.
MANUFACTURER_PART_NUMBER VARCHAR2 700 Manufacturer Part Number for which traceability is performed.
REQUESTER_ID NUMBER 18 Unique identifier for Requester to whom recalled parts have been issued.
SOLD_TO_CUSTOMER_ID NUMBER 18 Customer account to which recalled parts are sold. This column gets populated only for the traceability status SOLD.
CUSTOMER_RETURN_QUANTITY NUMBER Quantity for which Customer Return Order is created against each Customer account. This column gets populated only for the traceability status SOLD.
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.

Foreign Keys

Table Foreign Table Foreign Key Column
SCH_REC_TRACE_STATUS sch_rec_lines LINE_ID
sch_rec_trace_details sch_rec_trace_status PRODUCT_TRACE_ID
sch_rec_task_history sch_rec_trace_status PRODUCT_TRACE_ID

Indexes

Index Uniqueness Tablespace Columns
SCH_REC_TRACE_STATUS_N1 Non Unique Default LINE_ID
SCH_REC_TRACE_STATUS_U1 Unique Default PRODUCT_TRACE_ID