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_SUPPLIES

Line 249: msc_supplies mss,

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

Line 329: msc_supplies mss,

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

Line 411: msc_supplies mss,

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

Line 624: msc_supplies msrs

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
628: AND msrs.sr_instance_id = list.number4

Line 717: msc_supplies s,

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
721: AND cpr.plan_id = g_designator

Line 978: msc_supplies msrs

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
982: AND msrs.sr_instance_id = list.number4

Line 1076: msc_supplies s,

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
1080: AND cpr.plan_id = g_designator

Line 1205: msc_supplies sup,

1201: NVL(sup.weight_capacity_used,0)
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

Line 1231: msc_supplies sup,

1227: NVL(sup.volume_capacity_used,0)
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