DBA Data[Home] [Help]

APPS.WIP_WS_SHORTAGE dependencies on MRP_HORIZONTAL_PLAN_SC

Line 1394: SUM(MRP_HORIZONTAL_PLAN_SC.compute_daily_rate_t(dates.calendar_code, dates.exception_set_id,

1390: */
1391: FUNCTION get_rep_sch_supply(p_org_id NUMBER, p_inv_item_id NUMBER, p_rcpt_date DATE) RETURN NUMBER IS
1392: CURSOR rep_sched_csr(p_org_id NUMBER, p_inv_item_id NUMBER, p_rcpt_date DATE)IS
1393: SELECT
1394: SUM(MRP_HORIZONTAL_PLAN_SC.compute_daily_rate_t(dates.calendar_code, dates.exception_set_id,
1395: sched.daily_production_rate, sched.quantity_completed,
1396: sched.first_unit_completion_date, dates.calendar_date )) item_qty
1397: FROM bom_calendar_dates dates,
1398: mtl_parameters param,