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

VIEW: MSC.MSC_ITEM_SUBSTITUTES#

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

[View Source]

Columns
Name Datatype Length Mandatory Comments
PLAN_ID NUMBER
Yes
SR_INSTANCE_ID NUMBER
Yes
LOWER_ITEM_ID NUMBER
Yes
HIGHER_ITEM_ID NUMBER
Yes
HIGHEST_ITEM_ID NUMBER

CUSTOMER_ID NUMBER

CUSTOMER_SITE_ID NUMBER

EFFECTIVE_DATE DATE

DISABLE_DATE DATE

RELATIONSHIP_TYPE NUMBER
Yes
RECIPROCAL_FLAG NUMBER

SUBSTITUTION_SET VARCHAR2 (50) Yes
PARTIAL_FULFILLMENT_FLAG NUMBER
Yes
RANK NUMBER

USAGE_RATIO NUMBER

INFERRED_FLAG NUMBER

REFRESH_ID NUMBER

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

SUBSTITUTE_FLAG NUMBER

PRIME_ITEM_ID NUMBER

FORWARD_RULE NUMBER

NEW_PLAN_ID NUMBER

NEW_PLAN_LIST VARCHAR2 (256)
APPLIED NUMBER

SIMULATION_SET_ID NUMBER

Query Text

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


SELECT PLAN_ID
,      SR_INSTANCE_ID
,      LOWER_ITEM_ID
,      HIGHER_ITEM_ID
,      HIGHEST_ITEM_ID
,      CUSTOMER_ID
,      CUSTOMER_SITE_ID
,      EFFECTIVE_DATE
,      DISABLE_DATE
,      RELATIONSHIP_TYPE
,      RECIPROCAL_FLAG
,      SUBSTITUTION_SET
,      PARTIAL_FULFILLMENT_FLAG
,      RANK
,      USAGE_RATIO
,      INFERRED_FLAG
,      REFRESH_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
,      ORGANIZATION_ID
,      SUBSTITUTE_FLAG
,      PRIME_ITEM_ID
,      FORWARD_RULE
,      NEW_PLAN_ID
,      NEW_PLAN_LIST
,      APPLIED
,      SIMULATION_SET_ID
FROM MSC.MSC_ITEM_SUBSTITUTES#;

Dependencies

[top of page]

MSC.MSC_ITEM_SUBSTITUTES# references the following:

SchemaMSC
TableMSC_ITEM_SUBSTITUTES
MSC.MSC_ITEM_SUBSTITUTES# is referenced by following:

SchemaAPPS
SynonymMSC_ITEM_SUBSTITUTES