DBA Data[Home] [Help]

APPS.AS_SCN_FORECAST_PVT dependencies on AS_PROD_WORKSHEET_LINES

Line 46: FROM as_prod_worksheet_lines apwl,

42: SUM(DECODE(apwl.FORECAST_AMOUNT_FLAG,'N',1,0)+R.CONVERSION_STATUS_FLAG) CONVERSION_FLAG ,
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

Line 71: FROM as_prod_worksheet_lines apwl,

67: SUM(DECODE(apwl.FORECAST_AMOUNT_FLAG,'N',1,0)+R.CONVERSION_STATUS_FLAG) CONVERSION_FLAG ,
68: SUM(ROUND(apwl.WORST_FORECAST_AMOUNT*R.CONVERSION_RATE,0)),
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