DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.MSD_BOM_COMPONENTS_V

Object Details
Object Name: MSD_BOM_COMPONENTS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewMSD.MSD_BOM_COMPONENTS_V
Subobject Name:
Status: VALID

View Type

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


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


[View Source]

Columns
Name Datatype Length Mandatory Comments
COMPONENT_PK NUMBER

BOM Component PK
COMPONENT VARCHAR2 (240)
BOM Component Name
ASSEMBLY_PK NUMBER

BOM Assembly Item Id
ASSEMBLY_NAME VARCHAR2 (240)
BOM Assembly Item Name
ORGANIZATION_PK NUMBER

Identifier of Organization
ORGANIZATION_NAME VARCHAR2 (240)
Organization Name
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 COMPONENT_PK
,      COMPONENT
,      ASSEMBLY_PK
,      ASSEMBLY_NAME
,      ORGANIZATION_PK
,      ORGANIZATION_NAME
,      PLANNING_FACTOR
,      QUANTITY_PER
,      EFFECTIVITY_DATE
,      DISABLE_DATE
,      LEAD_TIME
,      SPARE_PART
,      OPTIONAL_FLAG
,      ITEM_VLD_ORG_BOM_FLAG
FROM APPS.MSD_BOM_COMPONENTS_V;

Dependencies

[top of page]

APPS.MSD_BOM_COMPONENTS_V references the following:

SchemaAPPS
PL/SQL PackageFND_PROFILE - show dependent code
SynonymMSC_APPS_INSTANCES
SynonymMSC_BOMS
SynonymMSC_BOM_COMPONENTS
SynonymMSC_SYSTEM_ITEMS
SynonymMSD_BOM_COMPONENTS
PL/SQL PackageMSD_COMMON_UTILITIES - show dependent code
SynonymMSD_LEVEL_VALUES
SchemaPUBLIC
SynonymDUAL

APPS.MSD_BOM_COMPONENTS_V is not referenced by any database object