DBA Data[Home] [Help]

APPS.WIP_WS_SHORTAGE dependencies on MTL_PARAMETERS

Line 155: from mtl_parameters mp, bom_shift_dates bsd,

151: wip_ws_util.get_appended_date( bsd.shift_date, t.to_time) to_date,
152: t.shift_num,
153: bsd.seq_num,
154: wip_ws_util.get_shift_info_for_display(mp.organization_id, bsd.seq_num, t.shift_num) as display
155: from mtl_parameters mp, bom_shift_dates bsd,
156: (select bst.calendar_code,
157: bst.shift_num,
158: min(bst.from_time) from_time,
159: max(decode(sign(bst.to_time - bst.from_time), -1, 24*60*60, 0) + bst.to_time) to_time

Line 1398: mtl_parameters param,

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,
1399: wip_repetitive_schedules sched,
1400: wip_repetitive_items rep_items
1401: WHERE rep_items.primary_item_id = p_inv_item_id
1402: and rep_items.organization_id = p_org_id