[Home] [Help] [Dependency Information]
Object Name: | MSD_EOL_BOM_COMP_DS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
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 |
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;
APPS.MSD_EOL_BOM_COMP_DS_V is not referenced by any database object
|
|
|