DBA Data[Home] [Help]

APPS.MRP_LINE_SCHEDULE_ALGORITHM dependencies on WIP_REPETITIVE_SCHEDULES

Line 321: wip_repetitive_schedules.daily_production_rate,

317:
318: SELECT NVL(SUM(NVL(MRP_HORIZONTAL_PLAN_SC.compute_daily_rate_t(
319: v_cal_code,
320: v_excep_code,
321: wip_repetitive_schedules.daily_production_rate,
322: wip_repetitive_schedules.quantity_completed,
323: wip_repetitive_schedules.first_unit_completion_date,
324: to_date(v_current_date,'J')),0)),0)
325: INTO v_sum_rs

Line 322: wip_repetitive_schedules.quantity_completed,

318: SELECT NVL(SUM(NVL(MRP_HORIZONTAL_PLAN_SC.compute_daily_rate_t(
319: v_cal_code,
320: v_excep_code,
321: wip_repetitive_schedules.daily_production_rate,
322: wip_repetitive_schedules.quantity_completed,
323: wip_repetitive_schedules.first_unit_completion_date,
324: to_date(v_current_date,'J')),0)),0)
325: INTO v_sum_rs
326: FROM wip_repetitive_schedules

Line 323: wip_repetitive_schedules.first_unit_completion_date,

319: v_cal_code,
320: v_excep_code,
321: wip_repetitive_schedules.daily_production_rate,
322: wip_repetitive_schedules.quantity_completed,
323: wip_repetitive_schedules.first_unit_completion_date,
324: to_date(v_current_date,'J')),0)),0)
325: INTO v_sum_rs
326: FROM wip_repetitive_schedules
327: WHERE line_id = p_line_id

Line 326: FROM wip_repetitive_schedules

322: wip_repetitive_schedules.quantity_completed,
323: wip_repetitive_schedules.first_unit_completion_date,
324: to_date(v_current_date,'J')),0)),0)
325: INTO v_sum_rs
326: FROM wip_repetitive_schedules
327: WHERE line_id = p_line_id
328: AND organization_id = p_org_id
329: --fix bug#3783650
330: --AND v_current_date BETWEEN