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

MATERIALIZED VIEW: MSC.MSC_ATP_PLAN_SN

Object Details
Object Name: MSC_ATP_PLAN_SN
Object Type: MATERIALIZED VIEW
Owner: MSC
Subobject Name:
Status: VALID
M-View Details
Container: MSC_ATP_PLAN_SN
Updatable: N
Rewrite Enabled: N
Rewrite Capability: GENERAL
Refresh Mode: DEMAND
Refresh Method: COMPLETE
Build Mode: IMMEDIATE
Fast Refreshable: DIRLOAD_DML
MV Log Dependencies:

MSC_APPS_INSTANCES
MSC_DESIGNATORS
MSC_PLANS
MSC_SYSTEM_ITEMS
MSC_TRADING_PARTNERS

[View Source Query]

Columns
Name Datatype Length Mandatory Comments
PLAN_ID NUMBER
Yes
SR_INVENTORY_ITEM_ID NUMBER

ORGANIZATION_ID NUMBER
Yes
SR_INSTANCE_ID NUMBER
Yes
COMPLETION_DATE DATE

DEMAND_CLASS VARCHAR2 (34)
RANK NUMBER

Query Text

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


SELECT PLAN_ID
,      SR_INVENTORY_ITEM_ID
,      ORGANIZATION_ID
,      SR_INSTANCE_ID
,      COMPLETION_DATE
,      DEMAND_CLASS
,      RANK
FROM MSC.MSC_ATP_PLAN_SN;

Dependencies

[top of page]

MSC.MSC_ATP_PLAN_SN references the following:

SchemaMSC
TableMSC_APPS_INSTANCES
TableMSC_ATP_PLAN_SN
TableMSC_DESIGNATORS
TableMSC_PLANS
TableMSC_SYSTEM_ITEMS
TableMSC_TRADING_PARTNERS

MSC.MSC_ATP_PLAN_SN is not referenced by any database object