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_ANALYSIS_SAFETY_STOCK dependencies on DBMS_OUTPUT

Line 200: dbms_output.put('plan_id,inst_id,org_id,item_id,cat_id,record,lwop,start,end,period_start,period_nr,weeknr,achieved_ss,');

196: BEGIN
197: IF do_debug = FALSE THEN
198: RETURN;
199: END IF;
200: dbms_output.put('plan_id,inst_id,org_id,item_id,cat_id,record,lwop,start,end,period_start,period_nr,weeknr,achieved_ss,');
201: dbms_output.put('achieved_ss_dl,target_ss,target_ss_dl,target_ss_ds,userdef_ss,userdef_ss_dl,userdef_ss_ds,num_ss,delivered,');
202: dbms_output.put_line('required,target_sl,num_target_sl,customer_id');
203: END;
204:

Line 201: dbms_output.put('achieved_ss_dl,target_ss,target_ss_dl,target_ss_ds,userdef_ss,userdef_ss_dl,userdef_ss_ds,num_ss,delivered,');

197: IF do_debug = FALSE THEN
198: RETURN;
199: END IF;
200: dbms_output.put('plan_id,inst_id,org_id,item_id,cat_id,record,lwop,start,end,period_start,period_nr,weeknr,achieved_ss,');
201: dbms_output.put('achieved_ss_dl,target_ss,target_ss_dl,target_ss_ds,userdef_ss,userdef_ss_dl,userdef_ss_ds,num_ss,delivered,');
202: dbms_output.put_line('required,target_sl,num_target_sl,customer_id');
203: END;
204:
205: PROCEDURE schedule_dump_record(aRecord BUCKET)

Line 202: dbms_output.put_line('required,target_sl,num_target_sl,customer_id');

198: RETURN;
199: END IF;
200: dbms_output.put('plan_id,inst_id,org_id,item_id,cat_id,record,lwop,start,end,period_start,period_nr,weeknr,achieved_ss,');
201: dbms_output.put('achieved_ss_dl,target_ss,target_ss_dl,target_ss_ds,userdef_ss,userdef_ss_dl,userdef_ss_ds,num_ss,delivered,');
202: dbms_output.put_line('required,target_sl,num_target_sl,customer_id');
203: END;
204:
205: PROCEDURE schedule_dump_record(aRecord BUCKET)
206: IS

Line 212: dbms_output.put('"'||aRecord.plan_id || '","' || aRecord.instance_id || '",');

208:
209: IF do_debug = FALSE THEN
210: RETURN;
211: END IF;
212: dbms_output.put('"'||aRecord.plan_id || '","' || aRecord.instance_id || '",');
213: dbms_output.put('"'|| aRecord.org_id || '","' || aRecord.item_id || '",');
214: dbms_output.put('"' || aRecord.sr_category_id || '",');
215: IF aRecord.record_type = RECORD_SERVICE_LEVEL THEN
216: DBMS_OUTPUT.put('"SL",');

Line 213: dbms_output.put('"'|| aRecord.org_id || '","' || aRecord.item_id || '",');

209: IF do_debug = FALSE THEN
210: RETURN;
211: END IF;
212: dbms_output.put('"'||aRecord.plan_id || '","' || aRecord.instance_id || '",');
213: dbms_output.put('"'|| aRecord.org_id || '","' || aRecord.item_id || '",');
214: dbms_output.put('"' || aRecord.sr_category_id || '",');
215: IF aRecord.record_type = RECORD_SERVICE_LEVEL THEN
216: DBMS_OUTPUT.put('"SL",');
217: ELSIF aRecord.record_type = RECORD_SAFETY_STOCK THEN

Line 214: dbms_output.put('"' || aRecord.sr_category_id || '",');

210: RETURN;
211: END IF;
212: dbms_output.put('"'||aRecord.plan_id || '","' || aRecord.instance_id || '",');
213: dbms_output.put('"'|| aRecord.org_id || '","' || aRecord.item_id || '",');
214: dbms_output.put('"' || aRecord.sr_category_id || '",');
215: IF aRecord.record_type = RECORD_SERVICE_LEVEL THEN
216: DBMS_OUTPUT.put('"SL",');
217: ELSIF aRecord.record_type = RECORD_SAFETY_STOCK THEN
218: DBMS_OUTPUT.put('"SS",');

