RCV_LOTS_SUPPLY
RCV_LOTS_SUPPLY stores information corresponding to the lot numbers and quantities that are available to be transacted for intransit shipments. . If you perform an intransit shipment between two organizations that are both under lot control, the receiving transaction processor maintains information about the lot numbers and quantities that you issued from the shipping organization. The Lot Entry and Serial Numbers forms use this information to ensure that the same lot numbers and lot quantities that were shipped are used when you deliver the items to stores. .
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 lot number that was either shipped (through ASN or in-transit shipment) or received. Possible values - SHIPMENT and RECEIVING. | |
JOB_DEFINITION_PACKAGE | VARCHAR2 | 900 | Enterprise Service Scheduler: indicates the package name 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. | ||
LOT_NUM | VARCHAR2 | 80 | Yes | Lot number that was shipped as part of the ASN line or the in-transit shipment line. | |
QUANTITY | NUMBER | Yes | This column stores the lot quantity in terms of the shipment line's unit of measure. | ||
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. | |
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. | ||
EXPIRATION_DATE | DATE | This column stores the Lot expiration date. | |||
PRIMARY_QUANTITY | NUMBER | Lot quantity in terms of the item's primary unit of measure. | |||
SECONDARY_QUANTITY | NUMBER | Lot quantity in terms of the item's secondary unit of measure. | |||
SUBLOT_NUM | VARCHAR2 | 32 | This column stores the sub-lot number. | ||
REASON_CODE | VARCHAR2 | 4 | This column identifies the inventory transaction reason code. | ||
REASON_ID | NUMBER | 18 | This column stores the inventory transaction reason unique identifier. | ||
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_LOTS_SUPPLY | rcv_shipment_lines | SHIPMENT_LINE_ID |
RCV_LOTS_SUPPLY | rcv_transactions | TRANSACTION_ID |
Indexes
Index | Uniqueness | Tablespace | Columns |
---|---|---|---|
RCV_LOTS_SUPPLY_N1 | Non Unique | Default | TRANSACTION_ID |
RCV_LOTS_SUPPLY_N2 | Non Unique | Default | SHIPMENT_LINE_ID |
RCV_LOTS_SUPPLY_N3 | Non Unique | Default | LOT_NUM |
RCV_LOTS_SUPPLY_N4 | Non Unique | Default | SUPPLY_TYPE_CODE, SHIPMENT_LINE_ID, LOT_NUM |
RCV_LOTS_SUPPLY_N5 | Non Unique | Default | SUPPLY_TYPE_CODE, TRANSACTION_ID, LOT_NUM |