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

VIEW: APPS.MSD_SOP_BOM_COMP_DS_V

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


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


[View Source]

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

Demand Plan Id
SUPPLY_PLAN VARCHAR2 (240)
Designator name corresponding to ASCP custom stream .
COMPONENT_PK NUMBER
Yes Primary key for the component.
ASSEMBLY_PK NUMBER
Yes Primary Key for 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
,      ASSEMBLY_PK
,      EFFECTIVITY_DATE
,      DISABLE_DATE
,      QUANTITY_PER
,      LEAD_TIME
,      OPTIONAL_FLAG
,      RES_COMP
FROM APPS.MSD_SOP_BOM_COMP_DS_V;

Dependencies

[top of page]

APPS.MSD_SOP_BOM_COMP_DS_V references the following:

SchemaAPPS
SynonymMSD_ASCP_BOM_COMP
SynonymMSD_DEMAND_PLANS
SynonymMSD_DP_PARAMETERS
SynonymMSD_DP_SESSION
SynonymMSD_LEVEL_VALUES_DS
SynonymMSD_SOP_COLLAPSED_BOM_COMP

APPS.MSD_SOP_BOM_COMP_DS_V is not referenced by any database object