Line 216: DBMS_OUTPUT.put('"SL",');

212: dbms_output.put('"'||aRecord.plan_id || '","' || aRecord.instance_id || '",');
213: dbms_output.put('"'|| aRecord.org_id || '","' || aRecord.item_id || '",');
214: dbms_output.put('"' || aRecord.sr_category_id || '",');
215: IF aRecord.record_type = RECORD_SERVICE_LEVEL THEN
216: DBMS_OUTPUT.put('"SL",');
217: ELSIF aRecord.record_type = RECORD_SAFETY_STOCK THEN
218: DBMS_OUTPUT.put('"SS",');
219: ELSIF aRecord.record_type = RECORD_TARGET_SL_VIEWBY_ITEM THEN
220: DBMS_OUTPUT.put('"TLI",');

Line 218: DBMS_OUTPUT.put('"SS",');

214: dbms_output.put('"' || aRecord.sr_category_id || '",');
215: IF aRecord.record_type = RECORD_SERVICE_LEVEL THEN
216: DBMS_OUTPUT.put('"SL",');
217: ELSIF aRecord.record_type = RECORD_SAFETY_STOCK THEN
218: DBMS_OUTPUT.put('"SS",');
219: ELSIF aRecord.record_type = RECORD_TARGET_SL_VIEWBY_ITEM THEN
220: DBMS_OUTPUT.put('"TLI",');
221: ELSIF aRecord.record_type = RECORD_TARGET_SL_VIEWBY_CUST THEN
222: DBMS_OUTPUT.put('"TLC",');

Line 220: DBMS_OUTPUT.put('"TLI",');

216: DBMS_OUTPUT.put('"SL",');
217: ELSIF aRecord.record_type = RECORD_SAFETY_STOCK THEN
218: DBMS_OUTPUT.put('"SS",');
219: ELSIF aRecord.record_type = RECORD_TARGET_SL_VIEWBY_ITEM THEN
220: DBMS_OUTPUT.put('"TLI",');
221: ELSIF aRecord.record_type = RECORD_TARGET_SL_VIEWBY_CUST THEN
222: DBMS_OUTPUT.put('"TLC",');
223: END IF;
224: dbms_output.put('"' || aRecord.last_week_of_period || '",');

Line 222: DBMS_OUTPUT.put('"TLC",');

218: DBMS_OUTPUT.put('"SS",');
219: ELSIF aRecord.record_type = RECORD_TARGET_SL_VIEWBY_ITEM THEN
220: DBMS_OUTPUT.put('"TLI",');
221: ELSIF aRecord.record_type = RECORD_TARGET_SL_VIEWBY_CUST THEN
222: DBMS_OUTPUT.put('"TLC",');
223: END IF;
224: dbms_output.put('"' || aRecord.last_week_of_period || '",');
225: dbms_output.put('"' || aRecord.bkt_start_date || '","' || aRecord.bkt_end_date || '",');
226: dbms_output.put('"' || aRecord.period_start_date || '",');

Line 224: dbms_output.put('"' || aRecord.last_week_of_period || '",');

220: DBMS_OUTPUT.put('"TLI",');
221: ELSIF aRecord.record_type = RECORD_TARGET_SL_VIEWBY_CUST THEN
222: DBMS_OUTPUT.put('"TLC",');
223: END IF;
224: dbms_output.put('"' || aRecord.last_week_of_period || '",');
225: dbms_output.put('"' || aRecord.bkt_start_date || '","' || aRecord.bkt_end_date || '",');
226: dbms_output.put('"' || aRecord.period_start_date || '",');
227: dbms_output.put('"' || aRecord.week_nr || '","' || aRecord.period_nr || '",');
228: dbms_output.put('"' || aRecord.achieved_ss_qty || '",');

Line 225: dbms_output.put('"' || aRecord.bkt_start_date || '","' || aRecord.bkt_end_date || '",');

