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 250: msc_form_query list

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

Line 330: msc_form_query list

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

Line 412: msc_form_query list

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

Line 495: msc_form_query list

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

Line 567: msc_form_query list

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

Line 623: FROM msc_form_query list,

619: trunc(least(msrs.last_unit_start_date,g_cutoff_date-1)),
620: msrs.daily_rate, -- this might not be right, used to be load_factor_rate
621: to_number(-1),
622: to_char('-1')
623: FROM msc_form_query list,
624: msc_supplies msrs
625: WHERE trunc(msrs.first_unit_start_date) <= trunc(g_cutoff_date)
626: AND msrs.plan_id = g_designator
627: AND msrs.organization_id = list.number1

Line 661: msc_form_query list

657: to_number(-1),
658: to_char('-1')
659: FROM msc_net_resource_avail avail,
660: msc_plans mp,
661: msc_form_query list
662: WHERE trunc(avail.shift_date) <= trunc(g_cutoff_date)
663: AND avail.shift_date >= g_dates(1)+1
664: AND NVL(avail.parent_id,0) <> -1
665: AND avail.plan_id = g_designator

Line 716: msc_form_query list,

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

Line 768: FROM msc_form_query list

764: to_date(1, 'J'),
765: 0,
766: to_NUMBER(-1),
767: to_char('-1')
768: FROM msc_form_query list
769: WHERE list.query_id = g_item_list_id
770: ORDER BY 1,2,4,5,7,6;
771:
772: CURSOR crp_res_inst_snapshot_activity IS

Line 813: msc_form_query list

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
815: AND cpr.resource_id = list.number3
816: AND cpr.plan_id = g_designator
817: AND cpr.organization_id = list.number1

Line 904: msc_form_query list

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
906: AND cpr.resource_id = list.number3
907: AND cpr.plan_id = g_designator
908: AND cpr.organization_id = list.number1

Line 977: FROM msc_form_query list,

973: trunc(least(msrs.last_unit_start_date,g_cutoff_date-1)),
974: msrs.daily_rate, -- this might not be right, used to be load_factor_rate
975: to_number(null),
976: to_char(null)
977: FROM msc_form_query list,
978: msc_supplies msrs
979: WHERE trunc(msrs.first_unit_start_date) <= trunc(g_cutoff_date)
980: AND msrs.plan_id = g_designator
981: AND msrs.organization_id = list.number1

Line 1015: msc_form_query list

1011: --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))),
1012: avail.res_instance_id,
1013: avail.serial_number
1014: FROM msc_net_res_inst_avail avail, msc_plans mp,
1015: msc_form_query list
1016: WHERE trunc(avail.shift_date) <= trunc(g_cutoff_date)
1017: AND avail.shift_date >= g_dates(1)+1
1018: AND NVL(avail.parent_id,0) <> -1
1019: AND avail.plan_id = g_designator

Line 1075: msc_form_query list,

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

Line 1128: FROM msc_form_query list

1124: to_date(1, 'J'),
1125: 0,
1126: to_number(null),
1127: to_char(null)
1128: FROM msc_form_query list
1129: WHERE list.query_id = g_item_list_id
1130: ORDER BY 1,2,4,5,10,11,7,6;
1131:
1132:

Line 1149: msc_form_query list,

1145: NVL(sm.weight_capacity,0),
1146: to_number(null),
1147: to_char(NULL)
1148: FROM msc_interorg_ship_methods sm,
1149: msc_form_query list,
1150: msc_trading_partners tp,
1151: msc_calendar_dates cal
1152: WHERE cal.calendar_date BETWEEN g_plan_start_date+1 AND g_cutoff_date
1153: AND cal.exception_set_id = tp.calendar_exception_set_id

Line 1177: msc_form_query list,

1173: NVL(sm.volume_capacity,0)
1174: , to_number(null),
1175: to_char(NULL)
1176: FROM msc_interorg_ship_methods sm,
1177: msc_form_query list,
1178: msc_trading_partners tp,
1179: msc_calendar_dates cal
1180: WHERE cal.calendar_date BETWEEN g_plan_start_date+1 AND g_cutoff_date
1181: AND cal.exception_set_id = tp.calendar_exception_set_id

Line 1206: msc_form_query list

1202: , to_number(null),
1203: to_char(NULL)
1204: FROM msc_interorg_ship_methods sm,
1205: msc_supplies sup,
1206: msc_form_query list
1207: WHERE sm.plan_id = g_designator
1208: AND sm.plan_id = sup.plan_id
1209: AND sm.to_organization_id = sup.organization_id
1210: AND sm.from_organization_id = sup.source_organization_id

Line 1232: msc_form_query list

1228: , to_number(null),
1229: to_char(NULL)
1230: FROM msc_interorg_ship_methods sm,
1231: msc_supplies sup,
1232: msc_form_query list
1233: WHERE sm.plan_id = g_designator
1234: AND sm.plan_id = sup.plan_id
1235: AND sm.to_organization_id = sup.organization_id
1236: AND sm.from_organization_id = sup.source_organization_id

Line 1248: msc_form_query list

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

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

2497: --dbms_output.put_line(' in query list ');
2498: --dbms_output.put_line(' value of p_inst_list is ' || p_inst_list);
2499: --dbms_output.put_line(' value of sreial number is ' || p_serial_num_list);
2500:
2501: sql_stmt := 'INSERT INTO msc_form_query ( '||
2502: 'query_id, '||
2503: 'last_update_date, '||
2504: 'last_updated_by, '||
2505: 'creation_date, '||