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.WIP_WS_SHORTAGE dependencies on BOM_CALENDAR_DATES

Line 1468: FROM bom_calendar_dates dates,

1464: SELECT
1465: SUM(MRP_HORIZONTAL_PLAN_SC.compute_daily_rate_t(dates.calendar_code, dates.exception_set_id,
1466: sched.daily_production_rate, sched.quantity_completed,
1467: sched.first_unit_completion_date, dates.calendar_date )) item_qty
1468: FROM bom_calendar_dates dates,
1469: mtl_parameters param,
1470: wip_repetitive_schedules sched,
1471: wip_repetitive_items rep_items
1472: WHERE rep_items.primary_item_id = p_inv_item_id

Line 1483: from bom_calendar_dates cal

1479: and dates.seq_num is not null
1480: and TRUNC(dates.calendar_date) >= TRUNC(sched.first_unit_completion_date)
1481: and TRUNC(dates.calendar_date)
1482: <= (select trunc(cal.calendar_date - 1)
1483: from bom_calendar_dates cal
1484: where cal.exception_set_id = dates.exception_set_id
1485: and cal.calendar_code = dates.calendar_code
1486: and cal.seq_num = (select cal1.prior_seq_num + ceil(sched.processing_work_days)
1487: from bom_calendar_dates cal1

Line 1487: from bom_calendar_dates cal1

1483: from bom_calendar_dates cal
1484: where cal.exception_set_id = dates.exception_set_id
1485: and cal.calendar_code = dates.calendar_code
1486: and cal.seq_num = (select cal1.prior_seq_num + ceil(sched.processing_work_days)
1487: from bom_calendar_dates cal1
1488: where cal1.exception_set_id = dates.exception_set_id
1489: and cal1.calendar_code = dates.calendar_code
1490: and cal1.calendar_date = TRUNC(sched.first_unit_completion_date)) )
1491: and dates.calendar_date = trunc(p_rcpt_date)