MSC_AP_ITEM_SUBSTITUTES_V

Details

• Schema: FUSION

• Object owner: FUSION

• Object type: VIEW

Columns

Name
INVENTORY_ITEM_ID LOWER_ITEM_NAME RELATED_ITEM_ID HIGHER_ITEM_NAME START_DATE_ACTIVE END_DATE_ACTIVE SUB_TYPE RECIPROCAL_FLAG PLANNING_ENABLED_FLAG ORG_INDEPENDENT_FLAG RELATIONSHIP_DESC ORGANIZATION_CODE ORGANIZATION_ID RANK ROW_ID ITEM_RELATIONSHIP_ID

Query

SQL_Statement

SELECT erel.inventory_item_id , egp_item_low.item_number lower_item_name , erel.related_item_id , egp_item_high.item_number higher_item_name , erel.start_date_active , erel.end_date_active , erel.sub_type , erel.reciprocal_flag , DECODE(erel.planning_enabled_flag,'Y',1,'N',2,null) planning_enabled_flag , DECODE(erel.org_independent_flag,'N',2,1) org_independent_flag , erel.description relationship_desc , egp_item_low.organization_code , erel.organization_id , erel.relationship_rank rank , erel.rowid row_id , erel.item_relationship_id FROM EGP_ITEM_RELATIONSHIPS_VL erel, MSC_PLANNED_EGP_SYSTEM_ITEMS egp_item_low, MSC_PLANNED_EGP_SYSTEM_ITEMS egp_item_high WHERE erel.item_relationship_type = 'RELATED_ITEM' AND EREL.SUB_TYPE IN ('2','8','18') AND TRUNC(NVL(erel.end_date_active, SYSDATE-30)) >= TRUNC(SYSDATE-30) AND egp_item_low.inventory_item_id = erel.inventory_item_id AND egp_item_low.organization_id = erel.organization_id AND egp_item_high.inventory_item_id = erel.related_item_id AND egp_item_high.organization_id = erel.organization_id