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_HORIZONTAL_PLAN_SC dependencies on BOM_CALENDAR_DATES

Line 143: FROM bom_calendar_dates cal

139: var_lucd_seq number ;
140: Begin
141: select cal.prior_seq_num
142: into var_fucd_seq
143: FROM bom_calendar_dates cal
144: WHERE cal.exception_set_id = var_exception_set_id
145: AND cal.calendar_code = var_calendar_code
146: AND cal.calendar_date = TRUNC(fucd) ;
147:

Line 150: FROM bom_calendar_dates cal

146: AND cal.calendar_date = TRUNC(fucd) ;
147:
148: select cal.prior_seq_num
149: into var_lucd_seq
150: FROM bom_calendar_dates cal
151: WHERE cal.exception_set_id = var_exception_set_id
152: AND cal.calendar_code = var_calendar_code
153: AND cal.calendar_date = TRUNC(var_date) ;
154:

Line 463: FROM bom_calendar_dates dates,

459: SUM(GREATEST(0, ((nvl(fs.planned_quantity, 0) -
460: nvl(fs.quantity_completed, 0)) *
461: (bic.component_quantity/bic.component_yield_factor)
462: * bic.planning_factor/100))) old_quantity
463: FROM bom_calendar_dates dates,
464: mtl_parameters mp,
465: wip_flow_schedules fs,
466: mrp_system_items msi_assy,
467: bom_bill_of_materials bbm,

Line 491: from bom_calendar_dates c2

487: ceil((1- nvl(bic.operation_lead_time_percent, 0)/100) *
488: (nvl(msi_assy.fixed_lead_time, 0) +
489: ((fs.planned_quantity - fs.quantity_completed) *
490: nvl(msi_assy.variable_lead_time, 0))))
491: from bom_calendar_dates c2
492: where c2.calendar_code = mp.calendar_code
493: and c2.exception_set_id = mp.calendar_exception_set_id
494: and c2.calendar_date =
495: trunc(fs.scheduled_completion_date)

Line 546: FROM bom_calendar_dates dates,

542: SUM(((nvl(fs.planned_quantity, 0) -
543: nvl(fs.quantity_completed, 0)) *
544: (bic.component_quantity/bic.component_yield_factor)
545: * bic.planning_factor/100)) old_quantity
546: FROM bom_calendar_dates dates,
547: mtl_parameters mp,
548: wip_flow_schedules fs,
549: mrp_system_items msi_assy,
550: bom_bill_of_materials bbm,

Line 574: from bom_calendar_dates c2

570: ceil((1- nvl(bic.operation_lead_time_percent, 0)/100) *
571: (nvl(msi_assy.fixed_lead_time, 0) +
572: ((fs.planned_quantity - fs.quantity_completed) *
573: nvl(msi_assy.variable_lead_time, 0))))
574: from bom_calendar_dates c2
575: where c2.calendar_code = mp.calendar_code
576: and c2.exception_set_id = mp.calendar_exception_set_id
577: and c2.calendar_date =
578: trunc(fs.scheduled_completion_date)

Line 681: bom_calendar_dates dates,

677: SUM(MRP_HORIZONTAL_PLAN_SC.compute_daily_rate_t(dates.calendar_code, dates.exception_set_id,
678: sched.daily_production_rate, sched.quantity_completed,
679: sched.first_unit_completion_date, dates.calendar_date )) old_quantity
680: FROM mrp_form_query list,
681: bom_calendar_dates dates,
682: mtl_parameters param,
683: wip_repetitive_schedules sched,
684: wip_repetitive_items rep_items,
685: mrp_system_items items,

Line 699: from bom_calendar_dates cal

