DBA Data[Home] [Help]

APPS.BIL_BI_FST_DTL_F_PKG dependencies on AS_PROD_WORKSHEET_LINES

Line 1660: as_prod_worksheet_lines apwsl,

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
1664: aif.forecast_id = bnfi.forecast_id

Line 1785: as_prod_worksheet_lines apwsl,

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
1789: aif.forecast_id = bnfi.forecast_id