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_EOL_BOM_COMP_DS_V

Object Details

Object Name:	MSD_EOL_BOM_COMP_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.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
SR_INSTANCE_ID	VARCHAR2	(30)		Source Instance Identifier
DEMAND_PLAN_ID	NUMBER			EOL plan unique ID
SUPPLY_PLAN	VARCHAR2	(240)		Name of the supply plan
COMPONENT_PK	NUMBER		Yes	component identifier
ASSEMBLY_PK	NUMBER		Yes	assembly identifier
QUANTITY_PER	NUMBER			Usage percentage
LEAD_TIME	NUMBER			Lead Time
BOM_TYPE	VARCHAR2	(15)		Type of BOM

Query Text

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


SELECT SR_INSTANCE_ID
,      DEMAND_PLAN_ID
,      SUPPLY_PLAN
,      COMPONENT_PK
,      ASSEMBLY_PK
,      QUANTITY_PER
,      LEAD_TIME
,      BOM_TYPE
FROM APPS.MSD_EOL_BOM_COMP_DS_V;

Dependencies

[top of page]

APPS.MSD_EOL_BOM_COMP_DS_V references the following:

APPS: MSD_ASCP_BOM_COMP; MSD_DEMAND_PLANS; MSD_DP_PARAMETERS; MSD_DP_SESSION; MSD_LEVEL_VALUES_DS; MSD_SOP_COLLAPSED_BOM_COMP

APPS.MSD_EOL_BOM_COMP_DS_V is not referenced by any database object