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

MATERIALIZED VIEW: APPS.MSC_ATP_PLAN_SN

Object Details
Object Name: MSC_ATP_PLAN_SN
Object Type: MATERIALIZED VIEW
Owner: APPS
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: PREBUILT
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 APPS.MSC_ATP_PLAN_SN;

Dependencies

[top of page]

APPS.MSC_ATP_PLAN_SN references the following:

SchemaAPPS
TableMSC_ATP_PLAN_SN
SchemaMSC
TableMSC_APPS_INSTANCES
TableMSC_DESIGNATORS
TableMSC_PLANS
TableMSC_SYSTEM_ITEMS
TableMSC_TRADING_PARTNERS

APPS.MSC_ATP_PLAN_SN is not referenced by any database object