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 1397: FROM bom_calendar_dates dates,

1393: SELECT
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

Line 1412: from bom_calendar_dates cal

1408: and dates.seq_num is not null
1409: and TRUNC(dates.calendar_date) >= TRUNC(sched.first_unit_completion_date)
1410: and TRUNC(dates.calendar_date)
1411: <= (select trunc(cal.calendar_date - 1)
1412: from bom_calendar_dates cal
1413: where cal.exception_set_id = dates.exception_set_id
1414: and cal.calendar_code = dates.calendar_code
1415: and cal.seq_num = (select cal1.prior_seq_num + ceil(sched.processing_work_days)
1416: from bom_calendar_dates cal1

Line 1416: from bom_calendar_dates cal1

1412: from bom_calendar_dates cal
1413: where cal.exception_set_id = dates.exception_set_id
1414: and cal.calendar_code = dates.calendar_code
1415: and cal.seq_num = (select cal1.prior_seq_num + ceil(sched.processing_work_days)
1416: from bom_calendar_dates cal1
1417: where cal1.exception_set_id = dates.exception_set_id
1418: and cal1.calendar_code = dates.calendar_code
1419: and cal1.calendar_date = TRUNC(sched.first_unit_completion_date)) )
1420: and dates.calendar_date = trunc(p_rcpt_date)