DBA Data[Home] [Help]

APPS.CE_CSH_FCST_POP dependencies on CE_PO_FC_ORDERS_TEMP_V

Line 2998: FROM ce_po_fc_orders_temp_v

2994: (nvl(amount,0)/(trunc(end_date)-trunc(start_date)+1))) per_day_amount,
2995: start_date,
2996: nvl(end_date, l_max_end_date)end_date,
2997: end_date trx_end_date
2998: FROM ce_po_fc_orders_temp_v
2999: WHERE start_date <= p_end_date
3000: AND (end_date >= p_start_date
3001: OR end_date is NULL);
3002:

Line 3071: FROM ce_po_fc_orders_temp_v

3067: (nvl(amount,0)/(trunc(end_date)-trunc(start_date)+1))) per_day_amount,
3068: start_date,
3069: nvl(end_date, l_max_end_date)end_date,
3070: end_date trx_end_date
3071: FROM ce_po_fc_orders_temp_v
3072: WHERE start_date <= p_end_date
3073: AND (end_date >= p_start_date
3074: OR end_date is NULL)
3075: AND project_id = CE_CASH_FCST.G_rp_project_id;