RCV_SERIALS_SUPPLY
RCV_SERIALS_SUPPLY stores information about the serial numbers that are currently available to transact for intransit shipments. . If you perform an intransit shipment between two organizations that are both under serial control, the receiving transaction processor maintains information about the serial numbers and the lots in which they were issued when the items were shipped. The Lot Entry and Serial Numbers forms use this information to ensure that the same serial numbers that were used for the intransit shipment are also used when you deliver the items to stores in the destination organization. .
Details
-
Schema: FUSION
-
Object owner: RCV
-
Object type: TABLE
-
Tablespace: APPS_TS_TX_DATA
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| SUPPLY_TYPE_CODE | VARCHAR2 | 25 | Yes | Supply type indicator for the serial number that was either shipped (through ASN or in-transit shipment) or received. Possible values - SHIPMENT and RECEIVING. | |
| JOB_DEFINITION_NAME | VARCHAR2 | 100 | Enterprise Service Scheduler: indicates the name of the job that created or last updated the row. | ||
| SERIAL_NUM | VARCHAR2 | 80 | Yes | Lot number that was shipped as part of the ASN line or the in-transit shipment line. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| JOB_DEFINITION_PACKAGE | VARCHAR2 | 900 | Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who 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_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
| SHIPMENT_LINE_ID | NUMBER | 18 | This column stores the receiving shipment receiving receipt line unique identifier. | ||
| TRANSACTION_ID | NUMBER | 18 | This column stores the receiving transaction unique identifier that created the current row. | ||
| LOT_NUM | VARCHAR2 | 80 | Lot number corresponding to the current serial number that was shipped as part of the ASN line or the in-transit shipment line. | ||
| VENDOR_SERIAL_NUM | VARCHAR2 | 80 | This column is not currently populated and hence not in use. | ||
| 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. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| RCV_SERIALS_SUPPLY | rcv_transactions | TRANSACTION_ID |
| RCV_SERIALS_SUPPLY | rcv_shipment_lines | SHIPMENT_LINE_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| RCV_SERIALS_SUPPLY_N1 | Non Unique | Default | TRANSACTION_ID |
| RCV_SERIALS_SUPPLY_N3 | Non Unique | Default | LOT_NUM |
| RCV_SERIALS_SUPPLY_N2 | Non Unique | Default | SHIPMENT_LINE_ID |
| RCV_SERIALS_SUPPLY_N4 | Non Unique | Default | SERIAL_NUM, SUPPLY_TYPE_CODE |