DBA Data[Home] [Help]

APPS.WIP_WS_SHORTAGE dependencies on MRP_HORIZONTAL_PLAN_SC

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

1461: */
1462: FUNCTION get_rep_sch_supply(p_org_id NUMBER, p_inv_item_id NUMBER, p_rcpt_date DATE) RETURN NUMBER IS
1463: CURSOR rep_sched_csr(p_org_id NUMBER, p_inv_item_id NUMBER, p_rcpt_date DATE)IS
1464: SELECT
1465: SUM(MRP_HORIZONTAL_PLAN_SC.compute_daily_rate_t(dates.calendar_code, dates.exception_set_id,
1466: sched.daily_production_rate, sched.quantity_completed,
1467: sched.first_unit_completion_date, dates.calendar_date )) item_qty
1468: FROM bom_calendar_dates dates,
1469: mtl_parameters param,