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.CRP_PLANNER_PK dependencies on MRP_PLAN_ORGANIZATIONS_V

Line 148: from mrp_plan_organizations_v

144: AND recom.disposition_status_type <> CANCEL_ORDER
145: AND recom.order_type IN (WORK_ORDER, NONSTD_JOB)
146: AND recom.organization_id IN
147: (select planned_organization
148: from mrp_plan_organizations_v
149: where organization_id = arg_org_id
150: and compile_designator = arg_compile_desig)
151: AND resources.operation_hours_required > resources.hours_expended
152: AND recom.compile_designator = arg_compile_desig;

Line 257: from mrp_plan_organizations_v

253: AND recom.disposition_status_type <> CANCEL_ORDER
254: AND recom.order_type = PLANNED_ORDER
255: AND recom.organization_id IN
256: (Select planned_organization
257: from mrp_plan_organizations_v
258: where organization_id = arg_org_id
259: and compile_designator =
260: arg_compile_desig)
261: AND recom.compile_designator = mp.compile_designator

Line 305: from mrp_plan_organizations_v

301: from mrp_recommendations
302: where compile_designator = arg_compile_desig
303: and organization_id in
304: (select planned_organization
305: from mrp_plan_organizations_v
306: where compile_designator = arg_compile_desig
307: and organization_id = arg_org_id)
308: and order_type = PLANNED_ORDER);
309:

Line 345: from mrp_plan_organizations_v

341: from mrp_recommendations
342: where compile_designator = arg_compile_desig
343: and organization_id in
344: (select planned_organization
345: from mrp_plan_organizations_v
346: where compile_designator = arg_compile_desig
347: and organization_id = arg_org_id)
348: and order_type = PLANNED_ORDER)
349: and resource_end_date is null;

Line 377: from mrp_plan_organizations_v

373: from mrp_recommendations
374: where compile_designator = arg_compile_desig
375: and organization_id in
376: (select planned_organization
377: from mrp_plan_organizations_v
378: where compile_designator = arg_compile_desig
379: and organization_id = arg_org_id)
380: and order_type = PLANNED_ORDER)
381: and resource_end_date is null;

Line 505: from mrp_plan_organizations_v

501: AND recom.disposition_status_type <> CANCEL_ORDER
502: AND recom.order_type = REPETITVE_SCHEDULE
503: AND recom.organization_id IN
504: (select planned_organization
505: from mrp_plan_organizations_v
506: where organization_id = arg_org_id
507: and compile_designator = arg_compile_desig)
508: AND recom.compile_designator = mp.compile_designator
509: AND mp.organization_id = arg_org_id