APPS.MSC_EXP_WF dependencies on MSC_GET_NAME

Line 35: 17, msc_get_name.project(

31: mtp.organization_code,
32: mi.item_name,mi.description,
33: ml.meaning,
34: nvl(decode(exp.exception_type,
35: 17, msc_get_name.project(
36: exp.number1,
37: exp.organization_id,
38: exp.plan_id,
39: exp.sr_instance_id),

Line 40: 18, msc_get_name.project(

36: exp.number1,
37: exp.organization_id,
38: exp.plan_id,
39: exp.sr_instance_id),
40: 18, msc_get_name.project(
41: exp.number1,
42: exp.organization_id,
43: exp.plan_id,
44: exp.sr_instance_id),

Line 45: msc_get_name.project(

41: exp.number1,
42: exp.organization_id,
43: exp.plan_id,
44: exp.sr_instance_id),
45: msc_get_name.project(
46: sup.project_id,
47: sup.organization_id,
48: sup.plan_id,
49: sup.sr_instance_id)), 'N/A'),

Line 51: 19, msc_get_name.project(

47: sup.organization_id,
48: sup.plan_id,
49: sup.sr_instance_id)), 'N/A'),
50: nvl(decode(exp.exception_type,
51: 19, msc_get_name.project(
52: md2.project_id,
53: md2.organization_id,
54: md2.plan_id,
55: md2.sr_instance_id), null), 'N/A'),

