MSC_WD_OPERATION_MATERIALS
This is Replica table for work defintion operations
Details
-
Schema: FUSION
-
Object owner: MSC
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
MSC_WD_OPERATION_MATERIALS_PK |
COMPONENT_SEQUENCE_ID, ORGANIZATION_ID, ASSEMBLY_ITEM_ID, EFFECTIVE_FROM_DATE, PART_KEY1 |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| SR_WD_OPERATION_MATERIAL_ID | NUMBER | 18 | This is the internal ID of the work definition operation material. | ||
| COMPONENT_SEQUENCE_ID | NUMBER | 18 | Yes | The Bill Of Material Component Sequence Identifier. | |
| PLANNING_FACTOR | NUMBER | Planning factor for this component (percent). | |||
| MATERIAL_SEQ_NUMBER | NUMBER | Indicates the sequence of this material line within this operation. | |||
| MATERIAL_TYPE | VARCHAR2 | 30 | Yes | Values: - PRIMARY_PRODUCT (post R11) - INPUT_MATERIAL - INDIRECT_MATERIAL - BY_PRODUCT (post R11) - CO_PRODUCT (post R11) This will need to be revisited to align with the way PIM is going to implement these different material types in Item Structure | |
| MATERIAL_QUANTITY | NUMBER | Yes | This is the quantity required to produce one unit of finished goods. | ||
| UOM_CODE | VARCHAR2 | 3 | Yes | Unit of measure code of the work definition operation materials. | |
| YIELD_FACTOR | NUMBER | Yes | This is the percentage of material quantity actually incorporated into the finished good. | ||
| BASIS_TYPE | NUMBER | Indicates whether the item quantity is fixed (e.g., quantity per lot produced) or variable (e.g., quantity per item produced). Values are contained within the EGP_BOM_BASIS_TYPE lookup: - 1 ??? Item - 2- Lot | |||
| SUPPLY_TYPE | NUMBER | Yes | Indicates the supply type code. Values are contained within the EGP_WIP_SUP_TYPE lookup: - 1 Push - 2 Assembly pull - 3 Operation pull - 4 Bulk - 5 Supplier - 6 Phantom | ||
| ITEM_STRUCT_COMPONENT_REF_FLAG | VARCHAR2 | 1 | Yes | Indicates whether this material line refers to an existing component in the associated Item Structure. If this is 'Y' then generate new component_sequence_id. | |
| SR_WORK_DEFINITION_ID | NUMBER | 18 | Source side value of the work definition identifier. | ||
| WORK_DEFINITION_CODE | VARCHAR2 | 30 | Yes | Indicates the user defined work definition code | |
| EFFECTIVE_FROM_DATE | DATE | Yes | Indicate the date from which this operation is effective | ||
| OPTIONAL | NUMBER | Yes/No flag if optional use planning factor to determine demand | |||
| EFFECTIVE_TO_DATE | DATE | Indicate the date from which this operation is no longer effective | |||
| CHECK_ATP | NUMBER | Flag indicating if ATP check is required | |||
| COMPONENT_TYPE | NUMBER | Component (1), Ingredient component (-1), by-product (2) | |||
| OPERATION_OFFSET_PERCENT | NUMBER | This value indicates Operation offset percent. | |||
| REVISION | VARCHAR2 | 3 | Inventory item revision code for the BOM component. | ||
| ROUNDING_DIRECTION | NUMBER | Rounding direction for work definition or a bom/IS component. | |||
| SR_WD_OPERATION_ID | NUMBER | 18 | Reference to the operation to which this material line is assigned (used to join to MSC_ROUTING_OPERATIONS.operation_sequence_id) User key: org code, WD code, item name, operation sequence number, effective from date | ||
| OPERATION_SEQ_NUMBER | NUMBER | Yes | Operation sequence number as defined for the operation in WIS_WD_OPERATIONS_B. | ||
| SR_COMPONENT_SEQUENCE_ID | NUMBER | 18 | Source side value of the component sequence identifier. | ||
| ORGANIZATION_ID | NUMBER | 18 | Yes | Indicates the organization where the item is defined for this ad hoc material line | |
| INVENTORY_ITEM_ID | NUMBER | 18 | Yes | Indicates the id of the item for this ad hoc material line | |
| ASSEMBLY_ITEM_ID | NUMBER | 18 | Yes | Item identifier of the assembly. | |
| ASSEMBLY_BOM_ITEM_TYPE | NUMBER | bom item type for assembly item id | |||
| COMPONENT_SEQUENCE_ID_PATH | VARCHAR2 | 3000 | Contains the lineage key of this component in the ATO Model Item Structure. This attribute refers to EGP_EXPLOSIONS_V.COMP_SEQ_PATH. It is used to uniquely identify this component in the exploded ATO Model item structure . | ||
| OPERATION_SEQUENCE_ID | NUMBER | Reference to the operation to which the routing is assigned. | |||
| DELETED_FLAG | NUMBER | 1 | Logical deletion is done on this table; deleted_flag=1 means deleted record | ||
| PART_KEY1 | NUMBER | 18 | Yes | This column is used to partition the table. It is used for collections internal usage | |
| REFRESH_NUMBER | NUMBER | 18 | Refresh identifier populated by the collection program. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of 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. | ||
| FIND_NUMBER | NUMBER | This is analogous to Operation sequence number in Product Information Management Cloud. When a same component is assigned to an assembly multiple times with same effectivity, Find Number value is used to uniquely identify each occurrence of the component. | |||
| CONFIG_ITEM_FLAG | NUMBER | Flag to Indicate that the item is a configured Item. | |||
| LINE_OP_SEQ_NUMBER | NUMBER | Indicates the production line operation sequence number. | |||
| CONTRIBUTE_TO_YIELD | NUMBER | 1 | Identifier to indicate if this component should contribute to yield calculation in the manufacturing process. | ||
| WORK_DEF_USAGE_QUANTITY | NUMBER | This is the total usage quantity for the component to produce all the units of primary product, as defined on the work definition. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| MSC_WD_OPERATION_MATERIALS | msc_work_definitions | ORGANIZATION_ID, ASSEMBLY_ITEM_ID, WORK_DEFINITION_CODE, PART_KEY1 |
Indexes
| Index | Uniqueness | Tablespace | Columns | Status |
|---|---|---|---|---|
| MSC_WD_OPERATION_MATERIALS_U1 | Unique | Default | ORGANIZATION_ID, ASSEMBLY_ITEM_ID, WORK_DEFINITION_CODE, OPERATION_SEQ_NUMBER, INVENTORY_ITEM_ID, EFFECTIVE_FROM_DATE, PART_KEY1 | Obsolete |
| MSC_WD_OPERATION_MATERIALS_U2 | Unique | Default | ORGANIZATION_ID, ASSEMBLY_ITEM_ID, WORK_DEFINITION_CODE, OPERATION_SEQ_NUMBER, INVENTORY_ITEM_ID, EFFECTIVE_FROM_DATE | Obsolete |
| MSC_WD_OPERATION_MATERIALS_U3 | Unique | Default | ORGANIZATION_ID, ASSEMBLY_ITEM_ID, WORK_DEFINITION_CODE, OPERATION_SEQ_NUMBER, INVENTORY_ITEM_ID, EFFECTIVE_FROM_DATE, FIND_NUMBER, PART_KEY1 | |
| MSC_WD_OPERATION_MATERIALS_U4 | Unique | Default | COMPONENT_SEQUENCE_ID, ORGANIZATION_ID, ASSEMBLY_ITEM_ID, EFFECTIVE_FROM_DATE, PART_KEY1 |