1. Tables and Views for SCM
  2. SCH_REC_DISP_DETAIL

SCH_REC_DISP_DETAIL

This table stores the disposition action details for the recalled parts that corresponds to each task assigned at the disposition inventory organization level.This includes disposition method whether it is Return to Vendor or Scrap, disposition quantity details, document number based on which disposition action is taken, shipment number based on which Return to vendor transaction takes place and the transaction date.

Details

  • Schema: FUSION

  • Object owner: SCH

  • Object type: TABLE

  • Tablespace: Default

Primary Key

Name Columns

SCH_REC_DISP_DETAIL_PK

DISPOSITION_ID

Columns

Name Datatype Length Precision Not-null Comments
DISPOSITION_ID NUMBER 18 Yes Disposition detail unique identifier.
UNIT_COST NUMBER Indicates the item cost of the recalled item at the time of performing the disposition.
CURRENCY_CODE VARCHAR2 30 Indicates the currency code in which item cost is displayed for the recalled item.
DISPOSITION_DOCUMENT_REF_LINE NUMBER Indicates the supplier return line number for the unreferenced return or scrap transaction performed for a recalled item against a recall notice.
DISPOSITION_DOCUMENT_REF_ID NUMBER 18 Unique identifier of the document based on which disposition is performed for the recalled item. PO_HEADER_ID is stored as unique identifier in case of referenced supplier returns and supplier return header identifier in case of unreferenced return or scrap.
UNIT_PRICE NUMBER Indicates the unit price of the recalled item based on the purchase order line against which supplier return is performed.
LOT_NUMBER VARCHAR2 80 Indicates the lot number that was disposed for a recalled item against a recall notice.
SUBINVENTORY VARCHAR2 10 Indicates the recall subinventory from where the disposal is performed for a recalled item.
LOCATOR_ID NUMBER 18 Indicates the stock locator from where the disposal is performed for a recalled item.
VENDOR_ID NUMBER 18 Supplier unique identifier. References POZ_SUPPLIERS.VENDOR_ID.
VENDOR_SITE_ID NUMBER 18 Supplier site unique identifier. References POZ_SUPPLIER_SITES_ALL_M.VENDOR_SITE_ID.
ACTION_ID NUMBER 18 Unique identifier for the task assignment at product recall traceability header level or recall notice line level.
RECALL_DISP_METHOD VARCHAR2 60 Indicates the method by which the recalled parts get disposed. For example, Return to Vendor, Scrap.
RECALL_DISP_QTY NUMBER Quantity returned or quantity scrapped for the recalled part.
RECALL_DISP_UOM_CODE VARCHAR2 3 Unit of measure in which recalled part is returned or scrapped.
DISPOSITION_DOCUMENT_REF VARCHAR2 60 Document number based on which disposition action is taken whether it is Unreferenced return or scrap.
SHIPMENT_NUMBER VARCHAR2 30 Shipment number based on which Return transaction is performed.
TRANSACTION_DATE TIMESTAMP Date on which the disposition transaction happens which includes return to vendor as well as scrap.
SHIP_TO_ADDRESS VARCHAR2 4000 Manufacturer site address to which recalled parts will be returned.
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_DISP_DETAIL sch_rec_task_history ACTION_ID
sch_rec_disp_detail_lines sch_rec_disp_detail DISPOSITION_ID

Indexes

Index Uniqueness Tablespace Columns
SCH_REC_DISP_DETAIL_N1 Non Unique Default ACTION_ID
SCH_REC_DISP_DETAIL_U1 Unique Default DISPOSITION_ID