Line 57: 17, msc_get_name.task(

53: md2.organization_id,
54: md2.plan_id,
55: md2.sr_instance_id), null), 'N/A'),
56: nvl(decode(exp.exception_type,
57: 17, msc_get_name.task(
58: exp.number2,
59: exp.number1,
60: exp.organization_id,
61: exp.plan_id,

Line 63: 18, msc_get_name.task(

59: exp.number1,
60: exp.organization_id,
61: exp.plan_id,
62: exp.sr_instance_id),
63: 18, msc_get_name.task(
64: exp.number2,
65: exp.number1,
66: exp.organization_id,
67: exp.plan_id,

Line 69: msc_get_name.task(

65: exp.number1,
66: exp.organization_id,
67: exp.plan_id,
68: exp.sr_instance_id),
69: msc_get_name.task(
70: sup.task_id,
71: sup.project_id,
72: sup.organization_id,
73: sup.plan_id,

Line 76: 19, msc_get_name.task(

72: sup.organization_id,
73: sup.plan_id,
74: sup.sr_instance_id)), 'N/A'),
75: nvl(decode(exp.exception_type,
76: 19, msc_get_name.task(
77: md2.task_id,
78: md2.project_id,
79: md2.organization_id,
80: md2.plan_id,

Line 101: 49,msc_get_name.demand_quantity(exp.plan_id,exp.sr_instance_id,

97: DECODE(exp.EXCEPTION_TYPE, 9, sup.SCHEDULE_COMPRESS_DAYS,NULL),
98: decode(exp.exception_type,
99: 37,nvl(exp.number4,0)-nvl(exp.quantity,0),
100: 28,MSC_EXP_WF.SupplierCapacity(p_plan_id,exp.exception_detail_id),
101: 49,msc_get_name.demand_quantity(exp.plan_id,exp.sr_instance_id,
102: exp.supplier_id),
103: exp.quantity),
104: decode(exp.exception_type, 12, sup.lot_number),
105: decode(exp.exception_type, 1, NULL, 2, NULL, 3, NULL,

Line 108: 14, NVL(md.order_number,msc_get_name.designator(

104: decode(exp.exception_type, 12, sup.lot_number),
105: decode(exp.exception_type, 1, NULL, 2, NULL, 3, NULL,
106: 9, NVL(sup.order_number,exp.number1),12, NULL,
107: 13, md.order_number,
108: 14, NVL(md.order_number,msc_get_name.designator(
109: md.schedule_designator_id)),
110: 16, nvl(sup.order_number,sup.transaction_id),
111: 17, NULL, 18, NULL , 20, NULL,
112: 24, md.order_number, 25, md.order_number,

Line 113: 26, msc_get_name.designator(md.schedule_designator_id),

109: md.schedule_designator_id)),
110: 16, nvl(sup.order_number,sup.transaction_id),
111: 17, NULL, 18, NULL , 20, NULL,
112: 24, md.order_number, 25, md.order_number,
113: 26, msc_get_name.designator(md.schedule_designator_id),
114: 27, msc_get_name.designator(md.schedule_designator_id),
115: 28, NULL, 37, NULL, 70,md.order_number,
116: sup.order_number),
117: sup_ml.meaning,

Line 114: 27, msc_get_name.designator(md.schedule_designator_id),

110: 16, nvl(sup.order_number,sup.transaction_id),
111: 17, NULL, 18, NULL , 20, NULL,
112: 24, md.order_number, 25, md.order_number,
113: 26, msc_get_name.designator(md.schedule_designator_id),
114: 27, msc_get_name.designator(md.schedule_designator_id),
115: 28, NULL, 37, NULL, 70,md.order_number,
116: sup.order_number),
117: sup_ml.meaning,
118: msc_get_name.item_name(

Line 118: msc_get_name.item_name(

114: 27, msc_get_name.designator(md.schedule_designator_id),
115: 28, NULL, 37, NULL, 70,md.order_number,
116: sup.order_number),
117: sup_ml.meaning,
118: msc_get_name.item_name(
119: decode(exp.exception_type,
120: 15, md2.inventory_item_id, 16, md2.inventory_item_id,
121: 19, md2.inventory_item_id, 24, md.inventory_item_id,
122: 25, md.inventory_item_id, 26, md.inventory_item_id,

Line 125: msc_get_name.item_desc(

121: 19, md2.inventory_item_id, 24, md.inventory_item_id,
122: 25, md.inventory_item_id, 26, md.inventory_item_id,
123: 27, md.inventory_item_id, 49, exp.number1,null),
124: null,null,null),
125: msc_get_name.item_desc(
126: decode(exp.exception_type,
127: 15, md2.inventory_item_id, 16, md2.inventory_item_id,
128: 19, md2.inventory_item_id, 24, md.inventory_item_id,
129: 25, md.inventory_item_id, 26, md.inventory_item_id,

Line 135: 26,msc_get_name.designator(md.schedule_designator_id),

131: exp.organization_id,p_plan_id,exp.sr_instance_id),
132: decode(exp.exception_type,
133: 15,md2.order_number, 19,md2.order_number,
134: 24,md.order_number,25,md.order_number,
135: 26,msc_get_name.designator(md.schedule_designator_id),
136: 27,msc_get_name.designator(md.schedule_designator_id),
137: 49,msc_get_name.demand_order_number(exp.plan_id,
138: exp.sr_instance_id, exp.supplier_id),
139: NULL) ,

Line 136: 27,msc_get_name.designator(md.schedule_designator_id),

132: decode(exp.exception_type,
133: 15,md2.order_number, 19,md2.order_number,
134: 24,md.order_number,25,md.order_number,
135: 26,msc_get_name.designator(md.schedule_designator_id),
136: 27,msc_get_name.designator(md.schedule_designator_id),
137: 49,msc_get_name.demand_order_number(exp.plan_id,
138: exp.sr_instance_id, exp.supplier_id),
139: NULL) ,
140: null,

Line 137: 49,msc_get_name.demand_order_number(exp.plan_id,

133: 15,md2.order_number, 19,md2.order_number,
134: 24,md.order_number,25,md.order_number,
135: 26,msc_get_name.designator(md.schedule_designator_id),
136: 27,msc_get_name.designator(md.schedule_designator_id),
137: 49,msc_get_name.demand_order_number(exp.plan_id,
138: exp.sr_instance_id, exp.supplier_id),
139: NULL) ,
140: null,
141: decode(exp.exception_type, 49,

Line 142: msc_get_name.org_code(exp.number2, exp.sr_instance_id),

138: exp.sr_instance_id, exp.supplier_id),
139: NULL) ,
140: null,
141: decode(exp.exception_type, 49,
142: msc_get_name.org_code(exp.number2, exp.sr_instance_id),
143: 15,msc_get_name.org_code(md2.organization_id, md2.sr_instance_id),
144: 16,msc_get_name.org_code(md2.organization_id, md2.sr_instance_id),null),
145: decode(exp.exception_type, 28, exp.quantity, 37, exp.quantity,
146: 49, exp.quantity,

Line 143: 15,msc_get_name.org_code(md2.organization_id, md2.sr_instance_id),

139: NULL) ,
140: null,
141: decode(exp.exception_type, 49,
142: msc_get_name.org_code(exp.number2, exp.sr_instance_id),
143: 15,msc_get_name.org_code(md2.organization_id, md2.sr_instance_id),
144: 16,msc_get_name.org_code(md2.organization_id, md2.sr_instance_id),null),
145: decode(exp.exception_type, 28, exp.quantity, 37, exp.quantity,
146: 49, exp.quantity,
147: 15, md.using_requirement_quantity,

Line 144: 16,msc_get_name.org_code(md2.organization_id, md2.sr_instance_id),null),

140: null,
141: decode(exp.exception_type, 49,
142: msc_get_name.org_code(exp.number2, exp.sr_instance_id),
143: 15,msc_get_name.org_code(md2.organization_id, md2.sr_instance_id),
144: 16,msc_get_name.org_code(md2.organization_id, md2.sr_instance_id),null),
145: decode(exp.exception_type, 28, exp.quantity, 37, exp.quantity,
146: 49, exp.quantity,
147: 15, md.using_requirement_quantity,
148: 16, md.using_requirement_quantity,

Line 152: 3, msc_get_name.demand_quantity(exp.plan_id,exp.sr_instance_id,md2.demand_id),null),

148: 16, md.using_requirement_quantity,
149: 17, md.using_requirement_quantity,
150: 18, md.using_requirement_quantity,
151: 2, md.using_requirement_quantity,
152: 3, msc_get_name.demand_quantity(exp.plan_id,exp.sr_instance_id,md2.demand_id),null),
153: decode(exp.exception_type, 12, null, 13, null, 14, null,
154: 17, null, 18, null, 24, null, 25, null, 26, null,
155: 27, null, 28, null, 37, exp.number2, exp.number1),
156: decode(exp.exception_type, 49, msc_exp_wf.demand_order_type(exp.plan_id,exp.sr_instance_id,exp.supplier_id),sup.order_type),

Line 208: 17, msc_get_name.project(

204: mtp.organization_code,
205: mi.item_name,mi.description,
206: ml.meaning,
207: nvl(decode(exp.exception_type,
208: 17, msc_get_name.project(
209: exp.number1,
210: exp.organization_id,
211: exp.plan_id,
212: exp.sr_instance_id),

Line 213: 18, msc_get_name.project(

209: exp.number1,
210: exp.organization_id,
211: exp.plan_id,
212: exp.sr_instance_id),
213: 18, msc_get_name.project(
214: exp.number1,
215: exp.organization_id,
216: exp.plan_id,
217: exp.sr_instance_id),

Line 218: msc_get_name.project(

214: exp.number1,
215: exp.organization_id,
216: exp.plan_id,
217: exp.sr_instance_id),
218: msc_get_name.project(
219: sup.project_id,
220: sup.organization_id,
221: sup.plan_id,
222: sup.sr_instance_id)), 'N/A'),

Line 224: 19, msc_get_name.project(

220: sup.organization_id,
221: sup.plan_id,
222: sup.sr_instance_id)), 'N/A'),
223: nvl(decode(exp.exception_type,
224: 19, msc_get_name.project(
225: md2.project_id,
226: md2.organization_id,
227: md2.plan_id,
228: md2.sr_instance_id), null), 'N/A'),

Line 230: 17, msc_get_name.task(

226: md2.organization_id,
227: md2.plan_id,
228: md2.sr_instance_id), null), 'N/A'),
229: nvl(decode(exp.exception_type,
230: 17, msc_get_name.task(
231: exp.number2,
232: exp.number1,
233: exp.organization_id,
234: exp.plan_id,

Line 236: 18, msc_get_name.task(

232: exp.number1,
233: exp.organization_id,
234: exp.plan_id,
235: exp.sr_instance_id),
236: 18, msc_get_name.task(
237: exp.number2,
238: exp.number1,
239: exp.organization_id,
240: exp.plan_id,

Line 242: msc_get_name.task(

238: exp.number1,
239: exp.organization_id,
240: exp.plan_id,
241: exp.sr_instance_id),
242: msc_get_name.task(
243: sup.task_id,
244: sup.project_id,
245: sup.organization_id,
246: sup.plan_id,

Line 249: 19, msc_get_name.task(

245: sup.organization_id,
246: sup.plan_id,
247: sup.sr_instance_id)), 'N/A'),
248: nvl(decode(exp.exception_type,
249: 19, msc_get_name.task(
250: md2.task_id,
251: md2.project_id,
252: md2.organization_id,
253: md2.plan_id,

Line 275: 49,msc_get_name.demand_quantity(exp.plan_id,exp.sr_instance_id,

271: DECODE(exp.EXCEPTION_TYPE, 9, sup.SCHEDULE_COMPRESS_DAYS,NULL),
272: decode(exp.exception_type,
273: 37,nvl(exp.number4,0)-nvl(exp.quantity,0),
274: 28,MSC_EXP_WF.SupplierCapacity(p_plan_id,exp.exception_detail_id),
275: 49,msc_get_name.demand_quantity(exp.plan_id,exp.sr_instance_id,
276: exp.supplier_id),
277: exp.quantity),
278: decode(exp.exception_type, 12, sup.lot_number),
279: decode(exp.exception_type, 1, NULL, 2, NULL, 3, NULL,

Line 282: 14, NVL(md.order_number,msc_get_name.designator(

278: decode(exp.exception_type, 12, sup.lot_number),
279: decode(exp.exception_type, 1, NULL, 2, NULL, 3, NULL,
280: 9, NVL(sup.order_number,exp.number1),12, NULL,
281: 13, md.order_number,
282: 14, NVL(md.order_number,msc_get_name.designator(
283: md.schedule_designator_id)),
284: 16, nvl(sup.order_number,sup.transaction_id),
285: 17, NULL, 18, NULL , 20, NULL,
286: 24, md.order_number, 25, md.order_number,

Line 287: 26, msc_get_name.designator(md.schedule_designator_id),

283: md.schedule_designator_id)),
284: 16, nvl(sup.order_number,sup.transaction_id),
285: 17, NULL, 18, NULL , 20, NULL,
286: 24, md.order_number, 25, md.order_number,
287: 26, msc_get_name.designator(md.schedule_designator_id),
288: 27, msc_get_name.designator(md.schedule_designator_id),
289: 28, NULL, 37, NULL, 70,md.order_number, sup.order_number),
290: sup_ml.meaning,
291: msc_get_name.item_name(

Line 288: 27, msc_get_name.designator(md.schedule_designator_id),

284: 16, nvl(sup.order_number,sup.transaction_id),
285: 17, NULL, 18, NULL , 20, NULL,
286: 24, md.order_number, 25, md.order_number,
287: 26, msc_get_name.designator(md.schedule_designator_id),
288: 27, msc_get_name.designator(md.schedule_designator_id),
289: 28, NULL, 37, NULL, 70,md.order_number, sup.order_number),
290: sup_ml.meaning,
291: msc_get_name.item_name(
292: decode(exp.exception_type,

Line 291: msc_get_name.item_name(

287: 26, msc_get_name.designator(md.schedule_designator_id),
288: 27, msc_get_name.designator(md.schedule_designator_id),
289: 28, NULL, 37, NULL, 70,md.order_number, sup.order_number),
290: sup_ml.meaning,
291: msc_get_name.item_name(
292: decode(exp.exception_type,
293: 15, md2.inventory_item_id, 16, md2.inventory_item_id,
294: 19, md2.inventory_item_id, 24, md.inventory_item_id,
295: 25, md.inventory_item_id, 26, md.inventory_item_id,

Line 298: msc_get_name.item_desc(

294: 19, md2.inventory_item_id, 24, md.inventory_item_id,
295: 25, md.inventory_item_id, 26, md.inventory_item_id,
296: 27, md.inventory_item_id, 49, exp.number1, null),
297: null,null,null),
298: msc_get_name.item_desc(
299: decode(exp.exception_type,
300: 15, md2.inventory_item_id, 16, md2.inventory_item_id,
301: 19, md2.inventory_item_id, 24, md.inventory_item_id,
302: 25, md.inventory_item_id, 26, md.inventory_item_id,

Line 308: 26,msc_get_name.designator(md.schedule_designator_id),

304: exp.organization_id,p_plan_id,exp.sr_instance_id),
305: decode(exp.exception_type,
306: 15,md2.order_number, 19,md2.order_number,
307: 24,md.order_number,25,md.order_number,
308: 26,msc_get_name.designator(md.schedule_designator_id),
309: 27,msc_get_name.designator(md.schedule_designator_id),
310: 49,msc_get_name.demand_order_number(exp.plan_id,
311: exp.sr_instance_id, exp.supplier_id),
312: NULL) ,

Line 309: 27,msc_get_name.designator(md.schedule_designator_id),

305: decode(exp.exception_type,
306: 15,md2.order_number, 19,md2.order_number,
307: 24,md.order_number,25,md.order_number,
308: 26,msc_get_name.designator(md.schedule_designator_id),
309: 27,msc_get_name.designator(md.schedule_designator_id),
310: 49,msc_get_name.demand_order_number(exp.plan_id,
311: exp.sr_instance_id, exp.supplier_id),
312: NULL) ,
313: null,

Line 310: 49,msc_get_name.demand_order_number(exp.plan_id,

306: 15,md2.order_number, 19,md2.order_number,
307: 24,md.order_number,25,md.order_number,
308: 26,msc_get_name.designator(md.schedule_designator_id),
309: 27,msc_get_name.designator(md.schedule_designator_id),
310: 49,msc_get_name.demand_order_number(exp.plan_id,
311: exp.sr_instance_id, exp.supplier_id),
312: NULL) ,
313: null,
314: decode(exp.exception_type, 49,

Line 315: msc_get_name.org_code(exp.number2, exp.sr_instance_id),

311: exp.sr_instance_id, exp.supplier_id),
312: NULL) ,
313: null,
314: decode(exp.exception_type, 49,
315: msc_get_name.org_code(exp.number2, exp.sr_instance_id),
316: 15,msc_get_name.org_code(md2.organization_id, md2.sr_instance_id),
317: 16,msc_get_name.org_code(md2.organization_id, md2.sr_instance_id),null),
318: decode(exp.exception_type, 28, exp.quantity, 37, exp.quantity,
319: 49, exp.quantity,

Line 316: 15,msc_get_name.org_code(md2.organization_id, md2.sr_instance_id),

312: NULL) ,
313: null,
314: decode(exp.exception_type, 49,
315: msc_get_name.org_code(exp.number2, exp.sr_instance_id),
316: 15,msc_get_name.org_code(md2.organization_id, md2.sr_instance_id),
317: 16,msc_get_name.org_code(md2.organization_id, md2.sr_instance_id),null),
318: decode(exp.exception_type, 28, exp.quantity, 37, exp.quantity,
319: 49, exp.quantity,
320: 15, md.using_requirement_quantity,

Line 317: 16,msc_get_name.org_code(md2.organization_id, md2.sr_instance_id),null),

313: null,
314: decode(exp.exception_type, 49,
315: msc_get_name.org_code(exp.number2, exp.sr_instance_id),
316: 15,msc_get_name.org_code(md2.organization_id, md2.sr_instance_id),
317: 16,msc_get_name.org_code(md2.organization_id, md2.sr_instance_id),null),
318: decode(exp.exception_type, 28, exp.quantity, 37, exp.quantity,
319: 49, exp.quantity,
320: 15, md.using_requirement_quantity,
321: 16, md.using_requirement_quantity,

Line 325: 3, msc_get_name.demand_quantity(exp.plan_id,exp.sr_instance_id,md2.demand_id),null),

321: 16, md.using_requirement_quantity,
322: 17, md.using_requirement_quantity,
323: 18, md.using_requirement_quantity,
324: 2, md.using_requirement_quantity,
325: 3, msc_get_name.demand_quantity(exp.plan_id,exp.sr_instance_id,md2.demand_id),null),
326: decode(exp.exception_type, 12, null, 13, null, 14, null,
327: 17, null, 18, null, 24, null, 25, null, 26, null,
328: 27, null, 28, null, 37, exp.number2, exp.number1),
329: decode(exp.exception_type, 49, msc_exp_wf.demand_order_type(exp.plan_id,exp.sr_instance_id,exp.supplier_id),sup.order_type),

Line 383: 17, msc_get_name.project(

379: mtp.organization_code,
380: mi.item_name,mi.description,
381: ml.meaning,
382: nvl(decode(exp.exception_type,
383: 17, msc_get_name.project(
384: exp.number1,
385: exp.organization_id,
386: exp.plan_id,
387: exp.sr_instance_id),

Line 388: 18, msc_get_name.project(

384: exp.number1,
385: exp.organization_id,
386: exp.plan_id,
387: exp.sr_instance_id),
388: 18, msc_get_name.project(
389: exp.number1,
390: exp.organization_id,
391: exp.plan_id,
392: exp.sr_instance_id),

Line 393: msc_get_name.project(

389: exp.number1,
390: exp.organization_id,
391: exp.plan_id,
392: exp.sr_instance_id),
393: msc_get_name.project(
394: sup.project_id,
395: sup.organization_id,
396: sup.plan_id,
397: sup.sr_instance_id)), 'N/A'),

Line 399: 19, msc_get_name.project(

395: sup.organization_id,
396: sup.plan_id,
397: sup.sr_instance_id)), 'N/A'),
398: nvl(decode(exp.exception_type,
399: 19, msc_get_name.project(
400: md2.project_id,
401: md2.organization_id,
402: md2.plan_id,
403: md2.sr_instance_id), null), 'N/A'),

Line 405: 17, msc_get_name.task(

401: md2.organization_id,
402: md2.plan_id,
403: md2.sr_instance_id), null), 'N/A'),
404: nvl(decode(exp.exception_type,
405: 17, msc_get_name.task(
406: exp.number2,
407: exp.number1,
408: exp.organization_id,
409: exp.plan_id,

Line 411: 18, msc_get_name.task(

407: exp.number1,
408: exp.organization_id,
409: exp.plan_id,
410: exp.sr_instance_id),
411: 18, msc_get_name.task(
412: exp.number2,
413: exp.number1,
414: exp.organization_id,
415: exp.plan_id,

Line 417: msc_get_name.task(

413: exp.number1,
414: exp.organization_id,
415: exp.plan_id,
416: exp.sr_instance_id),
417: msc_get_name.task(
418: sup.task_id,
419: sup.project_id,
420: sup.organization_id,
421: sup.plan_id,

Line 424: 19, msc_get_name.task(

420: sup.organization_id,
421: sup.plan_id,
422: sup.sr_instance_id)), 'N/A'),
423: nvl(decode(exp.exception_type,
424: 19, msc_get_name.task(
425: md2.task_id,
426: md2.project_id,
427: md2.organization_id,
428: md2.plan_id,

Line 450: 49,msc_get_name.demand_quantity(exp.plan_id,exp.sr_instance_id,

446: DECODE(exp.EXCEPTION_TYPE, 9, sup.SCHEDULE_COMPRESS_DAYS,NULL),
447: decode(exp.exception_type,
448: 37,nvl(exp.number4,0)-nvl(exp.quantity,0),
449: 28,MSC_EXP_WF.SupplierCapacity(p_plan_id,exp.exception_detail_id),
450: 49,msc_get_name.demand_quantity(exp.plan_id,exp.sr_instance_id,
451: exp.supplier_id),
452: exp.quantity),
453: decode(exp.exception_type, 12, sup.lot_number),
454: decode(exp.exception_type, 1, NULL, 2, NULL, 3, NULL,

Line 457: 14, NVL(md.order_number,msc_get_name.designator(

453: decode(exp.exception_type, 12, sup.lot_number),
454: decode(exp.exception_type, 1, NULL, 2, NULL, 3, NULL,
455: 9, NVL(sup.order_number,exp.number1),12, NULL,
456: 13, md.order_number,
457: 14, NVL(md.order_number,msc_get_name.designator(
458: md.schedule_designator_id)),
459: 16, nvl(sup.order_number,sup.transaction_id),
460: 17, NULL, 18, NULL , 20, NULL,
461: 24, md.order_number, 25, md.order_number,

Line 462: 26, msc_get_name.designator(md.schedule_designator_id),

458: md.schedule_designator_id)),
459: 16, nvl(sup.order_number,sup.transaction_id),
460: 17, NULL, 18, NULL , 20, NULL,
461: 24, md.order_number, 25, md.order_number,
462: 26, msc_get_name.designator(md.schedule_designator_id),
463: 27, msc_get_name.designator(md.schedule_designator_id),
464: 28, NULL, 37, NULL, 70,md.order_number, sup.order_number),
465: sup_ml.meaning,
466: msc_get_name.item_name(

Line 463: 27, msc_get_name.designator(md.schedule_designator_id),

459: 16, nvl(sup.order_number,sup.transaction_id),
460: 17, NULL, 18, NULL , 20, NULL,
461: 24, md.order_number, 25, md.order_number,
462: 26, msc_get_name.designator(md.schedule_designator_id),
463: 27, msc_get_name.designator(md.schedule_designator_id),
464: 28, NULL, 37, NULL, 70,md.order_number, sup.order_number),
465: sup_ml.meaning,
466: msc_get_name.item_name(
467: decode(exp.exception_type,

Line 466: msc_get_name.item_name(

462: 26, msc_get_name.designator(md.schedule_designator_id),
463: 27, msc_get_name.designator(md.schedule_designator_id),
464: 28, NULL, 37, NULL, 70,md.order_number, sup.order_number),
465: sup_ml.meaning,
466: msc_get_name.item_name(
467: decode(exp.exception_type,
468: 15, md2.inventory_item_id, 16, md2.inventory_item_id,
469: 19, md2.inventory_item_id, 24, md.inventory_item_id,
470: 25, md.inventory_item_id, 26, md.inventory_item_id,

Line 473: msc_get_name.item_desc(

469: 19, md2.inventory_item_id, 24, md.inventory_item_id,
470: 25, md.inventory_item_id, 26, md.inventory_item_id,
471: 27, md.inventory_item_id, 49, exp.number1,null),
472: null,null,null),
473: msc_get_name.item_desc(
474: decode(exp.exception_type,
475: 15, md2.inventory_item_id, 16, md2.inventory_item_id,
476: 19, md2.inventory_item_id, 24, md.inventory_item_id,
477: 25, md.inventory_item_id, 26, md.inventory_item_id,

Line 483: 26,msc_get_name.designator(md.schedule_designator_id),

479: exp.organization_id,p_plan_id,exp.sr_instance_id),
480: decode(exp.exception_type,
481: 15,md2.order_number, 19,md2.order_number,
482: 24,md.order_number,25,md.order_number,
483: 26,msc_get_name.designator(md.schedule_designator_id),
484: 27,msc_get_name.designator(md.schedule_designator_id),
485: 49,msc_get_name.demand_order_number(exp.plan_id,
486: exp.sr_instance_id, exp.supplier_id),
487: NULL) ,

Line 484: 27,msc_get_name.designator(md.schedule_designator_id),

480: decode(exp.exception_type,
481: 15,md2.order_number, 19,md2.order_number,
482: 24,md.order_number,25,md.order_number,
483: 26,msc_get_name.designator(md.schedule_designator_id),
484: 27,msc_get_name.designator(md.schedule_designator_id),
485: 49,msc_get_name.demand_order_number(exp.plan_id,
486: exp.sr_instance_id, exp.supplier_id),
487: NULL) ,
488: null,

Line 485: 49,msc_get_name.demand_order_number(exp.plan_id,

481: 15,md2.order_number, 19,md2.order_number,
482: 24,md.order_number,25,md.order_number,
483: 26,msc_get_name.designator(md.schedule_designator_id),
484: 27,msc_get_name.designator(md.schedule_designator_id),
485: 49,msc_get_name.demand_order_number(exp.plan_id,
486: exp.sr_instance_id, exp.supplier_id),
487: NULL) ,
488: null,
489: decode(exp.exception_type, 49,

Line 490: msc_get_name.org_code(exp.number2, exp.sr_instance_id),

486: exp.sr_instance_id, exp.supplier_id),
487: NULL) ,
488: null,
489: decode(exp.exception_type, 49,
490: msc_get_name.org_code(exp.number2, exp.sr_instance_id),
491: 15,msc_get_name.org_code(md2.organization_id, md2.sr_instance_id),
492: 16,msc_get_name.org_code(md2.organization_id, md2.sr_instance_id),null),
493: decode(exp.exception_type, 28, exp.quantity, 37, exp.quantity,
494: 49, exp.quantity,

Line 491: 15,msc_get_name.org_code(md2.organization_id, md2.sr_instance_id),

487: NULL) ,
488: null,
489: decode(exp.exception_type, 49,
490: msc_get_name.org_code(exp.number2, exp.sr_instance_id),
491: 15,msc_get_name.org_code(md2.organization_id, md2.sr_instance_id),
492: 16,msc_get_name.org_code(md2.organization_id, md2.sr_instance_id),null),
493: decode(exp.exception_type, 28, exp.quantity, 37, exp.quantity,
494: 49, exp.quantity,
495: 15, md.using_requirement_quantity,

Line 492: 16,msc_get_name.org_code(md2.organization_id, md2.sr_instance_id),null),

488: null,
489: decode(exp.exception_type, 49,
490: msc_get_name.org_code(exp.number2, exp.sr_instance_id),
491: 15,msc_get_name.org_code(md2.organization_id, md2.sr_instance_id),
492: 16,msc_get_name.org_code(md2.organization_id, md2.sr_instance_id),null),
493: decode(exp.exception_type, 28, exp.quantity, 37, exp.quantity,
494: 49, exp.quantity,
495: 15, md.using_requirement_quantity,
496: 16, md.using_requirement_quantity,

Line 500: 3, msc_get_name.demand_quantity(exp.plan_id,exp.sr_instance_id,md2.demand_id),null),

496: 16, md.using_requirement_quantity,
497: 17, md.using_requirement_quantity,
498: 18, md.using_requirement_quantity,
499: 2, md.using_requirement_quantity,
500: 3, msc_get_name.demand_quantity(exp.plan_id,exp.sr_instance_id,md2.demand_id),null),
501: decode(exp.exception_type, 12, null, 13, null, 14, null,
502: 17, null, 18, null, 24, null, 25, null, 26, null,
503: 27, null, 28, null, 37, exp.number2, exp.number1),
504: decode(exp.exception_type, 49, msc_exp_wf.demand_order_type(exp.plan_id,exp.sr_instance_id,exp.supplier_id),sup.order_type),

Line 1056: msc_get_name.customer_site(md.customer_site_id) customer_site,

1052: md.shipping_method_code new_ship_method,
1053: md.orig_shipping_method_code old_ship_method,
1054: md.orig_intransit_lead_time old_lead_time,
1055: md.intransit_lead_time new_lead_time,
1056: msc_get_name.customer_site(md.customer_site_id) customer_site,
1057: msc_get_name.org_code(md.original_org_id,
1058: md.original_inst_id) org_code,
1059: msc_get_name.org_code(md.organization_id,md.sr_instance_id) to_org,
1060: md.demand_id,

Line 1057: msc_get_name.org_code(md.original_org_id,

1053: md.orig_shipping_method_code old_ship_method,
1054: md.orig_intransit_lead_time old_lead_time,
1055: md.intransit_lead_time new_lead_time,
1056: msc_get_name.customer_site(md.customer_site_id) customer_site,
1057: msc_get_name.org_code(md.original_org_id,
1058: md.original_inst_id) org_code,
1059: msc_get_name.org_code(md.organization_id,md.sr_instance_id) to_org,
1060: md.demand_id,
1061: md.latest_acceptable_date,

Line 1059: msc_get_name.org_code(md.organization_id,md.sr_instance_id) to_org,

1055: md.intransit_lead_time new_lead_time,
1056: msc_get_name.customer_site(md.customer_site_id) customer_site,
1057: msc_get_name.org_code(md.original_org_id,
1058: md.original_inst_id) org_code,
1059: msc_get_name.org_code(md.organization_id,md.sr_instance_id) to_org,
1060: md.demand_id,
1061: md.latest_acceptable_date,
1062: msc_get_name.lookup_meaning('SYS_YES_NO',md.atp_override_flag) atp_override_flag
1063: from msc_demands md,

Line 1062: msc_get_name.lookup_meaning('SYS_YES_NO',md.atp_override_flag) atp_override_flag

1058: md.original_inst_id) org_code,
1059: msc_get_name.org_code(md.organization_id,md.sr_instance_id) to_org,
1060: md.demand_id,
1061: md.latest_acceptable_date,
1062: msc_get_name.lookup_meaning('SYS_YES_NO',md.atp_override_flag) atp_override_flag
1063: from msc_demands md,
1064: msc_exception_details med
1065: where med.plan_id = md.plan_id
1066: and med.number1 = md.demand_id