221: ELSIF aRecord.record_type = RECORD_TARGET_SL_VIEWBY_CUST THEN
222: DBMS_OUTPUT.put('"TLC",');
223: END IF;
224: dbms_output.put('"' || aRecord.last_week_of_period || '",');
225: dbms_output.put('"' || aRecord.bkt_start_date || '","' || aRecord.bkt_end_date || '",');
226: dbms_output.put('"' || aRecord.period_start_date || '",');
227: dbms_output.put('"' || aRecord.week_nr || '","' || aRecord.period_nr || '",');
228: dbms_output.put('"' || aRecord.achieved_ss_qty || '",');
229: dbms_output.put('"' || aRecord.achieved_ss_dollars || '",');

Line 226: dbms_output.put('"' || aRecord.period_start_date || '",');

222: DBMS_OUTPUT.put('"TLC",');
223: END IF;
224: dbms_output.put('"' || aRecord.last_week_of_period || '",');
225: dbms_output.put('"' || aRecord.bkt_start_date || '","' || aRecord.bkt_end_date || '",');
226: dbms_output.put('"' || aRecord.period_start_date || '",');
227: dbms_output.put('"' || aRecord.week_nr || '","' || aRecord.period_nr || '",');
228: dbms_output.put('"' || aRecord.achieved_ss_qty || '",');
229: dbms_output.put('"' || aRecord.achieved_ss_dollars || '",');
230: dbms_output.put('"' || aRecord.target_ss_qty || '",');

Line 227: dbms_output.put('"' || aRecord.week_nr || '","' || aRecord.period_nr || '",');

223: END IF;
224: dbms_output.put('"' || aRecord.last_week_of_period || '",');
225: dbms_output.put('"' || aRecord.bkt_start_date || '","' || aRecord.bkt_end_date || '",');
226: dbms_output.put('"' || aRecord.period_start_date || '",');
227: dbms_output.put('"' || aRecord.week_nr || '","' || aRecord.period_nr || '",');
228: dbms_output.put('"' || aRecord.achieved_ss_qty || '",');
229: dbms_output.put('"' || aRecord.achieved_ss_dollars || '",');
230: dbms_output.put('"' || aRecord.target_ss_qty || '",');
231: dbms_output.put('"' || aRecord.target_ss_dollars || '",');

Line 228: dbms_output.put('"' || aRecord.achieved_ss_qty || '",');

224: dbms_output.put('"' || aRecord.last_week_of_period || '",');
225: dbms_output.put('"' || aRecord.bkt_start_date || '","' || aRecord.bkt_end_date || '",');
226: dbms_output.put('"' || aRecord.period_start_date || '",');
227: dbms_output.put('"' || aRecord.week_nr || '","' || aRecord.period_nr || '",');
228: dbms_output.put('"' || aRecord.achieved_ss_qty || '",');
229: dbms_output.put('"' || aRecord.achieved_ss_dollars || '",');
230: dbms_output.put('"' || aRecord.target_ss_qty || '",');
231: dbms_output.put('"' || aRecord.target_ss_dollars || '",');
232: dbms_output.put('"' || aRecord.target_ss_days || '",');

Line 229: dbms_output.put('"' || aRecord.achieved_ss_dollars || '",');

225: dbms_output.put('"' || aRecord.bkt_start_date || '","' || aRecord.bkt_end_date || '",');
226: dbms_output.put('"' || aRecord.period_start_date || '",');
227: dbms_output.put('"' || aRecord.week_nr || '","' || aRecord.period_nr || '",');
228: dbms_output.put('"' || aRecord.achieved_ss_qty || '",');
229: dbms_output.put('"' || aRecord.achieved_ss_dollars || '",');
230: dbms_output.put('"' || aRecord.target_ss_qty || '",');
231: dbms_output.put('"' || aRecord.target_ss_dollars || '",');
232: dbms_output.put('"' || aRecord.target_ss_days || '",');
233: dbms_output.put('"' || aRecord.userdef_ss_qty || '",');

Line 230: dbms_output.put('"' || aRecord.target_ss_qty || '",');

