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_FORM_QUERY

Line 227: msc_form_query list

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
229: nvl(cpr.owning_department_id, cpr.department_id) = list.number5
230: AND cpr.resource_id = list.number3
231: and nvl(cpr.batchable_flag,2) =1

Line 300: msc_form_query list

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
302: nvl(cpr.owning_department_id, cpr.department_id) = list.number5
303: AND cpr.resource_id = list.number3
304: and nvl(cpr.batchable_flag,2) =1

Line 374: msc_form_query list

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
378: AND cpr.organization_id = list.number1

Line 437: msc_form_query list

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
441: AND cpr.organization_id = list.number1

Line 488: FROM msc_form_query list,

484: trunc(least(msrs.last_unit_start_date,g_cutoff_date-1)),
485: msrs.daily_rate, -- this might not be right, used to be load_factor_rate
486: to_number(-1),
487: to_char('-1')
488: FROM msc_form_query list,
489: msc_supplies msrs
490: WHERE trunc(msrs.first_unit_start_date) <= trunc(g_cutoff_date)
491: AND msrs.plan_id = g_designator
492: AND msrs.organization_id = list.number1

Line 515: msc_form_query list

511: to_number(-1),
512: to_char('-1')
513: FROM msc_net_resource_avail avail,
514:
515: msc_form_query list
516: WHERE trunc(avail.shift_date) <= trunc(g_cutoff_date)
517: AND avail.shift_date >= g_dates(1)+1
518: AND NVL(avail.parent_id,0) <> -1
519: AND avail.plan_id = g_designator

Line 569: msc_form_query list,

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
573: AND cpr.resource_id = list.number3

Line 621: FROM msc_form_query list

617: to_date(1, 'J'),
618: 0,
619: to_NUMBER(-1),
620: to_char('-1')
621: FROM msc_form_query list
622: WHERE list.query_id = g_item_list_id
623: ORDER BY 1,2,4,5,7,6;
624:
625: CURSOR crp_res_inst_snapshot_activity IS

Line 662: msc_form_query list

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
664: AND cpr.resource_id = list.number3
665: AND cpr.plan_id = g_designator
666: AND cpr.organization_id = list.number1

Line 744: msc_form_query list

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
746: AND cpr.resource_id = list.number3
747: AND cpr.plan_id = g_designator
748: AND cpr.organization_id = list.number1

Line 813: FROM msc_form_query list,

809: trunc(least(msrs.last_unit_start_date,g_cutoff_date-1)),
810: msrs.daily_rate, -- this might not be right, used to be load_factor_rate
811: to_number(null),
812: to_char(null)
813: FROM msc_form_query list,
814: msc_supplies msrs
815: WHERE trunc(msrs.first_unit_start_date) <= trunc(g_cutoff_date)
816: AND msrs.plan_id = g_designator
817: AND msrs.organization_id = list.number1

Line 841: msc_form_query list

837: sum(nvl(avail.capacity_units,1) * decode(from_time,NULL,1,(( DECODE(sign(avail.to_time-avail.from_time), -1, avail.to_time+86400, avail.to_time) - avail.from_time)/3600))),
838: avail.res_instance_id,
839: avail.serial_number
840: FROM msc_net_res_inst_avail avail,
841: msc_form_query list
842: WHERE trunc(avail.shift_date) <= trunc(g_cutoff_date)
843: AND avail.shift_date >= g_dates(1)+1
844: AND NVL(avail.parent_id,0) <> -1
845: AND avail.plan_id = g_designator

Line 900: msc_form_query list,

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
904: AND cpr.resource_id = list.number3

Line 953: FROM msc_form_query list

949: to_date(1, 'J'),
950: 0,
951: to_number(null),
952: to_char(null)
953: FROM msc_form_query list
954: WHERE list.query_id = g_item_list_id
955: ORDER BY 1,2,4,5,10,11,7,6;
956:
957:

Line 974: msc_form_query list,

970: NVL(sm.weight_capacity,0),
971: to_number(null),
972: to_char(NULL)
973: FROM msc_interorg_ship_methods sm,
974: msc_form_query list,
975: msc_trading_partners tp,
976: msc_calendar_dates cal
977: WHERE cal.calendar_date BETWEEN g_plan_start_date+1 AND g_cutoff_date
978: AND cal.exception_set_id = tp.calendar_exception_set_id

Line 1002: msc_form_query list,

998: NVL(sm.volume_capacity,0)
999: , to_number(null),
1000: to_char(NULL)
1001: FROM msc_interorg_ship_methods sm,
1002: msc_form_query list,
1003: msc_trading_partners tp,
1004: msc_calendar_dates cal
1005: WHERE cal.calendar_date BETWEEN g_plan_start_date+1 AND g_cutoff_date
1006: AND cal.exception_set_id = tp.calendar_exception_set_id

Line 1031: msc_form_query list

1027: , to_number(null),
1028: to_char(NULL)
1029: FROM msc_interorg_ship_methods sm,
1030: msc_supplies sup,
1031: msc_form_query list
1032: WHERE sm.plan_id = g_designator
1033: AND sm.plan_id = sup.plan_id
1034: AND sm.to_organization_id = sup.organization_id
1035: AND sm.from_organization_id = sup.source_organization_id

Line 1057: msc_form_query list

1053: , to_number(null),
1054: to_char(NULL)
1055: FROM msc_interorg_ship_methods sm,
1056: msc_supplies sup,
1057: msc_form_query list
1058: WHERE sm.plan_id = g_designator
1059: AND sm.plan_id = sup.plan_id
1060: AND sm.to_organization_id = sup.organization_id
1061: AND sm.from_organization_id = sup.source_organization_id

Line 1073: msc_form_query list

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
1077: AND mdr.department_id = list.number2

Line 2253: sql_stmt := 'INSERT INTO msc_form_query ( '||

2249: --dbms_output.put_line(' in query list ');
2250: --dbms_output.put_line(' value of p_inst_list is ' || p_inst_list);
2251: --dbms_output.put_line(' value of sreial number is ' || p_serial_num_list);
2252:
2253: sql_stmt := 'INSERT INTO msc_form_query ( '||
2254: 'query_id, '||
2255: 'last_update_date, '||
2256: 'last_updated_by, '||
2257: 'creation_date, '||