[Home] [Help]
1118: aif.submission_date,
1119: l_collect_mode,
1120: aif.period_name
1121: FROM
1122: as_internal_forecasts aif,
1123: gl_periods glp
1124: WHERE
1125: aif.submission_date BETWEEN p_start_date AND p_end_date
1126: AND aif.status_code = 'SUBMITTED'
1158: aif.submission_date,
1159: l_collect_mode,
1160: aif.period_name
1161: FROM
1162: as_internal_forecasts aif,
1163: gl_periods glp
1164: WHERE
1165: NOT EXISTS (SELECT forecast_id FROM bil_bi_processed_fst_id bpfi
1166: WHERE aif.forecast_id = bpfi.forecast_id)
1454: l_proc := 'Insert_Into_Stg.';
1455: /* end initialization of variable */
1456:
1457: ------------------------------------------------------------------
1458: -- Insert Forecasts in the given range from AS_INTERNAL_FORECASTS,
1459: -- AS_FST_SALES_CATEGORIES and AS_FORECAST_CATEGORIES.
1460: ------------------------------------------------------------------
1461:
1462: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
1605: aif.forecast_amount*rates.exchange_rate_s forecast_amt_s,
1606: NULL opp_forecast_amt_p,
1607: NULL opp_forecast_amt_s
1608: FROM
1609: as_internal_forecasts aif,
1610: bil_bi_new_fst_id bnfi,
1611: as_fst_sales_categories asfc,
1612: bil_bi_currency_rate rates
1613: WHERE
1655: apwsl.forecast_amount*rates.exchange_rate_s forecast_amt_s,
1656: apwsl.opp_forecast_amount*rates.exchange_rate opp_forecast_amt_p,
1657: apwsl.opp_forecast_amount*rates.exchange_rate_s opp_forecast_amt_s
1658: FROM
1659: as_internal_forecasts aif,
1660: as_prod_worksheet_lines apwsl,
1661: bil_bi_new_fst_id bnfi,
1662: bil_bi_currency_rate rates
1663: WHERE
1780: apwsl.forecast_amount*rates.exchange_rate_s forecast_amt_s,
1781: NVL(apwsl.opp_forecast_amount,0)*rates.exchange_rate opp_forecast_amt_p,
1782: NVL(apwsl.opp_forecast_amount,0)*rates.exchange_rate_s opp_forecast_amt_s
1783: FROM
1784: as_internal_forecasts aif,
1785: as_prod_worksheet_lines apwsl,
1786: bil_bi_new_fst_id bnfi,
1787: bil_bi_currency_rate rates
1788: WHERE