226: dbms_output.put('"' || aRecord.period_start_date || '",');
227: dbms_output.put('"' || aRecord.week_nr || '","' || aRecord.period_nr || '",');
228: dbms_output.put('"' || aRecord.achieved_ss_qty || '",');
229: dbms_output.put('"' || aRecord.achieved_ss_dollars || '",');
230: dbms_output.put('"' || aRecord.target_ss_qty || '",');
231: dbms_output.put('"' || aRecord.target_ss_dollars || '",');
232: dbms_output.put('"' || aRecord.target_ss_days || '",');
233: dbms_output.put('"' || aRecord.userdef_ss_qty || '",');
234: dbms_output.put('"' || aRecord.userdef_ss_dollars || '",');

Line 231: dbms_output.put('"' || aRecord.target_ss_dollars || '",');

227: dbms_output.put('"' || aRecord.week_nr || '","' || aRecord.period_nr || '",');
228: dbms_output.put('"' || aRecord.achieved_ss_qty || '",');
229: dbms_output.put('"' || aRecord.achieved_ss_dollars || '",');
230: dbms_output.put('"' || aRecord.target_ss_qty || '",');
231: dbms_output.put('"' || aRecord.target_ss_dollars || '",');
232: dbms_output.put('"' || aRecord.target_ss_days || '",');
233: dbms_output.put('"' || aRecord.userdef_ss_qty || '",');
234: dbms_output.put('"' || aRecord.userdef_ss_dollars || '",');
235: dbms_output.put('"' || aRecord.userdef_ss_days || '",');

Line 232: dbms_output.put('"' || aRecord.target_ss_days || '",');

228: dbms_output.put('"' || aRecord.achieved_ss_qty || '",');
229: dbms_output.put('"' || aRecord.achieved_ss_dollars || '",');
230: dbms_output.put('"' || aRecord.target_ss_qty || '",');
231: dbms_output.put('"' || aRecord.target_ss_dollars || '",');
232: dbms_output.put('"' || aRecord.target_ss_days || '",');
233: dbms_output.put('"' || aRecord.userdef_ss_qty || '",');
234: dbms_output.put('"' || aRecord.userdef_ss_dollars || '",');
235: dbms_output.put('"' || aRecord.userdef_ss_days || '",');
236: dbms_output.put('"' || aRecord.num_safety_stock || '",');

Line 233: dbms_output.put('"' || aRecord.userdef_ss_qty || '",');

229: dbms_output.put('"' || aRecord.achieved_ss_dollars || '",');
230: dbms_output.put('"' || aRecord.target_ss_qty || '",');
231: dbms_output.put('"' || aRecord.target_ss_dollars || '",');
232: dbms_output.put('"' || aRecord.target_ss_days || '",');
233: dbms_output.put('"' || aRecord.userdef_ss_qty || '",');
234: dbms_output.put('"' || aRecord.userdef_ss_dollars || '",');
235: dbms_output.put('"' || aRecord.userdef_ss_days || '",');
236: dbms_output.put('"' || aRecord.num_safety_stock || '",');
237: dbms_output.put('"' || aRecord.delivered_quantity || '",');

Line 234: dbms_output.put('"' || aRecord.userdef_ss_dollars || '",');

230: dbms_output.put('"' || aRecord.target_ss_qty || '",');
231: dbms_output.put('"' || aRecord.target_ss_dollars || '",');
232: dbms_output.put('"' || aRecord.target_ss_days || '",');
233: dbms_output.put('"' || aRecord.userdef_ss_qty || '",');
234: dbms_output.put('"' || aRecord.userdef_ss_dollars || '",');
235: dbms_output.put('"' || aRecord.userdef_ss_days || '",');
236: dbms_output.put('"' || aRecord.num_safety_stock || '",');
237: dbms_output.put('"' || aRecord.delivered_quantity || '",');
238: dbms_output.put('"' || aRecord.required_quantity || '",');

Line 235: dbms_output.put('"' || aRecord.userdef_ss_days || '",');

231: dbms_output.put('"' || aRecord.target_ss_dollars || '",');
232: dbms_output.put('"' || aRecord.target_ss_days || '",');
233: dbms_output.put('"' || aRecord.userdef_ss_qty || '",');
234: dbms_output.put('"' || aRecord.userdef_ss_dollars || '",');
235: dbms_output.put('"' || aRecord.userdef_ss_days || '",');
236: dbms_output.put('"' || aRecord.num_safety_stock || '",');
237: dbms_output.put('"' || aRecord.delivered_quantity || '",');
238: dbms_output.put('"' || aRecord.required_quantity || '",');
239: dbms_output.put('"' || aRecord.target_service_level || '",');

