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.

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