DBA Data[Home] [Help]

APPS.CE_CSH_FCST_POP dependencies on CE_PO_FC_ORDERS_TEMP_V

Line 2922: FROM ce_po_fc_orders_temp_v

2918: (nvl(amount,0)/(trunc(end_date)-trunc(start_date)+1))) per_day_amount,
2919: start_date,
2920: nvl(end_date, l_max_end_date)end_date,
2921: end_date trx_end_date
2922: FROM ce_po_fc_orders_temp_v
2923: WHERE start_date <= p_end_date
2924: AND (end_date >= p_start_date
2925: OR end_date is NULL);
2926:

Line 2995: FROM ce_po_fc_orders_temp_v

2991: (nvl(amount,0)/(trunc(end_date)-trunc(start_date)+1))) per_day_amount,
2992: start_date,
2993: nvl(end_date, l_max_end_date)end_date,
2994: end_date trx_end_date
2995: FROM ce_po_fc_orders_temp_v
2996: WHERE start_date <= p_end_date
2997: AND (end_date >= p_start_date
2998: OR end_date is NULL)
2999: AND project_id = CE_CASH_FCST.G_rp_project_id;