Line 236: dbms_output.put('"' || aRecord.num_safety_stock || '",');

232: dbms_output.put('"' || aRecord.target_ss_days || '",');
233: dbms_output.put('"' || aRecord.userdef_ss_qty || '",');
234: dbms_output.put('"' || aRecord.userdef_ss_dollars || '",');
235: dbms_output.put('"' || aRecord.userdef_ss_days || '",');
236: dbms_output.put('"' || aRecord.num_safety_stock || '",');
237: dbms_output.put('"' || aRecord.delivered_quantity || '",');
238: dbms_output.put('"' || aRecord.required_quantity || '",');
239: dbms_output.put('"' || aRecord.target_service_level || '",');
240: dbms_output.put('"' || aRecord.num_target_service_level || '",');

Line 237: dbms_output.put('"' || aRecord.delivered_quantity || '",');

233: dbms_output.put('"' || aRecord.userdef_ss_qty || '",');
234: dbms_output.put('"' || aRecord.userdef_ss_dollars || '",');
235: dbms_output.put('"' || aRecord.userdef_ss_days || '",');
236: dbms_output.put('"' || aRecord.num_safety_stock || '",');
237: dbms_output.put('"' || aRecord.delivered_quantity || '",');
238: dbms_output.put('"' || aRecord.required_quantity || '",');
239: dbms_output.put('"' || aRecord.target_service_level || '",');
240: dbms_output.put('"' || aRecord.num_target_service_level || '",');
241: dbms_output.put_line('"' || aRecord.partner_id || '"');

Line 238: dbms_output.put('"' || aRecord.required_quantity || '",');

234: dbms_output.put('"' || aRecord.userdef_ss_dollars || '",');
235: dbms_output.put('"' || aRecord.userdef_ss_days || '",');
236: dbms_output.put('"' || aRecord.num_safety_stock || '",');
237: dbms_output.put('"' || aRecord.delivered_quantity || '",');
238: dbms_output.put('"' || aRecord.required_quantity || '",');
239: dbms_output.put('"' || aRecord.target_service_level || '",');
240: dbms_output.put('"' || aRecord.num_target_service_level || '",');
241: dbms_output.put_line('"' || aRecord.partner_id || '"');
242: END;

Line 239: dbms_output.put('"' || aRecord.target_service_level || '",');

235: dbms_output.put('"' || aRecord.userdef_ss_days || '",');
236: dbms_output.put('"' || aRecord.num_safety_stock || '",');
237: dbms_output.put('"' || aRecord.delivered_quantity || '",');
238: dbms_output.put('"' || aRecord.required_quantity || '",');
239: dbms_output.put('"' || aRecord.target_service_level || '",');
240: dbms_output.put('"' || aRecord.num_target_service_level || '",');
241: dbms_output.put_line('"' || aRecord.partner_id || '"');
242: END;
243:

Line 240: dbms_output.put('"' || aRecord.num_target_service_level || '",');

236: dbms_output.put('"' || aRecord.num_safety_stock || '",');
237: dbms_output.put('"' || aRecord.delivered_quantity || '",');
238: dbms_output.put('"' || aRecord.required_quantity || '",');
239: dbms_output.put('"' || aRecord.target_service_level || '",');
240: dbms_output.put('"' || aRecord.num_target_service_level || '",');
241: dbms_output.put_line('"' || aRecord.partner_id || '"');
242: END;
243:
244: PROCEDURE schedule_initialize(mainschedule IN OUT NOCOPY Schedule, aRecord Bucket)

Line 241: dbms_output.put_line('"' || aRecord.partner_id || '"');

237: dbms_output.put('"' || aRecord.delivered_quantity || '",');
238: dbms_output.put('"' || aRecord.required_quantity || '",');
239: dbms_output.put('"' || aRecord.target_service_level || '",');
240: dbms_output.put('"' || aRecord.num_target_service_level || '",');
241: dbms_output.put_line('"' || aRecord.partner_id || '"');
242: END;
243:
244: PROCEDURE schedule_initialize(mainschedule IN OUT NOCOPY Schedule, aRecord Bucket)
245: IS