eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: MSC.MSC_BOM_COMPONENTS

Object Details

Object Name:	MSC_BOM_COMPONENTS
Object Type:	TABLE
Owner:	MSC
FND Design Data:	MSC.MSC_BOM_COMPONENTS
Subobject Name:
Status:	VALID

This table stores the components used in a bill of material created at source applications.
This table is also used to store bill of material information for production sequencing on the supply chain hub.

Storage Details

Tablespace:
PCT Free:
PCT Used:

Indexes

Index	Type	Uniqueness	Column
MSC_BOM_COMPONENTS_U1	NORMAL	UNIQUE	PLAN_ID SR_INSTANCE_ID BILL_SEQUENCE_ID COMPONENT_SEQUENCE_ID
MSC_BOM_COMPONENTS_N3	NORMAL	NONUNIQUE	PLAN_ID BILL_SEQUENCE_ID INVENTORY_ITEM_ID FROM_UNIT_NUMBER SR_INSTANCE_ID
MSC_BOM_COMPONENTS_N4	NORMAL	NONUNIQUE	PLAN_ID BILL_SEQUENCE_ID SR_INSTANCE_ID INVENTORY_ITEM_ID EFFECTIVITY_DATE FROM_UNIT_NUMBER
MSC_BOM_COMPONENTS_N5	NORMAL	NONUNIQUE	PLAN_ID SR_INSTANCE_ID INVENTORY_ITEM_ID ORGANIZATION_ID

Columns

Name	Datatype	Length	Mandatory	Comments
PLAN_ID	NUMBER		Yes	Plan identifier
COMPONENT_SEQUENCE_ID	NUMBER		Yes	Component identifier on the source application instance
BILL_SEQUENCE_ID	NUMBER		Yes	Identifier of the BOM
SR_INSTANCE_ID	NUMBER		Yes	Source application instance identifier
ORGANIZATION_ID	NUMBER		Yes	Organization identifier
INVENTORY_ITEM_ID	NUMBER		Yes	Identifier of the component item
USING_ASSEMBLY_ID	NUMBER			Identifier of the item being assembled
COMPONENT_TYPE	NUMBER			Component (1), Ingredient component (-1), by-product (2)
SCALING_TYPE	NUMBER			Scaling type
CHANGE_NOTICE	VARCHAR2	(10)		Code for ECO. Use for UI and reporting
REVISION	VARCHAR2	(3)		Inventory item revision code
UOM_CODE	VARCHAR2	(3)		Unit of measure code
USAGE_QUANTITY	NUMBER			Quantity of the component to build one unit of item
EFFECTIVITY_DATE	DATE			Date of effectivity for this component
DISABLE_DATE	DATE			End of effectivity
FROM_UNIT_NUMBER	VARCHAR2	(30)		Effective from this unit number
TO_UNIT_NUMBER	VARCHAR2	(30)		Effective up to this unit number
USE_UP_CODE	NUMBER			Yes/No flag - if yes this component is effective until the available quantity becomes null
SUGGESTED_EFFECTIVITY_DATE	DATE			Calculated use-up-date (if Use-up-code is yes)
DRIVING_ITEM_ID	NUMBER			Item which consumption determine the switch to this component
OPERATION_OFFSET_PERCENT	NUMBER			Operation offset percent
OPTIONAL_COMPONENT	NUMBER			Yes/No flag if optional use planning factor to determine demand
OLD_EFFECTIVITY_DATE	DATE			Old effectivity date
WIP_SUPPLY_TYPE	NUMBER			Used mainly for phantoms
PLANNING_FACTOR	NUMBER			Planning factor for this component (percent)
ATP_FLAG	NUMBER			Yes/No flag used for ATP
COMPONENT_YIELD_FACTOR	NUMBER		Yes	Factor used to multiply component quantity with to obtain component quantity
REFRESH_NUMBER	NUMBER			Refresh number populated by the collection program
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER		Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column
CREATED_BY	NUMBER		Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER			Standard Who column
REQUEST_ID	NUMBER			Concurrent Who column
PROGRAM_APPLICATION_ID	NUMBER			Concurrent Who column
PROGRAM_ID	NUMBER			Concurrent Who column
PROGRAM_UPDATE_DATE	DATE			Concurrent Who column
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive Flexfield structure defining column
ATTRIBUTE1	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE2	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE3	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE4	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE5	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE6	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE7	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE8	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE9	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE10	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE11	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE12	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE13	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE14	VARCHAR2	(150)		Descriptive Flexfield segment
ATTRIBUTE15	VARCHAR2	(150)		Descriptive Flexfield segment
SCALE_MULTIPLE	NUMBER			Scale Multiple
SCALE_ROUNDING_VARIANCE	NUMBER			Scale Rounding Variance
ROUNDING_DIRECTION	NUMBER			Rounding Direction
PRIMARY_FLAG	NUMBER			This Flag Indicates if this is a Primary Co-product in a Group.
CONTRIBUTE_TO_STEP_QTY	NUMBER			1 yes, 2 No. Indicates whether component contributes to step quantity calculations
OLD_COMPONENT_SEQUENCE_ID	NUMBER
OPERATION_SEQ_NUM	NUMBER

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT PLAN_ID
,      COMPONENT_SEQUENCE_ID
,      BILL_SEQUENCE_ID
,      SR_INSTANCE_ID
,      ORGANIZATION_ID
,      INVENTORY_ITEM_ID
,      USING_ASSEMBLY_ID
,      COMPONENT_TYPE
,      SCALING_TYPE
,      CHANGE_NOTICE
,      REVISION
,      UOM_CODE
,      USAGE_QUANTITY
,      EFFECTIVITY_DATE
,      DISABLE_DATE
,      FROM_UNIT_NUMBER
,      TO_UNIT_NUMBER
,      USE_UP_CODE
,      SUGGESTED_EFFECTIVITY_DATE
,      DRIVING_ITEM_ID
,      OPERATION_OFFSET_PERCENT
,      OPTIONAL_COMPONENT
,      OLD_EFFECTIVITY_DATE
,      WIP_SUPPLY_TYPE
,      PLANNING_FACTOR
,      ATP_FLAG
,      COMPONENT_YIELD_FACTOR
,      REFRESH_NUMBER
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      SCALE_MULTIPLE
,      SCALE_ROUNDING_VARIANCE
,      ROUNDING_DIRECTION
,      PRIMARY_FLAG
,      CONTRIBUTE_TO_STEP_QTY
,      OLD_COMPONENT_SEQUENCE_ID
,      OPERATION_SEQ_NUM
FROM MSC.MSC_BOM_COMPONENTS;

Dependencies

[top of page]

MSC.MSC_BOM_COMPONENTS does not reference any database object

MSC.MSC_BOM_COMPONENTS is referenced by following:

APPS: MSC_BOM_COMPONENTS