VIEW: MSC.MSC_ITEM_SUBSTITUTES#

Source

View Text - Preformatted

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

View Text - HTML Formatted

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