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

VIEW: MSC.MSC_PLAN_CONSTRAINTS#

Object Details
Object Name: MSC_PLAN_CONSTRAINTS#
Object Type: VIEW
Owner: MSC
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
CONSTRAINT_ID NUMBER
Yes
PLAN_ID NUMBER
Yes
DEMAND_ID NUMBER
Yes
CONSTRAINT_TYPE NUMBER

MATERIAL_CONSTRAINT_TYPE NUMBER

INVENTORY_ITEM_ID NUMBER

ORGANIZATION_ID NUMBER

SR_INSTANCE_ID NUMBER

DEPARTMENT_ID NUMBER

RESOURCE_ID NUMBER

OPERATION_SEQ_NUM NUMBER

RESOURCE_SEQ_NUM NUMBER

ROUTING_ID NUMBER

SUPPLIER_ID NUMBER

SUPPLIER_SITE_ID NUMBER

REQUIRED_QUANTITY NUMBER

PROMISED_QUANTITY NUMBER

REQUIRED_DATE DATE

BUFFER_LEVEL NUMBER

LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER
Yes
CREATION_DATE DATE
Yes
CREATED_BY NUMBER
Yes
LAST_UPDATE_LOGIN NUMBER

SOURCE_ORGANIZATION_ID NUMBER

SOURCE_INSTANCE_ID NUMBER

SHIP_METHOD VARCHAR2 (4000)
EXHAUSTIVE_CONSTRAINT_FLAG NUMBER

EARLIEST_AVAILABLE_DATE DATE

SEARCH_PATH NUMBER

Query Text

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


SELECT CONSTRAINT_ID
,      PLAN_ID
,      DEMAND_ID
,      CONSTRAINT_TYPE
,      MATERIAL_CONSTRAINT_TYPE
,      INVENTORY_ITEM_ID
,      ORGANIZATION_ID
,      SR_INSTANCE_ID
,      DEPARTMENT_ID
,      RESOURCE_ID
,      OPERATION_SEQ_NUM
,      RESOURCE_SEQ_NUM
,      ROUTING_ID
,      SUPPLIER_ID
,      SUPPLIER_SITE_ID
,      REQUIRED_QUANTITY
,      PROMISED_QUANTITY
,      REQUIRED_DATE
,      BUFFER_LEVEL
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      SOURCE_ORGANIZATION_ID
,      SOURCE_INSTANCE_ID
,      SHIP_METHOD
,      EXHAUSTIVE_CONSTRAINT_FLAG
,      EARLIEST_AVAILABLE_DATE
,      SEARCH_PATH
FROM MSC.MSC_PLAN_CONSTRAINTS#;

Dependencies

[top of page]

MSC.MSC_PLAN_CONSTRAINTS# references the following:

SchemaMSC
TableMSC_PLAN_CONSTRAINTS
MSC.MSC_PLAN_CONSTRAINTS# is referenced by following:

SchemaAPPS
SynonymMSC_PLAN_CONSTRAINTS