DBA Data[Home] [Help]

APPS.AS_SCN_FORECAST_PVT dependencies on AS_SALES_GROUPS_V

Line 73: as_sales_groups_v sg,

69: SUM(ROUND(apwl.FORECAST_AMOUNT*R.CONVERSION_RATE,0)),
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