DECLARE 
    finalstr  VARCHAR2(5000); 
    dfinalstr VARCHAR2(5000); 
BEGIN 
    finalstr := 'WHERE 1=1'; 

    IF :HOPE_FORECAST_CONTROL.ORG_CODE IS NOT NULL THEN 
      finalstr := finalstr || 'AND ORGANIZATION_CODE =' ||( ':HOPE_FORECAST_CONTROL.ORG_CODE' ); 
    END IF; 

    IF :HOPE_FORECAST_CONTROL.FISCAL_YEAR IS NOT NULL THEN 
      finalstr := finalstr || 'AND FISCAL_YEAR =' || ( ':HOPE_FORECAST_CONTROL.FISCAL_YEAR' ); 
    END IF; 

    IF :HOPE_FORECAST_CONTROL.ITEM_NUMBER IS NOT NULL THEN 
      finalstr := finalstr || 'AND ITEM_NUMBER =' || ( ':HOPE_FORECAST_CONTROL.ITEM_NUMBER' ); 
    END IF; 

    IF :HOPE_FORECAST_CONTROL.PRODUCT_CATEGORY IS NOT NULL THEN 
      finalstr := finalstr || 'AND PRODUCT_CATEGORY =' || ( ':HOPE_FORECAST_CONTROL.PRODUCT_CATEGORY' ); 
    END IF; 

    IF :HOPE_FORECAST_CONTROL.PRODUCT_SUB_CATEGORY IS NOT NULL THEN 
      finalstr := finalstr || 'AND PRODUCT_SUB_CATEGORY =' || ( ':HOPE_FORECAST_CONTROL.PRODUCT_SUB_CATEGORY' ); 
    END IF; 

    IF :HOPE_FORECAST_CONTROL.CUSTOMER_NAME IS NOT NULL THEN 
      finalstr := finalstr || 'AND CUSTOMER_NAME =' || ( ':HOPE_FORECAST_CONTROL.CUSTOMER_NAME' ); 
    END IF; 

    IF :HOPE_FORECAST_CONTROL.SALES_CHANNEL IS NOT NULL THEN 
      finalstr := finalstr || 'AND SALES_CHANNEL =' || ( ':HOPE_FORECAST_CONTROL.SALES_CHANNEL' ); 
    END IF; 

    Go_block('HOPE_FORECAST_DATA');  

    dfinalstr := Get_block_property('HOPE_FORECAST_DATA', default_where); 

    Set_block_property('HOPE_FORECAST_DATA', default_where, finalstr); 

    Execute_query(); 
END; 

DECLARE 
    CURSOR c1 IS 
      SELECT organization_code, 
             budget_entity, 
             fiscal_year, 
             item_number, 
             product_category, 
             product_sub_category, 
             customer_name, 
             sales_channel 
      FROM   hope.hope_forecast_data  
      WHERE  organization_code = :HOPE_FORECAST_CONTROL.ORG_CODE 
              OR fiscal_year = :HOPE_FORECAST_CONTROL.FISCAL_YEAR 
              OR item_number = :HOPE_FORECAST_CONTROL.ITEM_NUMBER 
              OR product_category = :HOPE_FORECAST_CONTROL.PRODUCT_CATEGORY 
              OR product_sub_category = :HOPE_FORECAST_CONTROL.PRODUCT_SUB_CATEGORY 
              OR customer_name = :HOPE_FORECAST_CONTROL.CUSTOMER_NAME 
              OR sales_channel = :HOPE_FORECAST_CONTROL.SALES_CHANNEL; 
BEGIN 
OPEN c1; 

FETCH c1 INTO 
:HOPE_FORECAST_CONTROL.ORG_CODE, :HOPE_FORECAST_CONTROL.BUDGET_ENTITY, :HOPE_FORECAST_CONTROL.FISCAL_YEAR, :HOPE_FORECAST_CONTROL.ITEM_NUMBER,
:HOPE_FORECAST_CONTROL.PRODUCT_CATEGORY, :HOPE_FORECAST_CONTROL.PRODUCT_SUB_CATEGORY, :HOPE_FORECAST_CONTROL.CUSTOMER_NAME, :HOPE_FORECAST_CONTROL.SALES_CHANNEL;

CLOSE c1; 
END;