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 210: mtl_parameters mp

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

Line 316: mtl_parameters mp

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

Line 333: mtl_parameters mp

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

Line 360: mtl_parameters mp

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

Line 372: mtl_parameters mp

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

Line 394: mtl_parameters mp

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

Line 470: FROM bom_period_start_dates bp, mtl_parameters mp

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

Line 480: FROM bom_cal_week_start_dates bw, mtl_parameters mp

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

Line 490: FROM bom_calendar_dates bcd, mtl_parameters mp

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

Line 879: mtl_parameters mp

875: mrp_low_level_codes mllc,
876: bom_inventory_components bic,
877: bom_bill_of_materials bbom,
878: bom_operational_routings bor,
879: mtl_parameters mp
880: WHERE mp.organization_id = g_kanban_info_rec.organization_id
881: AND bor.line_id (+) = p_line_id
882: AND bor.assembly_item_id (+) = p_assembly_item_id
883: AND bor.organization_id (+) = mp.organization_id

Line 1921: mtl_parameters mp

1917: mrp_low_level_codes mllc,
1918: bom_inventory_components bic,
1919: bom_bill_of_materials bbom,
1920: bom_operational_routings bor,
1921: mtl_parameters mp
1922: WHERE mp.organization_id = g_kanban_info_rec.organization_id
1923: AND bor.line_id (+) = p_line_id
1924: AND bor.assembly_item_id (+) = p_assembly_item_id
1925: AND bor.organization_id (+) = mp.organization_id

Line 3126: mtl_parameters mp

3122:
3123: SELECT /*+ first_rows */ bw.week_start_date --bug 5237549
3124: INTO l_offset_date
3125: FROM bom_cal_week_start_dates bw,
3126: mtl_parameters mp
3127: WHERE mp.organization_id = g_kanban_info_rec.organization_id
3128: AND bw.calendar_code = mp.calendar_code
3129: AND bw.exception_set_id = mp.calendar_exception_set_id
3130: AND bw.week_start_date <= p_start_date

Line 3138: mtl_parameters mp

3134:
3135: SELECT bp.period_start_date
3136: INTO l_offset_date
3137: FROM bom_period_start_dates bp,
3138: mtl_parameters mp
3139: WHERE mp.organization_id = g_kanban_info_rec.organization_id
3140: AND bp.calendar_code = mp.calendar_code
3141: AND bp.exception_set_id = mp.calendar_exception_set_id
3142: AND bp.period_start_date <= p_start_date

Line 3943: mtl_parameters mp

3939: --and cutoff date specified
3940: SELECT count(*)
3941: INTO l_total_workdays
3942: FROM bom_calendar_dates bcd,
3943: mtl_parameters mp
3944: WHERE mp.organization_id = g_kanban_info_rec.organization_id
3945: AND bcd.calendar_code = mp.calendar_code
3946: AND bcd.seq_num IS NOT NULL
3947: AND (bcd.calendar_date BETWEEN g_kanban_info_rec.start_date AND