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 205: 2,abs(med.quantity) *msi.standard_cost,

201: trunc(nvl(med.date1, l_plan_start_date)) analysis_date,
202: med.exception_type,
203: count(*) exception_count,
204: sum(decode(med.exception_type,
205: 2,abs(med.quantity) *msi.standard_cost,
206: 3,med.quantity *msi.standard_cost,
207: 6,(case when l_plan_type in (101,102,103,105) then med.number5
208: else med.quantity *nvl(msi.list_price,0) * (1-(nvl(msi.average_discount,0)/100)) end),
209: 7,(case when l_plan_type in (101,102,103,105) then med.number5

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

202: med.exception_type,
203: count(*) exception_count,
204: sum(decode(med.exception_type,
205: 2,abs(med.quantity) *msi.standard_cost,
206: 3,med.quantity *msi.standard_cost,
207: 6,(case when l_plan_type in (101,102,103,105) then med.number5
208: else med.quantity *nvl(msi.list_price,0) * (1-(nvl(msi.average_discount,0)/100)) end),
209: 7,(case when l_plan_type in (101,102,103,105) then med.number5
210: else med.quantity *nvl(msi.list_price,0) * (1-(nvl(msi.average_discount,0)/100)) end),

Line 211: 8,med.quantity *nvl(msi.standard_cost,0),

207: 6,(case when l_plan_type in (101,102,103,105) then med.number5
208: else med.quantity *nvl(msi.list_price,0) * (1-(nvl(msi.average_discount,0)/100)) end),
209: 7,(case when l_plan_type in (101,102,103,105) then med.number5
210: else med.quantity *nvl(msi.list_price,0) * (1-(nvl(msi.average_discount,0)/100)) end),
211: 8,med.quantity *nvl(msi.standard_cost,0),
212: 9,med.quantity *nvl(msi.list_price,0) * (1-(nvl(msi.average_discount,0)/100)),
213: 10,med.quantity *nvl(msi.standard_cost,0),
214: 11,abs(med.quantity) *nvl(msi.standard_cost,0),
215: 13,abs(med.quantity) *nvl(msi.list_price,0) * (1-(nvl(msi.average_discount,0)/100)),

Line 213: 10,med.quantity *nvl(msi.standard_cost,0),

209: 7,(case when l_plan_type in (101,102,103,105) then med.number5
210: else med.quantity *nvl(msi.list_price,0) * (1-(nvl(msi.average_discount,0)/100)) end),
211: 8,med.quantity *nvl(msi.standard_cost,0),
212: 9,med.quantity *nvl(msi.list_price,0) * (1-(nvl(msi.average_discount,0)/100)),
213: 10,med.quantity *nvl(msi.standard_cost,0),
214: 11,abs(med.quantity) *nvl(msi.standard_cost,0),
215: 13,abs(med.quantity) *nvl(msi.list_price,0) * (1-(nvl(msi.average_discount,0)/100)),
216: 14,abs(med.quantity) *nvl(msi.list_price,0) * (1-(nvl(msi.average_discount,0)/100)),
217: 15,med.quantity *nvl(msi.list_price,0) * (1-(nvl(msi.average_discount,0)/100)),

Line 214: 11,abs(med.quantity) *nvl(msi.standard_cost,0),

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

Line 219: 17,abs(med.quantity) *nvl(msi.standard_cost,0),

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

Line 220: 18,med.quantity *nvl(msi.standard_cost,0),

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

Line 227: 31,med.quantity *nvl(msi.standard_cost,0),

223: 24,abs(med.quantity) *nvl(msi.list_price,0) * (1-(nvl(msi.average_discount,0)/100)),
224: 25,abs(med.quantity) *nvl(msi.list_price,0) * (1-(nvl(msi.average_discount,0)/100)),
225: 26,abs(med.quantity) *nvl(msi.list_price,0) * (1-(nvl(msi.average_discount,0)/100)),
226: 27,abs(med.quantity) *nvl(msi.list_price,0) * (1-(nvl(msi.average_discount,0)/100)),
227: 31,med.quantity *nvl(msi.standard_cost,0),
228: 32,med.quantity *nvl(msi.standard_cost,0),
229: 33,med.quantity *nvl(msi.standard_cost,0),
230: 34,med.quantity *nvl(msi.standard_cost,0),
231: 42,md.using_requirement_quantity*nvl(msi.list_price,0) * (1-(nvl(msi.average_discount,0)/100)),

Line 228: 32,med.quantity *nvl(msi.standard_cost,0),

224: 25,abs(med.quantity) *nvl(msi.list_price,0) * (1-(nvl(msi.average_discount,0)/100)),
225: 26,abs(med.quantity) *nvl(msi.list_price,0) * (1-(nvl(msi.average_discount,0)/100)),
226: 27,abs(med.quantity) *nvl(msi.list_price,0) * (1-(nvl(msi.average_discount,0)/100)),
227: 31,med.quantity *nvl(msi.standard_cost,0),
228: 32,med.quantity *nvl(msi.standard_cost,0),
229: 33,med.quantity *nvl(msi.standard_cost,0),
230: 34,med.quantity *nvl(msi.standard_cost,0),
231: 42,md.using_requirement_quantity*nvl(msi.list_price,0) * (1-(nvl(msi.average_discount,0)/100)),
232: 43,med.quantity*nvl(msi.standard_cost,0),

Line 229: 33,med.quantity *nvl(msi.standard_cost,0),

225: 26,abs(med.quantity) *nvl(msi.list_price,0) * (1-(nvl(msi.average_discount,0)/100)),
226: 27,abs(med.quantity) *nvl(msi.list_price,0) * (1-(nvl(msi.average_discount,0)/100)),
227: 31,med.quantity *nvl(msi.standard_cost,0),
228: 32,med.quantity *nvl(msi.standard_cost,0),
229: 33,med.quantity *nvl(msi.standard_cost,0),
230: 34,med.quantity *nvl(msi.standard_cost,0),
231: 42,md.using_requirement_quantity*nvl(msi.list_price,0) * (1-(nvl(msi.average_discount,0)/100)),
232: 43,med.quantity*nvl(msi.standard_cost,0),
233: 44,med.quantity*nvl(msi.standard_cost,0),

Line 230: 34,med.quantity *nvl(msi.standard_cost,0),

226: 27,abs(med.quantity) *nvl(msi.list_price,0) * (1-(nvl(msi.average_discount,0)/100)),
227: 31,med.quantity *nvl(msi.standard_cost,0),
228: 32,med.quantity *nvl(msi.standard_cost,0),
229: 33,med.quantity *nvl(msi.standard_cost,0),
230: 34,med.quantity *nvl(msi.standard_cost,0),
231: 42,md.using_requirement_quantity*nvl(msi.list_price,0) * (1-(nvl(msi.average_discount,0)/100)),
232: 43,med.quantity*nvl(msi.standard_cost,0),
233: 44,med.quantity*nvl(msi.standard_cost,0),
234: 47,med.quantity *nvl(msi.list_price,0) * (1-(nvl(msi.average_discount,0)/100)),

Line 232: 43,med.quantity*nvl(msi.standard_cost,0),

228: 32,med.quantity *nvl(msi.standard_cost,0),
229: 33,med.quantity *nvl(msi.standard_cost,0),
230: 34,med.quantity *nvl(msi.standard_cost,0),
231: 42,md.using_requirement_quantity*nvl(msi.list_price,0) * (1-(nvl(msi.average_discount,0)/100)),
232: 43,med.quantity*nvl(msi.standard_cost,0),
233: 44,med.quantity*nvl(msi.standard_cost,0),
234: 47,med.quantity *nvl(msi.list_price,0) * (1-(nvl(msi.average_discount,0)/100)),
235: 48,med.quantity *nvl(msi.list_price,0) * (1-(nvl(msi.average_discount,0)/100)),
236: 49,msc_get_name.demand_quantity(med.plan_id,med.sr_instance_id,

Line 233: 44,med.quantity*nvl(msi.standard_cost,0),

229: 33,med.quantity *nvl(msi.standard_cost,0),
230: 34,med.quantity *nvl(msi.standard_cost,0),
231: 42,md.using_requirement_quantity*nvl(msi.list_price,0) * (1-(nvl(msi.average_discount,0)/100)),
232: 43,med.quantity*nvl(msi.standard_cost,0),
233: 44,med.quantity*nvl(msi.standard_cost,0),
234: 47,med.quantity *nvl(msi.list_price,0) * (1-(nvl(msi.average_discount,0)/100)),
235: 48,med.quantity *nvl(msi.list_price,0) * (1-(nvl(msi.average_discount,0)/100)),
236: 49,msc_get_name.demand_quantity(med.plan_id,med.sr_instance_id,
237: med.supplier_id)*nvl(msi.list_price,0) * (1-(nvl(msi.average_discount,0)/100)),

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

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

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

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

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

259: md.using_requirement_quantity)*nvl(msi.list_price,0) * (1-(nvl(msi.average_discount,0)/100)),
260: 72,med.quantity *nvl(msi.list_price,0) * (1-(nvl(msi.average_discount,0)/100)),
261: 73, med.quantity *msi.standard_cost,
262: 74, med.quantity *msi.standard_cost,
263: 75, med.quantity *msi.standard_cost,
264: 76,med.quantity *nvl(msi.list_price,0) * (1-(nvl(msi.average_discount,0)/100)),
265: 77,med.quantity *nvl(msi.list_price,0) * (1-(nvl(msi.average_discount,0)/100)),
266: 81,med.quantity*nvl(msi.standard_cost,0),--DRP bnaghi
267: 82,med.quantity*nvl(msi.standard_cost,0),--DRP bnaghi

Line 266: 81,med.quantity*nvl(msi.standard_cost,0),--DRP bnaghi

262: 74, med.quantity *msi.standard_cost,
263: 75, med.quantity *msi.standard_cost,
264: 76,med.quantity *nvl(msi.list_price,0) * (1-(nvl(msi.average_discount,0)/100)),
265: 77,med.quantity *nvl(msi.list_price,0) * (1-(nvl(msi.average_discount,0)/100)),
266: 81,med.quantity*nvl(msi.standard_cost,0),--DRP bnaghi
267: 82,med.quantity*nvl(msi.standard_cost,0),--DRP bnaghi
268: 95,med.quantity*nvl(msi.standard_cost,0),--DRP bnaghi
269: 114,abs(med.quantity) *nvl(msi.list_price,0) * (1-(nvl(msi.average_discount,0)/100)),
270: to_number(null)) )exception_value,

Line 267: 82,med.quantity*nvl(msi.standard_cost,0),--DRP bnaghi

263: 75, med.quantity *msi.standard_cost,
264: 76,med.quantity *nvl(msi.list_price,0) * (1-(nvl(msi.average_discount,0)/100)),
265: 77,med.quantity *nvl(msi.list_price,0) * (1-(nvl(msi.average_discount,0)/100)),
266: 81,med.quantity*nvl(msi.standard_cost,0),--DRP bnaghi
267: 82,med.quantity*nvl(msi.standard_cost,0),--DRP bnaghi
268: 95,med.quantity*nvl(msi.standard_cost,0),--DRP bnaghi
269: 114,abs(med.quantity) *nvl(msi.list_price,0) * (1-(nvl(msi.average_discount,0)/100)),
270: to_number(null)) )exception_value,
271:

Line 268: 95,med.quantity*nvl(msi.standard_cost,0),--DRP bnaghi

264: 76,med.quantity *nvl(msi.list_price,0) * (1-(nvl(msi.average_discount,0)/100)),
265: 77,med.quantity *nvl(msi.list_price,0) * (1-(nvl(msi.average_discount,0)/100)),
266: 81,med.quantity*nvl(msi.standard_cost,0),--DRP bnaghi
267: 82,med.quantity*nvl(msi.standard_cost,0),--DRP bnaghi
268: 95,med.quantity*nvl(msi.standard_cost,0),--DRP bnaghi
269: 114,abs(med.quantity) *nvl(msi.list_price,0) * (1-(nvl(msi.average_discount,0)/100)),
270: to_number(null)) )exception_value,
271:
272: decode(l_plan_type,5,to_number(null), sum(decode( med.exception_type,

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

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

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

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

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

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

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

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

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

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