[Home] [Help] [Dependency Information]
Object Name: | MSD_BOM_COMPONENTS_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.
Thisstriped view provides Planning BOMs and its attributes information for demand planning
Name | Datatype | Length | Mandatory | 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 |
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;
APPS.MSD_BOM_COMPONENTS_DS_V is not referenced by any database object
|
|
|