EGO_VERSIONS_BATCH_GT

This is a Global temporary table used by Version Batch Effectivation ESS PLSQL Preprocessing program to allocate phase number and thread numer to each version in the batch with same scheduled date. The data in this table is then used to update phase number and thread id in EGO_VERSIONS_B table

Details

• Schema: FUSION

• Object owner: EGO

• Object type: TABLE

• Tablespace: Default

Primary Key

Name	Columns
EGO_VERSIONS_BATCH_GT_PK	VERSION_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
VERSION_ID	NUMBER		18	Yes	Version ID from the EGO_VERSIONS_B table
INVENTORY_ITEM_ID	NUMBER		18	Yes	Inventory item id of the version's item
ORGANIZATION_ID	NUMBER		18	Yes	Inventory Organization id of the Item
STYLE_ITEM_FLAG	VARCHAR2	1			Flag indicating whether the item is a style item(Y), sku item (N) or standard item (null)
STYLE_ITEM_ID	NUMBER		18		If the item is a sku item, then its style item id otherwise null
MASTER_ORG_FLAG	VARCHAR2	1			Indicates whether the item's organization is a master(Y) or child (N)
PHASE_NUMBER	NUMBER		3		Phase Number in which this version will be effectivated within a single thread
THREAD_NUMBER	NUMBER		18		Thread Number in which this version will be effectivated

Indexes

Index	Uniqueness	Columns
EGO_VERSIONS_BATCH_GT_N1	Non Unique	INVENTORY_ITEM_ID
EGO_VERSIONS_BATCH_GT_U1	Unique	VERSION_ID