DBA Data[Home] [Help]

APPS.CE_CSH_FCST_POP dependencies on CE_PO_FC_ORDERS_TERMS_TEMP_V

Line 2957: FROM ce_po_fc_orders_terms_temp_v src

2953: src.due_amount),(nvl(src.amount,0) * (nvl(src.due_percent,100)/100))))/(trunc(end_date)-trunc(start_date)+1)) per_day_amount,
2954: start_date,
2955: nvl(end_date, l_max_end_date)end_date,
2956: end_date trx_end_date
2957: FROM ce_po_fc_orders_terms_temp_v src
2958: WHERE start_date <= p_end_date
2959: AND (end_date >= p_start_date
2960: OR end_date is NULL)
2961: UNION ALL

Line 3027: FROM ce_po_fc_orders_terms_temp_v src

3023: src.due_amount),(nvl(src.amount,0) * (nvl(src.due_percent,100)/100))))/(trunc(end_date)-trunc(start_date)+1)) per_day_amount,
3024: start_date,
3025: nvl(end_date, l_max_end_date)end_date,
3026: end_date trx_end_date
3027: FROM ce_po_fc_orders_terms_temp_v src
3028: WHERE start_date <= p_end_date
3029: AND (end_date >= p_start_date
3030: OR end_date is NULL)
3031: AND project_id = CE_CASH_FCST.G_rp_project_id