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


TABLE: APPS.MSD_DEM_SCN_ENTRIES_MV

Object Details
Object Name: MSD_DEM_SCN_ENTRIES_MV
Object Type: TABLE
Owner: APPS
FND Design Data: TableFND.MSD_DEM_SCN_ENTRIES_MV
Subobject Name:
Status: VALID
Storage Details
Tablespace: TablespaceAPPS_TS_SUMMARY
PCT Free: 10
PCT Used:
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 does not reference any database object

APPS.MSD_DEM_SCN_ENTRIES_MV is referenced by following:

SchemaAPPS
Materialized ViewMSD_DEM_SCN_ENTRIES_MV