695: and TRUNC(dates.calendar_date)
696: >= TRUNC(sched.first_unit_completion_date)
697: and TRUNC(dates.calendar_date)
698: <= (select trunc(cal.calendar_date - 1)
699: from bom_calendar_dates cal
700: where cal.exception_set_id = dates.exception_set_id
701: and cal.calendar_code = dates.calendar_code
702: and cal.seq_num = (select cal1.prior_seq_num + ceil(sched.processing_work_days)
703: from bom_calendar_dates cal1

Line 703: from bom_calendar_dates cal1

699: from bom_calendar_dates cal
700: where cal.exception_set_id = dates.exception_set_id
701: and cal.calendar_code = dates.calendar_code
702: and cal.seq_num = (select cal1.prior_seq_num + ceil(sched.processing_work_days)
703: from bom_calendar_dates cal1
704: where cal1.exception_set_id = dates.exception_set_id
705: and cal1.calendar_code = dates.calendar_code
706: and cal1.calendar_date = TRUNC(sched.first_unit_completion_date)) )
707: and dates.calendar_date < last_date

Line 741: bom_calendar_dates dates,

737: SUM(sched.daily_production_rate*NVL(items.shrinkage_rate, 0))
738: new_quantity,
739: 0 old_quantity
740: FROM mrp_form_query list,
741: bom_calendar_dates dates,
742: mtl_parameters param,
743: wip_repetitive_schedules sched,
744: wip_repetitive_items rep_items,
745: mrp_system_items items,

Line 759: from bom_calendar_dates cal

755: and TRUNC(dates.calendar_date)
756: >= TRUNC(sched.first_unit_completion_date)
757: and TRUNC(dates.calendar_date)
758: <= (select trunc(cal.calendar_date - 1)
759: from bom_calendar_dates cal
760: where cal.exception_set_id = dates.exception_set_id
761: and cal.calendar_code = dates.calendar_code
762: and cal.seq_num = (select cal1.prior_seq_num + ceil(sched.processing_work_days)
763: from bom_calendar_dates cal1

Line 763: from bom_calendar_dates cal1

759: from bom_calendar_dates cal
760: where cal.exception_set_id = dates.exception_set_id
761: and cal.calendar_code = dates.calendar_code
762: and cal.seq_num = (select cal1.prior_seq_num + ceil(sched.processing_work_days)
763: from bom_calendar_dates cal1
764: where cal1.exception_set_id = dates.exception_set_id
765: and cal1.calendar_code = dates.calendar_code
766: and cal1.calendar_date = TRUNC(sched.first_unit_completion_date)) )
767: and dates.calendar_date < last_date

Line 866: bom_calendar_dates dates,

862: SUM(DECODE(sched.rate_end_date, NULL, sched.schedule_quantity,
863: sched.repetitive_daily_rate)) new_quantity,
864: 0 old_quantity
865: FROM mrp_form_query list,
866: bom_calendar_dates dates,
867: mtl_parameters param,
868: mrp_schedule_dates sched,
869: mrp_plan_schedules_v plan_sched,
870: mrp_plans plans,

Line 950: bom_calendar_dates dates,

946: dates.calendar_date old_date,
947: SUM(fcst.current_forecast_quantity) new_quantity,
948: 0 old_quantity
949: FROM mrp_form_query list,
950: bom_calendar_dates dates,
951: mtl_parameters param,
952: mrp_forecast_dates fcst,
953: mrp_forecast_designators desig,
954: mrp_load_parameters load,

Line 1659: bom_calendar_dates dates,

1655: ((NVL(recom.new_order_quantity, 0)
1656: - NVL(implemented_quantity, 0))/NVL(recom.new_order_quantity,1)))) new_quantity,
1657: 0 old_quantity
1658: FROM mrp_form_query list,
1659: bom_calendar_dates dates,
1660: mtl_parameters param,
1661: mrp_recommendations recom,
1662: mrp_gross_requirements reqs,
1663: mrp_system_items items,

Line 1725: bom_calendar_dates dates

1721: 0 old_quantity
1722: FROM mrp_form_query list,
1723: mtl_parameters param,
1724: mrp_gross_requirements reqs,
1725: bom_calendar_dates dates
1726: WHERE (arg_res_level = 1
1727: OR (arg_res_level = 2
1728: AND reqs.project_id is NULL)
1729: OR (DECODE(arg_res_level,

Line 2690: bom_calendar_dates dates

2686: SUM(NVL(rec.old_order_quantity,0)) old_quantity
2687: FROM mrp_form_query list,
2688: mtl_parameters param,
2689: mrp_recommendations rec,
2690: bom_calendar_dates dates
2691: WHERE (arg_res_level = 1
2692: OR (arg_res_level = 2
2693: AND rec.project_id is NULL)
2694: OR (DECODE(arg_res_level,

Line 2821: bom_calendar_dates dates

2817: 0 old_quantity
2818: FROM mrp_form_query list,
2819: mtl_parameters param,
2820: mrp_gross_requirements mgr,
2821: bom_calendar_dates dates
2822: WHERE (arg_res_level = 1
2823: OR (arg_res_level = 2
2824: AND mgr.project_id is NULL)
2825: OR (DECODE(arg_res_level,

Line 3002: bom_calendar_dates dates

2998: 0 old_quantity
2999: FROM mrp_form_query list,
3000: mtl_parameters param,
3001: mrp_aggregate_rates sched,
3002: bom_calendar_dates dates
3003: WHERE dates.exception_set_id = param.calendar_exception_set_id
3004: AND dates.calendar_code = param.calendar_code
3005: AND dates.seq_num IS NOT NULL
3006: AND dates.calendar_date BETWEEN sched.first_unit_completion_date