43: SUM(ROUND(apwl.WORST_FORECAST_AMOUNT*R.CONVERSION_RATE,0)),
44: SUM(ROUND(apwl.FORECAST_AMOUNT*R.CONVERSION_RATE,0)),
45: SUM(ROUND(apwl.BEST_FORECAST_AMOUNT*R.CONVERSION_RATE,0))
46: FROM as_prod_worksheet_lines apwl,
47: AS_PERIOD_RATES R,
48: as_pe_int_categories apic
49: WHERE apwl.product_category_id = apic.product_category_id
50: AND apwl.product_cat_set_id = apic.product_cat_set_id
51: AND apic.quota_id = c_quota_id
70: SUM(ROUND(apwl.BEST_FORECAST_AMOUNT*R.CONVERSION_RATE,0))
71: FROM as_prod_worksheet_lines apwl,
72: as_pe_int_categories apic,
73: as_sales_groups_v sg,
74: AS_PERIOD_RATES R,
75: gl_periods pd
76: WHERE apwl.product_category_id = apic.product_category_id
77: AND apwl.product_cat_set_id = apic.product_cat_set_id
78: AND apic.quota_id = c_quota_id