MSC_ITEM_SUBSTITUTES_V

Details

• Schema: FUSION

• Object owner: MSC

• Object type: VIEW

Columns

Name
PLAN_ID HIGHER_ITEM_ID LOWER_ITEM_ID RECIPROCAL_FLAG SUBSTITUTION_SET CUSTOMER_ID CUSTOMER_SITE_ID EFFECTIVE_DATE DISABLE_DATE RELATIONSHIP_TYPE PARTIAL_FULFILLMENT_FLAG USAGE_RATIO RANK ORGANIZATION_ID LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN CREATION_DATE CREATED_BY

Query

SQL_Statement

SELECT -1 PLAN_ID , rel.RELATED_ITEM_ID HIGHER_ITEM_ID , rel.INVENTORY_ITEM_ID LOWER_ITEM_ID , decode(RECIPROCAL_FLAG,'Y',1,2) RECIPROCAL_FLAG, NULL SUBSTITUTION_SET, NULL CUSTOMER_ID , NULL CUSTOMER_SITE_ID , rel.START_DATE_ACTIVE EFFECTIVE_DATE , rel.END_DATE_ACTIVE DISABLE_DATE , 2 RELATIONSHIP_TYPE , NULL PARTIAL_FULFILLMENT_FLAG, 1 USAGE_RATIO, to_number(rel.relateditem_rank) RANK, rel.organization_id, rel.LAST_UPDATE_DATE, rel.LAST_UPDATED_BY, rel.LAST_UPDATE_LOGIN, rel.CREATION_DATE, rel.CREATED_BY from EGP_ITEM_RELATIONSHIPS_B rel, msc_parameters mp where rel.item_relationship_type = 'RELATED_ITEM' and mp.organization_id (+) = rel.organization_id and rel.sub_type = 2 UNION ALL SELECT rel.PLAN_ID, rel.HIGHER_ITEM_ID, rel.LOWER_ITEM_ID, rel.RECIPROCAL_FLAG, rel.SUBSTITUTION_SET, rel.CUSTOMER_ID, rel.CUSTOMER_SITE_ID, rel.EFFECTIVE_DATE, rel.DISABLE_DATE, rel.RELATIONSHIP_TYPE, rel.PARTIAL_FULFILLMENT_FLAG, rel.USAGE_RATIO, rel.RANK, rel.ORGANIZATION_ID, rel.LAST_UPDATE_DATE, rel.LAST_UPDATED_BY, rel.LAST_UPDATE_LOGIN, rel.CREATION_DATE, rel.CREATED_BY from msc_item_substitutes rel, msc_apps_instances ins where rel.plan_id = -1