CTO_MATCH_LINES_EXPL
Table for holding the exploded version of entries in the match lines table, also contains records for mandatory and phantoms.
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. |
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 |