DBA Data[Home] [Help]

APPS.MRP_HORIZONTAL_PLAN_SC dependencies on MRP_HORIZONTAL_PLAN_SC

Line 1: PACKAGE BODY MRP_HORIZONTAL_PLAN_SC AS

1: PACKAGE BODY MRP_HORIZONTAL_PLAN_SC AS
2: /* $Header: MRPPHOPB.pls 120.9 2008/01/13 23:34:05 schaudha ship $ */
3:
4: SYS_YES CONSTANT INTEGER := 1;
5: SYS_NO CONSTANT INTEGER := 2;

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

670: CURRENT_S row_type,
671: CURRENT_S_OFF offset,
672: dates.calendar_date new_date,
673: dates.calendar_date old_date,
674: SUM(MRP_HORIZONTAL_PLAN_SC.compute_daily_rate_t(dates.calendar_code, dates.exception_set_id,
675: sched.daily_production_rate, sched.quantity_completed,
676: sched.first_unit_completion_date, dates.calendar_date )) new_quantity ,
677: SUM(MRP_HORIZONTAL_PLAN_SC.compute_daily_rate_t(dates.calendar_code, dates.exception_set_id,
678: sched.daily_production_rate, sched.quantity_completed,

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

673: dates.calendar_date old_date,
674: SUM(MRP_HORIZONTAL_PLAN_SC.compute_daily_rate_t(dates.calendar_code, dates.exception_set_id,
675: sched.daily_production_rate, sched.quantity_completed,
676: sched.first_unit_completion_date, dates.calendar_date )) new_quantity ,
677: SUM(MRP_HORIZONTAL_PLAN_SC.compute_daily_rate_t(dates.calendar_code, dates.exception_set_id,
678: sched.daily_production_rate, sched.quantity_completed,
679: sched.first_unit_completion_date, dates.calendar_date )) old_quantity
680: FROM mrp_form_query list,
681: bom_calendar_dates dates,