CTO_MATCH_LINES

Details

Schema: FUSION
Object owner: FUSION
Object type: TABLE
Tablespace: FUSION_TS_TX_DATA

Primary Key

Name	Columns
CTO_MATCH_LINES_EXPL_PK	LINE_EXPL_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
LINE_ID	NUMBER		18	Yes	Unique identifier assigned to the Match Detail record entry.
HEADER_ID	NUMBER		18	Yes	The related match header entry for the top level ATO.
SUB_ITEM_TYPE	NUMBER		18		Type of item, ie; model, option class or standard item.
INVENTORY_ITEM_ID	NUMBER		18		Inventory Item identifier assigned to the model or option class or standard item.
CONFIG_ITEM_ID	NUMBER		18		Identifier of the item being assembled.
PARENT_LINE_ID	NUMBER		18		The Line Identifier representing the immediate parent item for the component.
UNIT_QTY	NUMBER				The required quantity to make 1 unit of the top level assembly.
UNIT_UOM	VARCHAR2	3			Unit of measure for the quantity specified.
LINKED_ATO_LINE_ID	NUMBER		18		The associated child ATO identifier from the match lines table.
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.
BASE_MODEL_ID	NUMBER		18		The inventory item id for the ATO model from which the configured item options were selected.
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.
COMPONENT_SEQUENCE_ID	NUMBER		18		Foreign key identifier to the egp components table, representing the component item in the Item Structure.
ROOT_PHANTOM_ITEM_ID	NUMBER		18		Phantom subassembly item identifier. This value is populated for all the components exploded based on a phantom subassembly.
ORGANIZATION_ID	NUMBER		18		Identifier for the organization under which the item structure is defined.
BILL_SEQUENCE_ID	NUMBER		18		Foreign key identifier to the egp structures table, representing the component item in the Item Structure.
LINE_EXPL_ID	NUMBER		18	Yes	Primary Key Column, Unique identifier for the explosion record.
EFFECTIVITY_DATE	DATE				Configured item creation date from match repository or component effectivity date from the egp.
INVENTORY_ITEM_PATH	VARCHAR2	4000			Path representing the item hierarchy for the inventory item
WIP_SUPPLY_TYPE	NUMBER		18		Attribute indicating the supply type for the component item.
COMP_SEQ_PATH	VARCHAR2	4000			Path representing the component sequence hierarchy
PARENT_INVENTORY_ITEM_ID	NUMBER		18		Inventory item identifier representing the immediate parent item for the component.
ONE_TIME_CONFIG_FLAG	VARCHAR2	1			Contains Y or N. Y: Fulfill the item as a one-time configuration. N: Don't fulfill the item as a one-time configuration
CONFIG_ITEM_VERSION	NUMBER		9		Number that identifies the version of a one-time configured item

Indexes

Index	Uniqueness	Tablespace	Columns	Status
CTO_MATCH_LINES_EXPL_N1	Non Unique	FUSION_TS_TX_IDX	CONFIG_ITEM_ID	Obsolete
CTO_MATCH_LINES_EXPL_N2	Non Unique	FUSION_TS_TX_IDX	LINE_ID, PARENT_LINE_ID, ORGANIZATION_ID
CTO_MATCH_LINES_EXPL_N3	Non Unique	FUSION_TS_TX_IDX	COMPONENT_SEQUENCE_ID
CTO_MATCH_LINES_EXPL_N4	Non Unique	FUSION_TS_TX_IDX	PARENT_LINE_ID, HEADER_ID
CTO_MATCH_LINES_EXPL_N5	Non Unique	FUSION_TS_TX_IDX	EFFECTIVITY_DATE
CTO_MATCH_LINES_EXPL_N6	Non Unique	FUSION_TS_TX_IDX	CONFIG_ITEM_ID, ORGANIZATION_ID
CTO_MATCH_LINES_EXPL_U1	Unique	FUSION_TS_TX_IDX	LINE_EXPL_ID