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 CRP_PLANNED_RESOURCES

Line 171: from crp_planned_resources cpr

167: AND routing.alternate_routing_designator is NULL
168: AND routing.compile_designator = g_designator
169: AND routing.organization_id = org.organization_id
170: AND routing.department_id in (select department_id
171: from crp_planned_resources cpr
172: where cpr.compile_designator = g_designator
173: and cpr.organization_id = list.number1
174: and cpr.owning_department_id = list.number2)
175: AND routing.resource_id = list.number3

Line 227: from crp_planned_resources cpr

223: AND op.wip_entity_id = res.wip_entity_id
224: AND op.operation_seq_num = res.operation_seq_num
225: AND op.organization_id = res.organization_id
226: AND op.department_id in (select department_id
227: from crp_planned_resources cpr
228: where cpr.compile_designator = g_designator
229: and cpr.organization_id = list.number1
230: and cpr.owning_department_id = list.number2)
231: AND res.wip_entity_id >= 0

Line 702: crp_planned_resources cpr,

698: NULL, crp.resource_hours,
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