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_GRAPH_LINE_CAPACITY dependencies on MRP_LINE_SCH_AVAIL_V

Line 25: mrp_line_sch_avail_v ls,

21: AND mp.calendar_code = cal.calendar_code
22: UNION ALL
23: SELECT distinct cal.calendar_date
24: FROM mtl_parameters mp,
25: mrp_line_sch_avail_v ls,
26: bom_calendar_dates cal
27: WHERE mp.organization_id = p_org_id
28: AND ls.line_id = p_line_id
29: AND cal.calendar_date >= p_start_date

Line 103: mrp_line_sch_avail_v ls

99: bom_operation_sequences bos1,
100: bom_resources bre,
101: mtl_units_of_measure muom,
102: bom_operational_routings bor,
103: mrp_line_sch_avail_v ls
104: WHERE ls.line_id = p_line_id
105: AND ls.organization_id = p_org_id
106: AND nvl(ls.alternate_routing_designator,'@!#')
107: = nvl(bor.alternate_routing_designator,'@!#')

Line 146: mrp_line_sch_avail_v ls

142: mfq.number1,
143: mfq.date1,
144: sum(ls.planned_quantity - nvl(ls.quantity_completed,0))
145: FROM mrp_form_query mfq,
146: mrp_line_sch_avail_v ls
147: WHERE ls.organization_id = p_org_id
148: AND ls.line_id = p_line_id
149: AND trunc(ls.scheduled_completion_date) = mfq.date1
150: AND mfq.query_id = p_query_id