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.MSC_CRP_HORIZONTAL_PLAN dependencies on MSC_DEPARTMENT_RESOURCES

Line 247: msc_department_resources cpr,

243: to_number(-1),
244: to_char('-1')
245: FROM
246: msc_resource_requirements crp,
247: msc_department_resources cpr,
248: msc_resource_batches mrb,
249: msc_supplies mss,
250: msc_form_query list
251: WHERE

Line 327: msc_department_resources cpr,

323: to_number(-1),
324: to_char('-1')
325: FROM
326: msc_resource_requirements crp,
327: msc_department_resources cpr,
328: msc_resource_batches mrb,
329: msc_supplies mss,
330: msc_form_query list
331: WHERE

Line 409: msc_department_resources cpr,

405: to_number(-1),
406: to_char('-1')
407: FROM
408: msc_resource_requirements crp,
409: msc_department_resources cpr,
410: msc_resource_batches mrb,
411: msc_supplies mss,
412: msc_form_query list
413: WHERE

Line 494: msc_department_resources cpr,

490: to_number(-1),
491: to_char('-1')
492: FROM
493: msc_resource_requirements crp,
494: msc_department_resources cpr,
495: msc_form_query list
496: WHERE nvl(cpr.owning_department_id, cpr.department_id) = list.number5
497: AND cpr.resource_id = list.number3
498: AND cpr.plan_id = g_designator

Line 566: msc_department_resources cpr,

562: to_number(-1),
563: to_char('-1')
564: FROM
565: msc_resource_requirements crp,
566: msc_department_resources cpr,
567: msc_form_query list
568: WHERE nvl(cpr.owning_department_id, cpr.department_id) = list.number5
569: AND cpr.resource_id = list.number3
570: AND cpr.plan_id = g_designator

Line 715: msc_department_resources cpr,

711: cpr.max_rate*crp.daily_resource_hours))),
712: TO_NUMBER(-1),
713: to_char('-1')
714: FROM msc_resource_requirements crp,
715: msc_department_resources cpr,
716: msc_form_query list,
717: msc_supplies s,
718: msc_system_items i
719: WHERE nvl(cpr.owning_department_id, cpr.department_id) = list.number5

Line 810: msc_department_resources cpr,

806: mrir.res_instance_id,
807: mrir.serial_number
808: FROM
809: msc_resource_requirements crp,
810: msc_department_resources cpr,
811: msc_dept_res_instances mdri,
812: msc_resource_instance_reqs mrir,
813: msc_form_query list
814: WHERE nvl(cpr.owning_department_id, cpr.department_id) = list.number5

Line 901: msc_department_resources cpr,

897: mrir.res_instance_id,
898: mrir.serial_number
899: FROM
900: msc_resource_requirements crp,
901: msc_department_resources cpr,
902: msc_dept_res_instances mdri,
903: msc_resource_instance_reqs mrir,
904: msc_form_query list
905: WHERE nvl(cpr.owning_department_id, cpr.department_id) = list.number5

Line 1074: msc_department_resources cpr,

1070: cpr.max_rate*crp.daily_resource_hours))),
1071: to_number(null),
1072: to_char(null)
1073: FROM msc_resource_requirements crp,
1074: msc_department_resources cpr,
1075: msc_form_query list,
1076: msc_supplies s,
1077: msc_system_items i
1078: WHERE nvl(cpr.owning_department_id, cpr.department_id) = list.number5

Line 1247: from msc_department_resources mdr,

1243: ORDER BY 1,2,4,5,7,6;
1244:
1245: CURSOR agg_resource IS
1246: SELECT nvl(mdr.aggregate_resource_flag,2)
1247: from msc_department_resources mdr,
1248: msc_form_query list
1249: where mdr.plan_id = g_designator
1250: AND mdr.sr_instance_id = list.number4
1251: AND mdr.organization_id = list.number1

Line 1717: from msc_department_resources

1713: v_batchable number :=0;
1714:
1715: cursor isBatchAble is
1716: select nvl(Batchable_flag,2)
1717: from msc_department_resources
1718: where department_id = p_dept_id
1719: and resource_id = p_res_id
1720: and plan_id = g_designator
1721: and organization_id = p_org_id

Line 1748: FROM msc_department_resources

1744:
1745: Begin
1746: SELECT DISTINCT NVL(dept_overhead_cost,0)
1747: INTO v_overhead
1748: FROM msc_department_resources
1749: WHERE organization_id = p_org_id
1750: AND sr_instance_id = p_inst_id
1751: AND department_id = p_dept_id
1752: AND plan_id = -1

Line 1765: FROM msc_department_resources res

1761:
1762: BEGIN
1763: SELECT (1 + v_overhead)*NVL(res.resource_cost,0)
1764: INTO v_res_cost
1765: FROM msc_department_resources res
1766: WHERE res.organization_id = p_org_id
1767: AND res.sr_instance_id = p_inst_id
1768: AND res.department_id = p_dept_id
1769: AND res.resource_id = p_res_id

Line 2131: msc_department_resources dept_res

2127: v_res_code,
2128: v_resource_type_code,
2129: v_res_grp_name
2130: FROM mfg_lookups lkps,
2131: msc_department_resources dept_res
2132: WHERE lkps.lookup_type(+) = 'BOM_RESOURCE_TYPE'
2133: AND lkps.lookup_code(+) = dept_res.resource_type
2134: AND dept_res.plan_id = -1
2135: AND dept_res.organization_id = p_org_id

Line 2559: 'FROM msc_department_resources '||

2555: '-1, ' ||
2556: 'decode(resource_id,-1, msc_get_name.org_code(organization_id,sr_instance_id), department_code), '||
2557: 'decode(resource_id,-1,department_code, resource_code), '||
2558: '-1 ' ||
2559: 'FROM msc_department_resources '||
2560: 'WHERE department_id in ('||p_dept_list||') ' ||
2561: 'AND resource_id in ('||p_res_list||') ' ||
2562: 'AND (sr_instance_id,organization_id) in ('||p_org_list||') ' ||
2563: 'AND plan_id = '||p_plan_id;