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_BOD_INTERFACE

Object Details

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

MSC_BOM_BOD_INTERFACE stages the BOM and sourcing rules uploaded on supply chain
exchange prior to validation. This information is required to support production sequencing
functionality on supply chain hub. After validation the data is moved to MSC_BOM_COMPONENTS and MSC_ITEM_SOURCING.

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
BOM_BOD_ID	NUMBER			Generated by the sequence MSC_BOM_BOD_INTF_S
PLAN_ID	NUMBER			Contains the plan identifier
SR_INSTANCE_ID	NUMBER			Contains the source instance identifier, defaulted to -1
PARTY_ID	NUMBER			Contains the party identifier of the publisher
ASSEMBLY_ITEM_ID	NUMBER			Contains the assembly item identifier
ASSEMBLY_ITEM_NAME	VARCHAR2	(250)	Yes	Contains the assembly item name
ASSEMBLY_ITEM_UOM	VARCHAR2	(3)	Yes	Contains the unit of measure of the assembly item
INVENTORY_ITEM_ID	NUMBER			Contains the inventory item identifier
INVENTORY_ITEM_NAME	VARCHAR2	(250)	Yes	Contains the inventory item name
INVENTORY_ITEM_UOM	VARCHAR2	(3)	Yes	Contains the unit of measure of the inventory item
USAGE_QUANTITY	NUMBER		Yes	Contains the quantity being used
BOM_EFFECTIVITY_DATE	DATE			Contains the date the BOM becomes effective
BOM_DISABLE_DATE	DATE			Contains the date BOM is disabled
SUPPLIER_ID	NUMBER			Contains the party identifier of the supplier
SUPPLIER_NAME	VARCHAR2	(255)		Contains the supplier's name
AVG_TRANSIT_LEAD_TIME	NUMBER			Contains the average intransit lead time
SOURCING_EFFECTIVITY_DATE	DATE			Contains the date the sourcing rule becomes effective
SOURCING_DISABLE_DATE	DATE			Contains the date the sourcing rule is disabled
LAST_UPDATE_DATE	DATE			Contains the date the record was last updated
LAST_UPDATED_BY	NUMBER			Contains the use identifier of the person who last updated the record
CREATION_DATE	DATE			Contains the date the record was created
CREATED_BY	NUMBER			Contains the user identifier of the person who created the record
ROW_STATUS	NUMBER			Contains the row status after the validation
ERROR_MSG	VARCHAR2	(240)		Contains the error message in case the record fails validation
BATCH_ID	NUMBER			Holds the batch identifier

Query Text

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


SELECT BOM_BOD_ID
,      PLAN_ID
,      SR_INSTANCE_ID
,      PARTY_ID
,      ASSEMBLY_ITEM_ID
,      ASSEMBLY_ITEM_NAME
,      ASSEMBLY_ITEM_UOM
,      INVENTORY_ITEM_ID
,      INVENTORY_ITEM_NAME
,      INVENTORY_ITEM_UOM
,      USAGE_QUANTITY
,      BOM_EFFECTIVITY_DATE
,      BOM_DISABLE_DATE
,      SUPPLIER_ID
,      SUPPLIER_NAME
,      AVG_TRANSIT_LEAD_TIME
,      SOURCING_EFFECTIVITY_DATE
,      SOURCING_DISABLE_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      ROW_STATUS
,      ERROR_MSG
,      BATCH_ID
FROM MSC.MSC_BOM_BOD_INTERFACE;

Dependencies

[top of page]

MSC.MSC_BOM_BOD_INTERFACE does not reference any database object

MSC.MSC_BOM_BOD_INTERFACE is referenced by following:

APPS: MSC_BOM_BOD_INTERFACE