INV_LOT_ITEM_CONTROLS

This table stores the auto lot prefix and start auti lot number from the EGP_ITEM_ORG_ASSOCIATIONS table for lot items for which user setup is at the item level, i.e., the item level settings will be used to generate auto lot numbers. It also stores the next auto lot number to be used by the auto lot generation process.

Details

• Schema: FUSION

• Object owner: INV

• Object type: TABLE

• Tablespace: FUSION_TX_TS_DATA

Primary Key

Name	Columns
INV_LOT_ITEM_CONTROLS_PK	INVENTORY_ITEM_ID, ORGANIZATION_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments	Status
INVENTORY_ITEM_ID	NUMBER		18	Yes	This identifies the lot inventory item.
ORGANIZATION_ID	NUMBER		18	Yes	This identifies the lot item organization.
AUTO_LOT_ALPHA_PREFIX	VARCHAR2	80			Stores the user defined lot number prefix from table EGP_ITEM_ORG_ASSOCIATIONS
START_AUTO_LOT_NUMBER	VARCHAR2	80			Stores the user defined start lot number from table EGP_ITEM_ORG_ASSOCIATIONS
NEXT_AUTO_LOT_NUMBER	VARCHAR2	80			Stores the system generated next lot number to be used
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.	Active
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.	Active
LAST_UPDATE_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of the row.	Active
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated the row.	Active
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.	Active

Foreign Keys

Table	Foreign Table	Foreign Key Column
INV_LOT_ITEM_CONTROLS	egp_item_org_associations	INVENTORY_ITEM_ID, ORGANIZATION_ID

Indexes

Index	Uniqueness	Tablespace	Columns
INV_LOT_ITEM_CONTROLS_N1	Non Unique	FUSION_TS_TX_IDX	AUTO_LOT_ALPHA_PREFIX, START_AUTO_LOT_NUMBER
INV_LOT_ITEM_CONTROLS_U1	Unique	FUSION_TS_TX_IDX	INVENTORY_ITEM_ID, ORGANIZATION_ID