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]

VIEW: APPS.MSD_BOM_COMPONENTS_DS_V

Object Details

Object Name:	MSD_BOM_COMPONENTS_DS_V
Object Type:	VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

Thisstriped view provides Planning BOMs and its attributes information for demand planning

[View Source]

Columns

Name	Datatype	Length	Comments
DEMAND_PLAN_ID	NUMBER		Demand Plan Id
COMPONENT_PK	NUMBER		BOM Component PK
ASSEMBLY_PK	NUMBER		BOM Assembly Item Id
ORGANIZATION_PK	NUMBER		Identifier of Organization
PLANNING_FACTOR	NUMBER		BOM Planning Factor
QUANTITY_PER	NUMBER		Usage Quantity
EFFECTIVITY_DATE	DATE		BOM Effectivity Date
DISABLE_DATE	DATE		BOM Disable Date
LEAD_TIME	VARCHAR2	(0)	Lead Time
SPARE_PART	VARCHAR2	(0)	Spare Parts 'Y' or 'N'
OPTIONAL_FLAG	NUMBER		Optional Flag
ITEM_VLD_ORG_BOM_FLAG	VARCHAR2	(1)	Item Validtion Org BOM

Query Text

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


SELECT DEMAND_PLAN_ID
,      COMPONENT_PK
,      ASSEMBLY_PK
,      ORGANIZATION_PK
,      PLANNING_FACTOR
,      QUANTITY_PER
,      EFFECTIVITY_DATE
,      DISABLE_DATE
,      LEAD_TIME
,      SPARE_PART
,      OPTIONAL_FLAG
,      ITEM_VLD_ORG_BOM_FLAG
FROM APPS.MSD_BOM_COMPONENTS_DS_V;

Dependencies

[top of page]

APPS.MSD_BOM_COMPONENTS_DS_V references the following:

APPS: FND_PROFILE - show dependent code; MSC_APPS_INSTANCES; MSC_BOMS; MSC_BOM_COMPONENTS; MSC_SYSTEM_ITEMS; MSD_BOM_COMPONENTS; MSD_COMMON_UTILITIES - show dependent code; MSD_DP_SESSION; MSD_LEVEL_VALUES_DS
PUBLIC: DUAL

APPS.MSD_BOM_COMPONENTS_DS_V is not referenced by any database object