[Home] [Help]
[Dependency Information]
Object Name: | MSC_ITEM_SUBSTITUTES |
---|---|
Object Type: | TABLE |
Owner: | MSC |
FND Design Data: | ![]() |
Subobject Name: | |
Status: | VALID |
This table stores all the Relationships between Item Substitutes for planning.
Tablespace: | ![]() |
---|---|
PCT Free: | |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
MSC_ITEM_SUBSTITUTES_N1 | NORMAL | NONUNIQUE |
![]() |
![]() ![]() ![]() ![]() |
MSC_ITEM_SUBSTITUTES_N2 | NORMAL | NONUNIQUE |
![]() |
![]() ![]() ![]() ![]() ![]() |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PLAN_ID | NUMBER | Yes | Plan identifier | |
SR_INSTANCE_ID | NUMBER | Yes | Instance Id of the destination organzation | |
LOWER_ITEM_ID | NUMBER | Yes | Item identifier generated by the collection program from Staging tables to ODS | |
HIGHER_ITEM_ID | NUMBER | Yes | Item identifier generated by the collection program from Staging tables to ODS | |
HIGHEST_ITEM_ID | NUMBER | Highest Item Id | ||
CUSTOMER_ID | NUMBER | Unique Partner identifier generated by the collection program from Staging tables to ODS | ||
CUSTOMER_SITE_ID | NUMBER | Unique Partnersite identifier generated by the collection program from Staging tables to ODS | ||
EFFECTIVE_DATE | DATE | Effective Date of the Item Relationship | ||
DISABLE_DATE | DATE | Disable Date of the Item Relationship | ||
RELATIONSHIP_TYPE | NUMBER | Yes | Type of Relationship between the Items | |
RECIPROCAL_FLAG | NUMBER | Reciprocal Flag | ||
SUBSTITUTION_SET | VARCHAR2 | (50) | Yes | Substitution set name used to define the Item relationship |
PARTIAL_FULFILLMENT_FLAG | NUMBER | Yes | Partial Fulfillment Flag | |
RANK | NUMBER | Rank | ||
USAGE_RATIO | NUMBER | Usage Ratio | ||
INFERRED_FLAG | NUMBER | Inferred Flag | ||
REFRESH_ID | NUMBER | Refresh Id | ||
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATED_BY | NUMBER | Yes | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | Yes | Standard Who column | |
CREATION_DATE | DATE | Yes | Standard Who column | |
CREATED_BY | NUMBER | Yes | Standard Who column | |
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 |
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;
MSC.MSC_ITEM_SUBSTITUTES does not reference any database object
MSC.MSC_ITEM_SUBSTITUTES is referenced by following:
|
|
|