DBA Data[Home] [Help]

APPS.AS_SCN_FORECAST_PVT dependencies on AS_PE_INT_CATEGORIES

Line 48: as_pe_int_categories apic

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
52: AND apwl.salesforce_id = c_resource_id

Line 72: as_pe_int_categories apic,

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
76: WHERE apwl.product_category_id = apic.product_category_id