DBA Data[Home] [Help]

APPS.AS_SCN_FORECAST_PVT dependencies on AS_PERIOD_RATES

Line 47: AS_PERIOD_RATES R,

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

Line 74: AS_PERIOD_RATES R,

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