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_CRP_HORIZONTAL_PLAN dependencies on MRP_FORM_QUERY

Line 148: mrp_form_query list

144: mrp_recommendations recom,
145: mrp_system_items items,
146: mrp_planned_resource_reqs routing,
147: mtl_parameters org,
148: mrp_form_query list
149: WHERE res_start.exception_set_id = org.calendar_exception_set_id
150: AND res_start.calendar_code = org.calendar_code
151: AND res_start.seq_num = order_date.prior_seq_num -
152: ceil((1 - NVL(routing.resource_offset_percent,0)) *

Line 207: mrp_form_query list,

203: FROM mtl_uom_conversions muc2,
204: wip_discrete_jobs jobs,
205: wip_operations op,
206: wip_operation_resources res,
207: mrp_form_query list,
208: mtl_uom_conversions muc1
209: WHERE muc1.inventory_item_id = 0
210: AND muc1.uom_code = g_hour_uom
211: AND muc2.uom_code = res.uom_code

Line 267: mrp_form_query list

263: bom_operation_resources res,
264: bom_resources bom_res,
265: mtl_uom_conversions muc2,
266: mtl_uom_conversions muc1,
267: mrp_form_query list
268: WHERE res_start.exception_set_id = param.calendar_exception_set_id
269: AND res_start.calendar_code = param.calendar_code
270: AND res_start.seq_num = order_date.prior_seq_num -
271: ceil((1 - NVL(res.resource_offset_percent/100,0)) *

Line 329: mrp_form_query list,

325: wip_repetitive_schedules rep,
326: wip_repetitive_items items,
327: wip_operations op,
328: wip_operation_resources res,
329: mrp_form_query list,
330: mtl_uom_conversions muc1
331: WHERE muc1.inventory_item_id = 0
332: AND muc1.uom_code = g_hour_uom
333: AND muc2.uom_code = res.uom_code

Line 371: mrp_form_query list

367: to_date(null),
368: (mr.new_order_quantity - NVL(mr.implemented_quantity,0) +
369: NVL(mr.quantity_in_process,0))
370: FROM mrp_recommendations mr,
371: mrp_form_query list
372: WHERE mr.order_type = M_PLANNED_ORDER
373: AND mr.new_wip_start_date < g_cutoff_date
374: AND mr.compile_designator = g_designator
375: AND mr.line_id = list.number2

Line 397: mrp_form_query list

393: to_date(NULL),
394: SUM(GREATEST( 0, (jobs.net_quantity - jobs.quantity_completed
395: - jobs.quantity_scrapped)))
396: FROM wip_discrete_jobs jobs,
397: mrp_form_query list
398: WHERE jobs.scheduled_start_date 399: AND jobs.status_type IN (JOB_UNRELEASED,
400: JOB_COMPLETE, JOB_HOLD, JOB_RELEASED)
401: AND jobs.job_type in (WIP_NONSTANDARD,WIP_DISCRETE)

Line 429: mrp_form_query list

425: fs.scheduled_start_date,
426: to_date(NULL),
427: SUM(GREATEST( 0, (fs.planned_quantity - fs.quantity_completed)))
428: FROM wip_flow_schedules fs,
429: mrp_form_query list
430: WHERE fs.scheduled_start_date 431: AND fs.scheduled_completion_date >= TRUNC(sysdate)
432: AND fs.wip_entity_id >= 0
433: AND fs.organization_id = list.number1

Line 460: mrp_form_query list

456: rep_items.PRODUCTION_LINE_RATE
457: FROM wip_repetitive_items rep_items,
458: wip_repetitive_schedules sched,
459: wip_lines lines,
460: mrp_form_query list
461: WHERE rep_items.organization_id = sched.organization_id
462: AND rep_items.line_id = sched.line_id
463: AND rep_items.wip_entity_id = sched.wip_entity_id
464: AND TRUNC(sched.first_unit_start_date) < g_cutoff_date

Line 492: mrp_form_query list

488: (decode(least(line.start_time, line.stop_time),
489: line.stop_time, (line.stop_time + (24 *3600)),
490: line.stop_time) - line.start_time) / 3600
491: FROM wip_lines line,
492: mrp_form_query list
493: WHERE nvl(line.disable_date, sysdate + 1) > sysdate
494: AND line.organization_id = list.number1
495: AND line.line_id = list.number2
496: AND list.number3 is null

Line 526: mrp_form_query list

522: bom_resource_shifts res_shifts,
523: bom_department_resources dept_res,
524: mtl_parameters param,
525: bom_calendar_dates cal,
526: mrp_form_query list
527: WHERE (shifts.calendar_code is NULL OR
528: shifts.calendar_code = param.calendar_code)
529: AND shifts.shift_num (+) = res_shifts.shift_num
530: AND res_shifts.resource_id (+)= dept_res.resource_id

Line 586: mrp_form_query list

582: FROM bom_calendar_dates dates,
583: bom_resource_changes brc,
584: mrp_plan_organizations_v orgs,
585: mtl_parameters param,
586: mrp_form_query list
587: WHERE dates.exception_set_id = param.calendar_exception_set_id
588: AND dates.calendar_code = param.calendar_code
589: AND (brc.action_type = ADD_WORK_DAY
590: OR dates.seq_num is not NULL

Line 651: mrp_form_query list

647: bom_resource_changes brc,
648: bom_department_resources dept_res,
649: mrp_plan_organizations_v orgs,
650: mtl_parameters param,
651: mrp_form_query list
652: WHERE shifts.calendar_code = param.calendar_code
653: AND shifts.shift_num = brc.shift_num
654: AND TRUNC(brc.from_date) < g_cutoff_date
655: AND TRUNC(brc.from_date) >= g_dates(1)

Line 703: mrp_form_query list

699: crp.daily_resource_hours)
700: FROM
701: crp_resource_plan crp,
702: crp_planned_resources cpr,
703: mrp_form_query list
704: WHERE
705: cpr.owning_department_id = list.number2
706: AND cpr.resource_id = list.number3
707: AND cpr.compile_designator = g_designator

Line 724: INDEX(list MRP_FORM_QUERY_N1)

720: -- Discrete job/Planned order Line Requirement
721: -- ============================================
722: SELECT /*+ ORDERED
723: USE_NL(mr)
724: INDEX(list MRP_FORM_QUERY_N1)
725: INDEX(mr MRP_RECOMMENDATIONS_N2) */
726: mr.organization_id,
727: mr.inventory_item_id,
728: -1,

Line 739: FROM mrp_form_query list,

735: M_FLOW_SCHEDULES, DISCRETE_JOBS),
736: NVL(mr.new_wip_start_date,mr.new_schedule_date),
737: to_date(null),
738: mr.new_order_quantity
739: FROM mrp_form_query list,
740: mrp_recommendations mr
741: WHERE mr.order_type in (M_PLANNED_ORDER, M_DISCRETE_JOBS,
742: M_NONSTD_JOBS, M_FLOW_SCHEDULES)
743: AND mr.disposition_status_type <> 2

Line 769: mrp_form_query list

765: trunc(crp.resource_date),
766: to_date(NULL),
767: crp.load_rate
768: FROM crp_resource_plan crp,
769: mrp_form_query list
770: WHERE crp.supply_type in (M_PLANNED_ORDER, M_REPETITIVE)
771: AND crp.designator = g_designator
772: AND crp.resource_date < g_cutoff_date
773: AND crp.resource_id = -1

Line 783: INDEX(list MRP_FORM_QUERY_N1)

779: -- ===================================
780: -- Repetitive schedule line requirements
781: -- ===================================
782: SELECT /*+ORDERED
783: INDEX(list MRP_FORM_QUERY_N1)
784: INDEX(msrs MRP_SUGG_REP_SCHEDULES_N3) */
785: msrs.organization_id,
786: msrs.inventory_item_id,
787: -1,

Line 794: FROM mrp_form_query list,

790: REPETITIVE,
791: trunc(msrs.first_unit_start_date),
792: trunc(least(msrs.last_unit_start_date,g_cutoff_date-1)),
793: msrs.load_factor_rate
794: FROM mrp_form_query list,
795: mrp_sugg_rep_schedules msrs
796: WHERE msrs.first_unit_start_date < g_cutoff_date
797: AND msrs.compile_designator = g_designator
798: AND msrs.organization_id = list.number1

Line 817: mrp_form_query list

813: trunc(avail.resource_start_date),
814: trunc(least(nvl(avail.resource_end_date,g_cutoff_date), g_cutoff_date-1)),
815: avail.resource_units * avail.resource_hours
816: FROM crp_available_resources avail,
817: mrp_form_query list
818: WHERE avail.resource_start_date < g_cutoff_date
819: AND nvl(avail.resource_end_date, g_cutoff_date) >= g_dates(1)
820: AND avail.compile_designator = g_designator
821: AND avail.organization_id = list.number1

Line 841: mrp_form_query list

837: trunc(avail.resource_start_date),
838: trunc(least(nvl(avail.resource_end_date,g_cutoff_date),g_cutoff_date-1)),
839: avail.max_rate
840: FROM crp_available_resources avail,
841: mrp_form_query list
842: WHERE avail.resource_start_date < g_cutoff_date
843: AND nvl(avail.resource_end_date, g_cutoff_date) >= g_dates(1)
844: AND avail.compile_designator = g_designator
845: AND avail.organization_id = list.number1