DBA Data[Home] [Help]

APPS.CE_CSH_FCST_POP dependencies on CE_PO_FC_ORDERS_TERMS_TEMP_V

Line 2881: FROM ce_po_fc_orders_terms_temp_v src

2877: src.due_amount),(nvl(src.amount,0) * (nvl(src.due_percent,100)/100))))/(trunc(end_date)-trunc(start_date)+1)) per_day_amount,
2878: start_date,
2879: nvl(end_date, l_max_end_date)end_date,
2880: end_date trx_end_date
2881: FROM ce_po_fc_orders_terms_temp_v src
2882: WHERE start_date <= p_end_date
2883: AND (end_date >= p_start_date
2884: OR end_date is NULL)
2885: UNION ALL

Line 2951: FROM ce_po_fc_orders_terms_temp_v src

2947: src.due_amount),(nvl(src.amount,0) * (nvl(src.due_percent,100)/100))))/(trunc(end_date)-trunc(start_date)+1)) per_day_amount,
2948: start_date,
2949: nvl(end_date, l_max_end_date)end_date,
2950: end_date trx_end_date
2951: FROM ce_po_fc_orders_terms_temp_v src
2952: WHERE start_date <= p_end_date
2953: AND (end_date >= p_start_date
2954: OR end_date is NULL)
2955: AND project_id = CE_CASH_FCST.G_rp_project_id