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_EXCEPTION_PKG dependencies on STANDARD

Line 208: 2, abs(med.quantity) *msi.standard_cost,

204: trunc(nvl(med.date1, nvl(mp.plan_start_date, mp.curr_start_date))) analysis_date,
205: med.exception_type,
206: count(*) exception_count,
207: sum(decode(med.exception_type,
208: 2, abs(med.quantity) *msi.standard_cost,
209: 3, med.quantity *msi.standard_cost,
210: 6,med.quantity *nvl(msi.list_price,0) * (1-(nvl(msi.average_discount,0)/100)),
211: 7,med.quantity *nvl(msi.list_price,0) * (1-(nvl(msi.average_discount,0)/100)),
212: 8,med.quantity *nvl(msi.list_price,0) * (1-(nvl(msi.average_discount,0)/100)),

Line 209: 3, med.quantity *msi.standard_cost,

205: med.exception_type,
206: count(*) exception_count,
207: sum(decode(med.exception_type,
208: 2, abs(med.quantity) *msi.standard_cost,
209: 3, med.quantity *msi.standard_cost,
210: 6,med.quantity *nvl(msi.list_price,0) * (1-(nvl(msi.average_discount,0)/100)),
211: 7,med.quantity *nvl(msi.list_price,0) * (1-(nvl(msi.average_discount,0)/100)),
212: 8,med.quantity *nvl(msi.list_price,0) * (1-(nvl(msi.average_discount,0)/100)),
213: 9,med.quantity *nvl(msi.list_price,0) * (1-(nvl(msi.average_discount,0)/100)),

Line 215: 11, abs(med.quantity) *msi.standard_cost,

211: 7,med.quantity *nvl(msi.list_price,0) * (1-(nvl(msi.average_discount,0)/100)),
212: 8,med.quantity *nvl(msi.list_price,0) * (1-(nvl(msi.average_discount,0)/100)),
213: 9,med.quantity *nvl(msi.list_price,0) * (1-(nvl(msi.average_discount,0)/100)),
214: 10,med.quantity *nvl(msi.list_price,0) * (1-(nvl(msi.average_discount,0)/100)),
215: 11, abs(med.quantity) *msi.standard_cost,
216: 13,abs(med.quantity) *nvl(msi.list_price,0) * (1-(nvl(msi.average_discount,0)/100)),
217: 14,abs(med.quantity) *nvl(msi.list_price,0) * (1-(nvl(msi.average_discount,0)/100)),
218: 15,med.quantity *nvl(msi.list_price,0) * (1-(nvl(msi.average_discount,0)/100)),
219: 16,med.quantity *nvl(msi.list_price,0) * (1-(nvl(msi.average_discount,0)/100)),

Line 220: 17, abs(med.quantity) *msi.standard_cost,

216: 13,abs(med.quantity) *nvl(msi.list_price,0) * (1-(nvl(msi.average_discount,0)/100)),
217: 14,abs(med.quantity) *nvl(msi.list_price,0) * (1-(nvl(msi.average_discount,0)/100)),
218: 15,med.quantity *nvl(msi.list_price,0) * (1-(nvl(msi.average_discount,0)/100)),
219: 16,med.quantity *nvl(msi.list_price,0) * (1-(nvl(msi.average_discount,0)/100)),
220: 17, abs(med.quantity) *msi.standard_cost,
221: 18, med.quantity *msi.standard_cost,
222: 23,md.using_requirement_quantity * msc_phub_util.get_list_price
223: (med.plan_id,med.sr_instance_id,med.organization_id,md.inventory_item_id),
224: 24,abs(med.quantity) *nvl(msi.list_price,0) * (1-(nvl(msi.average_discount,0)/100)),

Line 221: 18, med.quantity *msi.standard_cost,

217: 14,abs(med.quantity) *nvl(msi.list_price,0) * (1-(nvl(msi.average_discount,0)/100)),
218: 15,med.quantity *nvl(msi.list_price,0) * (1-(nvl(msi.average_discount,0)/100)),
219: 16,med.quantity *nvl(msi.list_price,0) * (1-(nvl(msi.average_discount,0)/100)),
220: 17, abs(med.quantity) *msi.standard_cost,
221: 18, med.quantity *msi.standard_cost,
222: 23,md.using_requirement_quantity * msc_phub_util.get_list_price
223: (med.plan_id,med.sr_instance_id,med.organization_id,md.inventory_item_id),
224: 24,abs(med.quantity) *nvl(msi.list_price,0) * (1-(nvl(msi.average_discount,0)/100)),
225: 25,abs(med.quantity) *nvl(msi.list_price,0) * (1-(nvl(msi.average_discount,0)/100)),

Line 262: 73, med.quantity *msi.standard_cost,

258: 70,md.using_requirement_quantity*nvl(msi.list_price,0) * (1-(nvl(msi.average_discount,0)/100)),
259: 71,decode(med.number2, 2, ms.new_order_quantity,
260: md.using_requirement_quantity)*nvl(msi.list_price,0) * (1-(nvl(msi.average_discount,0)/100)),
261: 72,med.quantity *nvl(msi.list_price,0) * (1-(nvl(msi.average_discount,0)/100)),
262: 73, med.quantity *msi.standard_cost,
263: 74, med.quantity *msi.standard_cost,
264: 75, med.quantity *msi.standard_cost,
265: 76,med.quantity *nvl(msi.list_price,0) * (1-(nvl(msi.average_discount,0)/100)),
266: 77,med.quantity *nvl(msi.list_price,0) * (1-(nvl(msi.average_discount,0)/100)),

Line 263: 74, med.quantity *msi.standard_cost,

259: 71,decode(med.number2, 2, ms.new_order_quantity,
260: md.using_requirement_quantity)*nvl(msi.list_price,0) * (1-(nvl(msi.average_discount,0)/100)),
261: 72,med.quantity *nvl(msi.list_price,0) * (1-(nvl(msi.average_discount,0)/100)),
262: 73, med.quantity *msi.standard_cost,
263: 74, med.quantity *msi.standard_cost,
264: 75, med.quantity *msi.standard_cost,
265: 76,med.quantity *nvl(msi.list_price,0) * (1-(nvl(msi.average_discount,0)/100)),
266: 77,med.quantity *nvl(msi.list_price,0) * (1-(nvl(msi.average_discount,0)/100)),
267: 114,abs(med.quantity) *nvl(msi.list_price,0) * (1-(nvl(msi.average_discount,0)/100)),

Line 264: 75, med.quantity *msi.standard_cost,

260: md.using_requirement_quantity)*nvl(msi.list_price,0) * (1-(nvl(msi.average_discount,0)/100)),
261: 72,med.quantity *nvl(msi.list_price,0) * (1-(nvl(msi.average_discount,0)/100)),
262: 73, med.quantity *msi.standard_cost,
263: 74, med.quantity *msi.standard_cost,
264: 75, med.quantity *msi.standard_cost,
265: 76,med.quantity *nvl(msi.list_price,0) * (1-(nvl(msi.average_discount,0)/100)),
266: 77,med.quantity *nvl(msi.list_price,0) * (1-(nvl(msi.average_discount,0)/100)),
267: 114,abs(med.quantity) *nvl(msi.list_price,0) * (1-(nvl(msi.average_discount,0)/100)),
268: to_number(null)) )exception_value,

Line 503: 160, abs(t.quantity) *msi.standard_cost,

499: sum(decode(t.exception_type,
500: 150, abs(t.quantity) *nvl(msi.list_price,0) * (1-(nvl(msi.average_discount,0)/100)),
501: 151, t.quantity *nvl(msi.list_price,0) * (1-(nvl(msi.average_discount,0)/100)),
502: 152, t.quantity *nvl(msi.list_price,0) * (1-(nvl(msi.average_discount,0)/100)),
503: 160, abs(t.quantity) *msi.standard_cost,
504: 161, t.quantity *msi.standard_cost,
505: 162, t.quantity *msi.standard_cost,
506: 190, abs(t.quantity) *msi.standard_cost,
507: 191, t.quantity *msi.standard_cost,

Line 504: 161, t.quantity *msi.standard_cost,

500: 150, abs(t.quantity) *nvl(msi.list_price,0) * (1-(nvl(msi.average_discount,0)/100)),
501: 151, t.quantity *nvl(msi.list_price,0) * (1-(nvl(msi.average_discount,0)/100)),
502: 152, t.quantity *nvl(msi.list_price,0) * (1-(nvl(msi.average_discount,0)/100)),
503: 160, abs(t.quantity) *msi.standard_cost,
504: 161, t.quantity *msi.standard_cost,
505: 162, t.quantity *msi.standard_cost,
506: 190, abs(t.quantity) *msi.standard_cost,
507: 191, t.quantity *msi.standard_cost,
508: to_number(null)) )exception_value,

Line 505: 162, t.quantity *msi.standard_cost,

501: 151, t.quantity *nvl(msi.list_price,0) * (1-(nvl(msi.average_discount,0)/100)),
502: 152, t.quantity *nvl(msi.list_price,0) * (1-(nvl(msi.average_discount,0)/100)),
503: 160, abs(t.quantity) *msi.standard_cost,
504: 161, t.quantity *msi.standard_cost,
505: 162, t.quantity *msi.standard_cost,
506: 190, abs(t.quantity) *msi.standard_cost,
507: 191, t.quantity *msi.standard_cost,
508: to_number(null)) )exception_value,
509: to_number(null) exception_days,

Line 506: 190, abs(t.quantity) *msi.standard_cost,

502: 152, t.quantity *nvl(msi.list_price,0) * (1-(nvl(msi.average_discount,0)/100)),
503: 160, abs(t.quantity) *msi.standard_cost,
504: 161, t.quantity *msi.standard_cost,
505: 162, t.quantity *msi.standard_cost,
506: 190, abs(t.quantity) *msi.standard_cost,
507: 191, t.quantity *msi.standard_cost,
508: to_number(null)) )exception_value,
509: to_number(null) exception_days,
510: sum(decode( t.exception_type,

Line 507: 191, t.quantity *msi.standard_cost,

503: 160, abs(t.quantity) *msi.standard_cost,
504: 161, t.quantity *msi.standard_cost,
505: 162, t.quantity *msi.standard_cost,
506: 190, abs(t.quantity) *msi.standard_cost,
507: 191, t.quantity *msi.standard_cost,
508: to_number(null)) )exception_value,
509: to_number(null) exception_days,
510: sum(decode( t.exception_type,
511: 150, abs(t.quantity),