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

VIEW: APPS.MSD_SOP_BOM_COMP_V

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


This view is obsolete. This view provides the global collapsed bom comp for a SOP plan.


[View Source]

Columns
Name Datatype Length Mandatory Comments
SR_INSTANCE_ID VARCHAR2 (30)
The source instance ID.
DEMAND_PLAN_ID NUMBER

SOP Plan unique ID.
SUPPLY_PLAN VARCHAR2 (240)
Designator name corresponding to ASCP custom stream .
COMPONENT_PK NUMBER
Yes Primary key for the component.
COMPONENT VARCHAR2 (240) Yes Name of the component.
ASSEMBLY_PK NUMBER
Yes Primary key for the assembly.
ASSEMBLY_NAME VARCHAR2 (240) Yes Name of the assembly.
EFFECTIVITY_DATE DATE

Effective date for collapse bom structure.
DISABLE_DATE DATE

Disable date for Collapse bom structure.
QUANTITY_PER NUMBER

Capacity or usage ratio.
LEAD_TIME NUMBER

Lead Time
OPTIONAL_FLAG CHAR (1)
Optional flag.
RES_COMP VARCHAR2 (240)
Flag to denote whether is is resource or component I- Item , R- Resource , L-Flow Resource.
Query Text

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


SELECT SR_INSTANCE_ID
,      DEMAND_PLAN_ID
,      SUPPLY_PLAN
,      COMPONENT_PK
,      COMPONENT
,      ASSEMBLY_PK
,      ASSEMBLY_NAME
,      EFFECTIVITY_DATE
,      DISABLE_DATE
,      QUANTITY_PER
,      LEAD_TIME
,      OPTIONAL_FLAG
,      RES_COMP
FROM APPS.MSD_SOP_BOM_COMP_V;

Dependencies

[top of page]

APPS.MSD_SOP_BOM_COMP_V references the following:

SchemaAPPS
SynonymMSD_ASCP_BOM_COMP
SynonymMSD_DEMAND_PLANS
SynonymMSD_DP_PARAMETERS
SynonymMSD_LEVEL_VALUES
SynonymMSD_SOP_COLLAPSED_BOM_COMP

APPS.MSD_SOP_BOM_COMP_V is not referenced by any database object