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

VIEW: APPS.MSC_ATP_PLAN_SN#

Object Details
Object Name: MSC_ATP_PLAN_SN#
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID

[View Source]

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
SynonymMSC_APPS_INSTANCES
SynonymMSC_DESIGNATORS
SynonymMSC_PLANS
SynonymMSC_SYSTEM_ITEMS
SynonymMSC_TRADING_PARTNERS

APPS.MSC_ATP_PLAN_SN# is not referenced by any database object