eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MRP_KANBAN_PLAN_PK dependencies on MTL_PARAMETERS

Line 213: mtl_parameters mp

209:
210: CURSOR c1 IS
211: SELECT count(*) count
212: FROM bom_calendar_dates bcd,
213: mtl_parameters mp
214: WHERE mp.organization_id = g_kanban_info_rec.organization_id
215: AND bcd.calendar_code = mp.calendar_code
216: AND bcd.exception_set_id = mp.calendar_exception_set_id
217: AND bcd.calendar_date between

Line 319: mtl_parameters mp

315: SELECT count(*)
316: INTO l_total_workdays
317: FROM bom_calendar_dates cd,
318: bom_cal_week_start_dates ws,
319: mtl_parameters mp
320: WHERE mp.organization_id = g_kanban_info_rec.organization_id
321: AND ws.calendar_code = mp.calendar_code
322: AND ws.exception_set_id = mp.calendar_exception_set_id
323: AND ws.week_start_date = l_demand_date

Line 336: mtl_parameters mp

332: SELECT count(*)
333: INTO l_total_workdays
334: FROM bom_calendar_dates cd,
335: bom_period_start_dates ps,
336: mtl_parameters mp
337: WHERE mp.organization_id = g_kanban_info_rec.organization_id
338: AND ps.calendar_code = mp.calendar_code
339: AND ps.exception_set_id = mp.calendar_exception_set_id
340: AND ps.period_start_date = l_demand_date

Line 363: mtl_parameters mp

359:
360: SELECT bw.next_date
361: INTO l_next_date
362: FROM bom_cal_week_start_dates bw,
363: mtl_parameters mp
364: WHERE mp.organization_id = g_kanban_info_rec.organization_id
365: AND bw.calendar_code = mp.calendar_code
366: AND bw.exception_set_id = mp.calendar_exception_set_id
367: AND bw.week_start_date <= l_demand_date

Line 375: mtl_parameters mp

371:
372: SELECT bp.next_date
373: INTO l_next_date
374: FROM bom_period_start_dates bp,
375: mtl_parameters mp
376: WHERE mp.organization_id = g_kanban_info_rec.organization_id
377: AND bp.calendar_code = mp.calendar_code
378: AND bp.exception_set_id = mp.calendar_exception_set_id
379: AND bp.period_start_date <= l_demand_date

Line 397: mtl_parameters mp

393:
394: SELECT count(*)
395: INTO l_current_workdays
396: FROM bom_calendar_dates cd,
397: mtl_parameters mp
398: WHERE mp.organization_id = g_kanban_info_rec.organization_id
399: AND cd.calendar_code = mp.calendar_code
400: AND cd.exception_set_id = mp.calendar_exception_set_id
401: AND (cd.calendar_date BETWEEN l_demand_date AND l_next_date)

Line 473: FROM bom_period_start_dates bp, mtl_parameters mp

469:
470: -- cursor for repetitive periodic forecast dates
471: cursor cur_periodic_forecasts is
472: SELECT bp.period_start_date, bp.next_date
473: FROM bom_period_start_dates bp, mtl_parameters mp
474: WHERE mp.organization_id = g_kanban_info_rec.organization_id
475: AND bp.calendar_code = mp.calendar_code
476: AND bp.exception_set_id = mp.calendar_exception_set_id
477: AND (bp.period_start_date BETWEEN p_demand_date AND

Line 483: FROM bom_cal_week_start_dates bw, mtl_parameters mp

479:
480: -- cursor for repetitive weekly forecast dates
481: cursor cur_weekly_forecasts is
482: SELECT bw.week_start_date, bw.next_date
483: FROM bom_cal_week_start_dates bw, mtl_parameters mp
484: WHERE mp.organization_id = g_kanban_info_rec.organization_id
485: AND bw.calendar_code = mp.calendar_code
486: AND bw.exception_set_id = mp.calendar_exception_set_id
487: AND (bw.week_start_date BETWEEN p_demand_date AND

Line 493: FROM bom_calendar_dates bcd, mtl_parameters mp

489:
490: -- cursor for repetitive daily forecast dates
491: cursor cur_daily_forecasts is
492: SELECT bcd.calendar_date
493: FROM bom_calendar_dates bcd, mtl_parameters mp
494: WHERE mp.organization_id = g_kanban_info_rec.organization_id
495: AND bcd.calendar_code = mp.calendar_code
496: AND bcd.exception_set_id = mp.calendar_exception_set_id
497: AND (bcd.calendar_date BETWEEN l_rate_start_date AND

Line 942: mtl_parameters mp

938: mrp_low_level_codes mllc,
939: bom_inventory_components bic,
940: bom_bill_of_materials bbom,
941: bom_operational_routings bor,
942: mtl_parameters mp
943: WHERE mp.organization_id = g_kanban_info_rec.organization_id
944: AND bor.line_id (+) = p_line_id
945: AND bor.assembly_item_id (+) = p_assembly_item_id
946: AND bor.organization_id (+) = mp.organization_id

Line 2016: mtl_parameters mp

2012: mrp_low_level_codes mllc,
2013: bom_inventory_components bic,
2014: bom_bill_of_materials bbom,
2015: bom_operational_routings bor,
2016: mtl_parameters mp
2017: WHERE mp.organization_id = g_kanban_info_rec.organization_id
2018: AND bor.line_id (+) = p_line_id
2019: AND bor.assembly_item_id (+) = p_assembly_item_id
2020: AND bor.organization_id (+) = mp.organization_id

Line 3454: mtl_parameters mp

3450:
3451: SELECT /*+ first_rows */ bw.week_start_date --bug 5237549
3452: INTO l_offset_date
3453: FROM bom_cal_week_start_dates bw,
3454: mtl_parameters mp
3455: WHERE mp.organization_id = g_kanban_info_rec.organization_id
3456: AND bw.calendar_code = mp.calendar_code
3457: AND bw.exception_set_id = mp.calendar_exception_set_id
3458: AND bw.week_start_date <= p_start_date

Line 3466: mtl_parameters mp

3462:
3463: SELECT bp.period_start_date
3464: INTO l_offset_date
3465: FROM bom_period_start_dates bp,
3466: mtl_parameters mp
3467: WHERE mp.organization_id = g_kanban_info_rec.organization_id
3468: AND bp.calendar_code = mp.calendar_code
3469: AND bp.exception_set_id = mp.calendar_exception_set_id
3470: AND bp.period_start_date <= p_start_date

Line 4437: mtl_parameters mp

4433: --and cutoff date specified
4434: SELECT count(*)
4435: INTO l_total_workdays
4436: FROM bom_calendar_dates bcd,
4437: mtl_parameters mp
4438: WHERE mp.organization_id = g_kanban_info_rec.organization_id
4439: AND bcd.calendar_code = mp.calendar_code
4440: AND bcd.seq_num IS NOT NULL
4441: AND (bcd.calendar_date BETWEEN g_kanban_info_rec.start_date AND