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

MATERIALIZED VIEW: APPS.MSD_DEM_SCN_ENTRIES_MV

Object Details
Object Name: MSD_DEM_SCN_ENTRIES_MV
Object Type: MATERIALIZED VIEW
Owner: APPS
Subobject Name:
Status: VALID
M-View Details
Container: MSD_DEM_SCN_ENTRIES_MV
Updatable: N
Rewrite Enabled: N
Rewrite Capability: NONE
Refresh Mode: DEMAND
Refresh Method: FORCE
Build Mode: IMMEDIATE
Fast Refreshable: NO
MV Log Dependencies:

MSC_DEMAND_CLASSES

[View Source Query]

Columns
Name Datatype Length Mandatory Comments
SCENARIO_ID NUMBER

SR_INSTANCE_ID NUMBER

ORGANIZATION_ID NUMBER

CUSTOMER_ID NUMBER

CUSTOMER_SITE_ID NUMBER

INVENTORY_ITEM_ID NUMBER

DEMAND_CLASS VARCHAR2 (30)
START_DATE DATE

CONSENSUS_FCST NUMBER

CONSENSUS_FCST_CUM NUMBER

PRIORITY NUMBER

PRICE NUMBER

Query Text

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


SELECT SCENARIO_ID
,      SR_INSTANCE_ID
,      ORGANIZATION_ID
,      CUSTOMER_ID
,      CUSTOMER_SITE_ID
,      INVENTORY_ITEM_ID
,      DEMAND_CLASS
,      START_DATE
,      CONSENSUS_FCST
,      CONSENSUS_FCST_CUM
,      PRIORITY
,      PRICE
FROM APPS.MSD_DEM_SCN_ENTRIES_MV;

Dependencies

[top of page]

APPS.MSD_DEM_SCN_ENTRIES_MV references the following:

SchemaAPPS
SynonymMSC_APPS_INSTANCES
SynonymMSC_DEMAND_CLASSES
SynonymMSC_SYSTEM_ITEMS
SynonymMSC_TRADING_PARTNERS
SynonymMSC_TRADING_PARTNER_SITES
PL/SQL PackageMSD_COMMON_UTILITIES - show dependent code
SynonymMSD_DEMAND_PLANS
TableMSD_DEM_SCN_ENTRIES_MV
ViewMSD_DP_ASCP_SCN_ENTRIES_V
SynonymMSD_DP_SCENARIOS
SynonymMSD_DP_SCENARIO_ENTRIES
SynonymMSD_DP_SCENARIO_REVISIONS
SynonymMSD_DP_SCN_ENTRIES_DENORM
SchemaMSC
TableMSC_APPS_INSTANCES
TableMSC_DEMAND_CLASSES
TableMSC_SYSTEM_ITEMS
TableMSC_TRADING_PARTNERS
TableMSC_TRADING_PARTNER_SITES
SchemaMSD
TableMSD_DEMAND_PLANS
TableMSD_DP_SCENARIOS
TableMSD_DP_SCENARIO_ENTRIES
TableMSD_DP_SCENARIO_REVISIONS
TableMSD_DP_SCN_ENTRIES_DENORM

APPS.MSD_DEM_SCN_ENTRIES_MV is not referenced by any database object