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.

[Home] [Help]

APPS.MSC_CRP_HORIZONTAL_PLAN dependencies on MSC_DEPARTMENT_RESOURCES

Line 224: msc_department_resources cpr,

220: to_number(-1),
221: to_char('-1')
222: FROM
223: msc_resource_requirements crp,
224: msc_department_resources cpr,
225: msc_resource_batches mrb,
226: msc_supplies mss,
227: msc_form_query list
228: WHERE

Line 297: msc_department_resources cpr,

293: to_number(-1),
294: to_char('-1')
295: FROM
296: msc_resource_requirements crp,
297: msc_department_resources cpr,
298: msc_resource_batches mrb,
299: msc_supplies mss,
300: msc_form_query list
301: WHERE

Line 373: msc_department_resources cpr,

369: to_number(-1),
370: to_char('-1')
371: FROM
372: msc_resource_requirements crp,
373: msc_department_resources cpr,
374: msc_form_query list
375: WHERE nvl(cpr.owning_department_id, cpr.department_id) = list.number5
376: AND cpr.resource_id = list.number3
377: AND cpr.plan_id = g_designator

Line 436: msc_department_resources cpr,

432: to_number(-1),
433: to_char('-1')
434: FROM
435: msc_resource_requirements crp,
436: msc_department_resources cpr,
437: msc_form_query list
438: WHERE nvl(cpr.owning_department_id, cpr.department_id) = list.number5
439: AND cpr.resource_id = list.number3
440: AND cpr.plan_id = g_designator

Line 568: msc_department_resources cpr,

564: cpr.max_rate*crp.daily_resource_hours))),
565: TO_NUMBER(-1),
566: to_char('-1')
567: FROM msc_resource_requirements crp,
568: msc_department_resources cpr,
569: msc_form_query list,
570: msc_supplies s,
571: msc_system_items i
572: WHERE nvl(cpr.owning_department_id, cpr.department_id) = list.number5

Line 659: msc_department_resources cpr,

655: mrir.res_instance_id,
656: mrir.serial_number
657: FROM
658: msc_resource_requirements crp,
659: msc_department_resources cpr,
660: msc_dept_res_instances mdri,
661: msc_resource_instance_reqs mrir,
662: msc_form_query list
663: WHERE nvl(cpr.owning_department_id, cpr.department_id) = list.number5

Line 741: msc_department_resources cpr,

737: mrir.res_instance_id,
738: mrir.serial_number
739: FROM
740: msc_resource_requirements crp,
741: msc_department_resources cpr,
742: msc_dept_res_instances mdri,
743: msc_resource_instance_reqs mrir,
744: msc_form_query list
745: WHERE nvl(cpr.owning_department_id, cpr.department_id) = list.number5

Line 899: msc_department_resources cpr,

895: cpr.max_rate*crp.daily_resource_hours))),
896: to_number(null),
897: to_char(null)
898: FROM msc_resource_requirements crp,
899: msc_department_resources cpr,
900: msc_form_query list,
901: msc_supplies s,
902: msc_system_items i
903: WHERE nvl(cpr.owning_department_id, cpr.department_id) = list.number5

Line 1072: from msc_department_resources mdr,

1068: ORDER BY 1,2,4,5,7,6;
1069:
1070: CURSOR agg_resource IS
1071: SELECT nvl(mdr.aggregate_resource_flag,2)
1072: from msc_department_resources mdr,
1073: msc_form_query list
1074: where mdr.plan_id = g_designator
1075: AND mdr.sr_instance_id = list.number4
1076: AND mdr.organization_id = list.number1

Line 1519: from msc_department_resources

1515: v_batchable number :=0;
1516:
1517: cursor isBatchAble is
1518: select nvl(Batchable_flag,2)
1519: from msc_department_resources
1520: where department_id = p_dept_id
1521: and resource_id = p_res_id
1522: and plan_id = g_designator
1523: and organization_id = p_org_id

Line 1549: FROM msc_department_resources

1545: IF (p_res_id <> -1) AND g_current_data <> SYS_TRANS THEN
1546:
1547: SELECT DISTINCT NVL(dept_overhead_cost,0)
1548: INTO v_overhead
1549: FROM msc_department_resources
1550: WHERE organization_id = p_org_id
1551: AND sr_instance_id = p_inst_id
1552: AND department_id = p_dept_id
1553: AND plan_id = -1;

Line 1562: FROM msc_department_resources res

1558:
1559: BEGIN
1560: SELECT (1 + v_overhead)*NVL(res.resource_cost,0)
1561: INTO v_res_cost
1562: FROM msc_department_resources res
1563: WHERE res.organization_id = p_org_id
1564: AND res.sr_instance_id = p_inst_id
1565: AND res.department_id = p_dept_id
1566: AND res.resource_id = p_res_id

Line 1889: msc_department_resources dept_res

1885: v_res_code,
1886: v_resource_type_code,
1887: v_res_grp_name
1888: FROM mfg_lookups lkps,
1889: msc_department_resources dept_res
1890: WHERE lkps.lookup_type(+) = 'BOM_RESOURCE_TYPE'
1891: AND lkps.lookup_code(+) = dept_res.resource_type
1892: AND dept_res.plan_id = -1
1893: AND dept_res.organization_id = p_org_id

Line 2311: 'FROM msc_department_resources '||

2307: '-1, ' ||
2308: 'decode(resource_id,-1, msc_get_name.org_code(organization_id,sr_instance_id), department_code), '||
2309: 'decode(resource_id,-1,department_code, resource_code), '||
2310: '-1 ' ||
2311: 'FROM msc_department_resources '||
2312: 'WHERE department_id in ('||p_dept_list||') ' ||
2313: 'AND resource_id in ('||p_res_list||') ' ||
2314: 'AND (sr_instance_id,organization_id) in ('||p_org_list||') ' ||
2315: 'AND plan_id = '||p_plan_id;