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