INV_ITEM_LOC_DEFAULTS

INV_ITEM_LOC_DEFAULTS contains the optional default subinventories and locators for inventory transaction purposes. The LOCATOR_ID and SUBINVENTORY_CODE identify the exact locator/subinventory which one wishes to have as default.

Details

• Schema: FUSION

• Object owner: INV

• Object type: TABLE

• Tablespace: APPS_TS_TX_DATA

Primary Key

Name	Columns
INV_ITEM_LOC_DEFAULTS_PK	TRANSACTION_DEFAULTS_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
TRANSACTION_DEFAULTS_ID	NUMBER		18	Yes	Primary key of the optional default locator.
SUB_DEFAULT	VARCHAR2	11		Yes	This identifies both Subinventory and Locator defaults. It will be populated with 11 zeroes for Subinventory defaults and Subinventory code for Locator defaults.
INVENTORY_ITEM_ID	NUMBER		18	Yes	This identifies the inventory item.
ORGANIZATION_ID	NUMBER		18	Yes	This identifies the inventory organization.
LOCATOR_ID	NUMBER		18	Yes	This identifies the item locator.
DEFAULT_TYPE	VARCHAR2	30		Yes	Code indicates the default type.
SUBINVENTORY_CODE	VARCHAR2	10		Yes	This is name of the subinventory.
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.
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.
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
INV_ITEM_LOC_DEFAULTS	egp_item_org_associations	INVENTORY_ITEM_ID, ORGANIZATION_ID
INV_ITEM_LOC_DEFAULTS	inv_item_locations	LOCATOR_ID
INV_ITEM_LOC_DEFAULTS	inv_secondary_inventories	SUBINVENTORY_CODE, ORGANIZATION_ID

Indexes

Index	Uniqueness	Tablespace	Columns	Status
INV_ITEM_LOC_DEFAULTS_N1	Non Unique	Default	ORGANIZATION_ID, INVENTORY_ITEM_ID, DEFAULT_TYPE, SUBINVENTORY_CODE	Obsolete
INV_ITEM_LOC_DEFAULTS_PK	Unique	Default	TRANSACTION_DEFAULTS_ID
INV_ITEM_LOC_DEFAULTS_U1	Unique	Default	ORGANIZATION_ID, INVENTORY_ITEM_ID, LOCATOR_ID, DEFAULT_TYPE, SUBINVENTORY_CODE	Obsolete
INV_ITEM_LOC_DEFAULTS_U2	Unique	Default	ORGANIZATION_ID, INVENTORY_ITEM_ID, DEFAULT_TYPE, SUB_DEFAULT