91: attribute30 fm_rout_dtl.attribute30%type ,
92: /* Bug 3612365 Thomas Daniel */
93: /* Added the Resources column to the table to be able to pass back */
94: /* the resource causing the charge to recipe step detail fetch */
95: resources gmd_operation_resources.resources%type
96: );
97: TYPE recipe_step_tbl IS TABLE OF recipe_step_out
98: INDEX BY BINARY_INTEGER;
99:
164: oprn_vers gmd_operations_vl.oprn_vers%type ,
165: oprn_desc gmd_operations_vl.oprn_desc%type ,
166: oprn_id gmd_operations_vl.oprn_id%type ,
167: minimum_transfer_qty gmd_operations_b.minimum_transfer_qty%type ,
168: oprn_line_id gmd_operation_resources.oprn_line_id%type ,
169: activity gmd_operation_activities.activity%type ,
170: activity_desc fm_actv_mst.activity_desc%type ,
171: activity_factor gmd_operation_activities.activity_factor%type ,
172: sequence_dependent_ind gmd_operation_activities.sequence_dependent_ind%type ,
174: offset_interval gmd_operation_activities.offset_interval%type ,
175: break_ind gmd_operation_activities.break_ind%type,
176: max_break gmd_operation_activities.max_break%type DEFAULT NULL,
177: material_ind gmd_operation_activities.material_ind%type,
178: text_code gmd_operation_resources.text_code%type ,
179: created_by gmd_operation_resources.created_by%type ,
180: last_updated_by gmd_operation_resources.last_updated_by%type ,
181: last_update_date gmd_operation_resources.last_update_date%type ,
182: creation_date gmd_operation_resources.creation_date%type ,
175: break_ind gmd_operation_activities.break_ind%type,
176: max_break gmd_operation_activities.max_break%type DEFAULT NULL,
177: material_ind gmd_operation_activities.material_ind%type,
178: text_code gmd_operation_resources.text_code%type ,
179: created_by gmd_operation_resources.created_by%type ,
180: last_updated_by gmd_operation_resources.last_updated_by%type ,
181: last_update_date gmd_operation_resources.last_update_date%type ,
182: creation_date gmd_operation_resources.creation_date%type ,
183: last_update_login gmd_operation_resources.last_update_login%type ,
176: max_break gmd_operation_activities.max_break%type DEFAULT NULL,
177: material_ind gmd_operation_activities.material_ind%type,
178: text_code gmd_operation_resources.text_code%type ,
179: created_by gmd_operation_resources.created_by%type ,
180: last_updated_by gmd_operation_resources.last_updated_by%type ,
181: last_update_date gmd_operation_resources.last_update_date%type ,
182: creation_date gmd_operation_resources.creation_date%type ,
183: last_update_login gmd_operation_resources.last_update_login%type ,
184: attribute_category gmd_operation_resources.attribute_category%type ,
177: material_ind gmd_operation_activities.material_ind%type,
178: text_code gmd_operation_resources.text_code%type ,
179: created_by gmd_operation_resources.created_by%type ,
180: last_updated_by gmd_operation_resources.last_updated_by%type ,
181: last_update_date gmd_operation_resources.last_update_date%type ,
182: creation_date gmd_operation_resources.creation_date%type ,
183: last_update_login gmd_operation_resources.last_update_login%type ,
184: attribute_category gmd_operation_resources.attribute_category%type ,
185: attribute1 gmd_operation_resources.attribute1%type ,
178: text_code gmd_operation_resources.text_code%type ,
179: created_by gmd_operation_resources.created_by%type ,
180: last_updated_by gmd_operation_resources.last_updated_by%type ,
181: last_update_date gmd_operation_resources.last_update_date%type ,
182: creation_date gmd_operation_resources.creation_date%type ,
183: last_update_login gmd_operation_resources.last_update_login%type ,
184: attribute_category gmd_operation_resources.attribute_category%type ,
185: attribute1 gmd_operation_resources.attribute1%type ,
186: attribute2 gmd_operation_resources.attribute2%type ,
179: created_by gmd_operation_resources.created_by%type ,
180: last_updated_by gmd_operation_resources.last_updated_by%type ,
181: last_update_date gmd_operation_resources.last_update_date%type ,
182: creation_date gmd_operation_resources.creation_date%type ,
183: last_update_login gmd_operation_resources.last_update_login%type ,
184: attribute_category gmd_operation_resources.attribute_category%type ,
185: attribute1 gmd_operation_resources.attribute1%type ,
186: attribute2 gmd_operation_resources.attribute2%type ,
187: attribute3 gmd_operation_resources.attribute3%type ,
180: last_updated_by gmd_operation_resources.last_updated_by%type ,
181: last_update_date gmd_operation_resources.last_update_date%type ,
182: creation_date gmd_operation_resources.creation_date%type ,
183: last_update_login gmd_operation_resources.last_update_login%type ,
184: attribute_category gmd_operation_resources.attribute_category%type ,
185: attribute1 gmd_operation_resources.attribute1%type ,
186: attribute2 gmd_operation_resources.attribute2%type ,
187: attribute3 gmd_operation_resources.attribute3%type ,
188: attribute4 gmd_operation_resources.attribute4%type ,
181: last_update_date gmd_operation_resources.last_update_date%type ,
182: creation_date gmd_operation_resources.creation_date%type ,
183: last_update_login gmd_operation_resources.last_update_login%type ,
184: attribute_category gmd_operation_resources.attribute_category%type ,
185: attribute1 gmd_operation_resources.attribute1%type ,
186: attribute2 gmd_operation_resources.attribute2%type ,
187: attribute3 gmd_operation_resources.attribute3%type ,
188: attribute4 gmd_operation_resources.attribute4%type ,
189: attribute5 gmd_operation_resources.attribute5%type ,
182: creation_date gmd_operation_resources.creation_date%type ,
183: last_update_login gmd_operation_resources.last_update_login%type ,
184: attribute_category gmd_operation_resources.attribute_category%type ,
185: attribute1 gmd_operation_resources.attribute1%type ,
186: attribute2 gmd_operation_resources.attribute2%type ,
187: attribute3 gmd_operation_resources.attribute3%type ,
188: attribute4 gmd_operation_resources.attribute4%type ,
189: attribute5 gmd_operation_resources.attribute5%type ,
190: attribute6 gmd_operation_resources.attribute6%type ,
183: last_update_login gmd_operation_resources.last_update_login%type ,
184: attribute_category gmd_operation_resources.attribute_category%type ,
185: attribute1 gmd_operation_resources.attribute1%type ,
186: attribute2 gmd_operation_resources.attribute2%type ,
187: attribute3 gmd_operation_resources.attribute3%type ,
188: attribute4 gmd_operation_resources.attribute4%type ,
189: attribute5 gmd_operation_resources.attribute5%type ,
190: attribute6 gmd_operation_resources.attribute6%type ,
191: attribute7 gmd_operation_resources.attribute7%type ,
184: attribute_category gmd_operation_resources.attribute_category%type ,
185: attribute1 gmd_operation_resources.attribute1%type ,
186: attribute2 gmd_operation_resources.attribute2%type ,
187: attribute3 gmd_operation_resources.attribute3%type ,
188: attribute4 gmd_operation_resources.attribute4%type ,
189: attribute5 gmd_operation_resources.attribute5%type ,
190: attribute6 gmd_operation_resources.attribute6%type ,
191: attribute7 gmd_operation_resources.attribute7%type ,
192: attribute8 gmd_operation_resources.attribute8%type ,
185: attribute1 gmd_operation_resources.attribute1%type ,
186: attribute2 gmd_operation_resources.attribute2%type ,
187: attribute3 gmd_operation_resources.attribute3%type ,
188: attribute4 gmd_operation_resources.attribute4%type ,
189: attribute5 gmd_operation_resources.attribute5%type ,
190: attribute6 gmd_operation_resources.attribute6%type ,
191: attribute7 gmd_operation_resources.attribute7%type ,
192: attribute8 gmd_operation_resources.attribute8%type ,
193: attribute9 gmd_operation_resources.attribute9%type ,
186: attribute2 gmd_operation_resources.attribute2%type ,
187: attribute3 gmd_operation_resources.attribute3%type ,
188: attribute4 gmd_operation_resources.attribute4%type ,
189: attribute5 gmd_operation_resources.attribute5%type ,
190: attribute6 gmd_operation_resources.attribute6%type ,
191: attribute7 gmd_operation_resources.attribute7%type ,
192: attribute8 gmd_operation_resources.attribute8%type ,
193: attribute9 gmd_operation_resources.attribute9%type ,
194: attribute10 gmd_operation_resources.attribute10%type ,
187: attribute3 gmd_operation_resources.attribute3%type ,
188: attribute4 gmd_operation_resources.attribute4%type ,
189: attribute5 gmd_operation_resources.attribute5%type ,
190: attribute6 gmd_operation_resources.attribute6%type ,
191: attribute7 gmd_operation_resources.attribute7%type ,
192: attribute8 gmd_operation_resources.attribute8%type ,
193: attribute9 gmd_operation_resources.attribute9%type ,
194: attribute10 gmd_operation_resources.attribute10%type ,
195: attribute11 gmd_operation_resources.attribute11%type ,
188: attribute4 gmd_operation_resources.attribute4%type ,
189: attribute5 gmd_operation_resources.attribute5%type ,
190: attribute6 gmd_operation_resources.attribute6%type ,
191: attribute7 gmd_operation_resources.attribute7%type ,
192: attribute8 gmd_operation_resources.attribute8%type ,
193: attribute9 gmd_operation_resources.attribute9%type ,
194: attribute10 gmd_operation_resources.attribute10%type ,
195: attribute11 gmd_operation_resources.attribute11%type ,
196: attribute12 gmd_operation_resources.attribute12%type ,
189: attribute5 gmd_operation_resources.attribute5%type ,
190: attribute6 gmd_operation_resources.attribute6%type ,
191: attribute7 gmd_operation_resources.attribute7%type ,
192: attribute8 gmd_operation_resources.attribute8%type ,
193: attribute9 gmd_operation_resources.attribute9%type ,
194: attribute10 gmd_operation_resources.attribute10%type ,
195: attribute11 gmd_operation_resources.attribute11%type ,
196: attribute12 gmd_operation_resources.attribute12%type ,
197: attribute13 gmd_operation_resources.attribute13%type ,
190: attribute6 gmd_operation_resources.attribute6%type ,
191: attribute7 gmd_operation_resources.attribute7%type ,
192: attribute8 gmd_operation_resources.attribute8%type ,
193: attribute9 gmd_operation_resources.attribute9%type ,
194: attribute10 gmd_operation_resources.attribute10%type ,
195: attribute11 gmd_operation_resources.attribute11%type ,
196: attribute12 gmd_operation_resources.attribute12%type ,
197: attribute13 gmd_operation_resources.attribute13%type ,
198: attribute14 gmd_operation_resources.attribute14%type ,
191: attribute7 gmd_operation_resources.attribute7%type ,
192: attribute8 gmd_operation_resources.attribute8%type ,
193: attribute9 gmd_operation_resources.attribute9%type ,
194: attribute10 gmd_operation_resources.attribute10%type ,
195: attribute11 gmd_operation_resources.attribute11%type ,
196: attribute12 gmd_operation_resources.attribute12%type ,
197: attribute13 gmd_operation_resources.attribute13%type ,
198: attribute14 gmd_operation_resources.attribute14%type ,
199: attribute15 gmd_operation_resources.attribute15%type ,
192: attribute8 gmd_operation_resources.attribute8%type ,
193: attribute9 gmd_operation_resources.attribute9%type ,
194: attribute10 gmd_operation_resources.attribute10%type ,
195: attribute11 gmd_operation_resources.attribute11%type ,
196: attribute12 gmd_operation_resources.attribute12%type ,
197: attribute13 gmd_operation_resources.attribute13%type ,
198: attribute14 gmd_operation_resources.attribute14%type ,
199: attribute15 gmd_operation_resources.attribute15%type ,
200: attribute16 gmd_operation_resources.attribute16%type ,
193: attribute9 gmd_operation_resources.attribute9%type ,
194: attribute10 gmd_operation_resources.attribute10%type ,
195: attribute11 gmd_operation_resources.attribute11%type ,
196: attribute12 gmd_operation_resources.attribute12%type ,
197: attribute13 gmd_operation_resources.attribute13%type ,
198: attribute14 gmd_operation_resources.attribute14%type ,
199: attribute15 gmd_operation_resources.attribute15%type ,
200: attribute16 gmd_operation_resources.attribute16%type ,
201: attribute17 gmd_operation_resources.attribute17%type ,
194: attribute10 gmd_operation_resources.attribute10%type ,
195: attribute11 gmd_operation_resources.attribute11%type ,
196: attribute12 gmd_operation_resources.attribute12%type ,
197: attribute13 gmd_operation_resources.attribute13%type ,
198: attribute14 gmd_operation_resources.attribute14%type ,
199: attribute15 gmd_operation_resources.attribute15%type ,
200: attribute16 gmd_operation_resources.attribute16%type ,
201: attribute17 gmd_operation_resources.attribute17%type ,
202: attribute18 gmd_operation_resources.attribute18%type ,
195: attribute11 gmd_operation_resources.attribute11%type ,
196: attribute12 gmd_operation_resources.attribute12%type ,
197: attribute13 gmd_operation_resources.attribute13%type ,
198: attribute14 gmd_operation_resources.attribute14%type ,
199: attribute15 gmd_operation_resources.attribute15%type ,
200: attribute16 gmd_operation_resources.attribute16%type ,
201: attribute17 gmd_operation_resources.attribute17%type ,
202: attribute18 gmd_operation_resources.attribute18%type ,
203: attribute19 gmd_operation_resources.attribute19%type ,
196: attribute12 gmd_operation_resources.attribute12%type ,
197: attribute13 gmd_operation_resources.attribute13%type ,
198: attribute14 gmd_operation_resources.attribute14%type ,
199: attribute15 gmd_operation_resources.attribute15%type ,
200: attribute16 gmd_operation_resources.attribute16%type ,
201: attribute17 gmd_operation_resources.attribute17%type ,
202: attribute18 gmd_operation_resources.attribute18%type ,
203: attribute19 gmd_operation_resources.attribute19%type ,
204: attribute20 gmd_operation_resources.attribute20%type ,
197: attribute13 gmd_operation_resources.attribute13%type ,
198: attribute14 gmd_operation_resources.attribute14%type ,
199: attribute15 gmd_operation_resources.attribute15%type ,
200: attribute16 gmd_operation_resources.attribute16%type ,
201: attribute17 gmd_operation_resources.attribute17%type ,
202: attribute18 gmd_operation_resources.attribute18%type ,
203: attribute19 gmd_operation_resources.attribute19%type ,
204: attribute20 gmd_operation_resources.attribute20%type ,
205: attribute21 gmd_operation_resources.attribute21%type ,
198: attribute14 gmd_operation_resources.attribute14%type ,
199: attribute15 gmd_operation_resources.attribute15%type ,
200: attribute16 gmd_operation_resources.attribute16%type ,
201: attribute17 gmd_operation_resources.attribute17%type ,
202: attribute18 gmd_operation_resources.attribute18%type ,
203: attribute19 gmd_operation_resources.attribute19%type ,
204: attribute20 gmd_operation_resources.attribute20%type ,
205: attribute21 gmd_operation_resources.attribute21%type ,
206: attribute22 gmd_operation_resources.attribute22%type ,
199: attribute15 gmd_operation_resources.attribute15%type ,
200: attribute16 gmd_operation_resources.attribute16%type ,
201: attribute17 gmd_operation_resources.attribute17%type ,
202: attribute18 gmd_operation_resources.attribute18%type ,
203: attribute19 gmd_operation_resources.attribute19%type ,
204: attribute20 gmd_operation_resources.attribute20%type ,
205: attribute21 gmd_operation_resources.attribute21%type ,
206: attribute22 gmd_operation_resources.attribute22%type ,
207: attribute23 gmd_operation_resources.attribute23%type ,
200: attribute16 gmd_operation_resources.attribute16%type ,
201: attribute17 gmd_operation_resources.attribute17%type ,
202: attribute18 gmd_operation_resources.attribute18%type ,
203: attribute19 gmd_operation_resources.attribute19%type ,
204: attribute20 gmd_operation_resources.attribute20%type ,
205: attribute21 gmd_operation_resources.attribute21%type ,
206: attribute22 gmd_operation_resources.attribute22%type ,
207: attribute23 gmd_operation_resources.attribute23%type ,
208: attribute24 gmd_operation_resources.attribute24%type ,
201: attribute17 gmd_operation_resources.attribute17%type ,
202: attribute18 gmd_operation_resources.attribute18%type ,
203: attribute19 gmd_operation_resources.attribute19%type ,
204: attribute20 gmd_operation_resources.attribute20%type ,
205: attribute21 gmd_operation_resources.attribute21%type ,
206: attribute22 gmd_operation_resources.attribute22%type ,
207: attribute23 gmd_operation_resources.attribute23%type ,
208: attribute24 gmd_operation_resources.attribute24%type ,
209: attribute25 gmd_operation_resources.attribute25%type ,
202: attribute18 gmd_operation_resources.attribute18%type ,
203: attribute19 gmd_operation_resources.attribute19%type ,
204: attribute20 gmd_operation_resources.attribute20%type ,
205: attribute21 gmd_operation_resources.attribute21%type ,
206: attribute22 gmd_operation_resources.attribute22%type ,
207: attribute23 gmd_operation_resources.attribute23%type ,
208: attribute24 gmd_operation_resources.attribute24%type ,
209: attribute25 gmd_operation_resources.attribute25%type ,
210: attribute26 gmd_operation_resources.attribute26%type ,
203: attribute19 gmd_operation_resources.attribute19%type ,
204: attribute20 gmd_operation_resources.attribute20%type ,
205: attribute21 gmd_operation_resources.attribute21%type ,
206: attribute22 gmd_operation_resources.attribute22%type ,
207: attribute23 gmd_operation_resources.attribute23%type ,
208: attribute24 gmd_operation_resources.attribute24%type ,
209: attribute25 gmd_operation_resources.attribute25%type ,
210: attribute26 gmd_operation_resources.attribute26%type ,
211: attribute27 gmd_operation_resources.attribute27%type ,
204: attribute20 gmd_operation_resources.attribute20%type ,
205: attribute21 gmd_operation_resources.attribute21%type ,
206: attribute22 gmd_operation_resources.attribute22%type ,
207: attribute23 gmd_operation_resources.attribute23%type ,
208: attribute24 gmd_operation_resources.attribute24%type ,
209: attribute25 gmd_operation_resources.attribute25%type ,
210: attribute26 gmd_operation_resources.attribute26%type ,
211: attribute27 gmd_operation_resources.attribute27%type ,
212: attribute28 gmd_operation_resources.attribute28%type ,
205: attribute21 gmd_operation_resources.attribute21%type ,
206: attribute22 gmd_operation_resources.attribute22%type ,
207: attribute23 gmd_operation_resources.attribute23%type ,
208: attribute24 gmd_operation_resources.attribute24%type ,
209: attribute25 gmd_operation_resources.attribute25%type ,
210: attribute26 gmd_operation_resources.attribute26%type ,
211: attribute27 gmd_operation_resources.attribute27%type ,
212: attribute28 gmd_operation_resources.attribute28%type ,
213: attribute29 gmd_operation_resources.attribute29%type ,
206: attribute22 gmd_operation_resources.attribute22%type ,
207: attribute23 gmd_operation_resources.attribute23%type ,
208: attribute24 gmd_operation_resources.attribute24%type ,
209: attribute25 gmd_operation_resources.attribute25%type ,
210: attribute26 gmd_operation_resources.attribute26%type ,
211: attribute27 gmd_operation_resources.attribute27%type ,
212: attribute28 gmd_operation_resources.attribute28%type ,
213: attribute29 gmd_operation_resources.attribute29%type ,
214: attribute30 gmd_operation_resources.attribute30%type
207: attribute23 gmd_operation_resources.attribute23%type ,
208: attribute24 gmd_operation_resources.attribute24%type ,
209: attribute25 gmd_operation_resources.attribute25%type ,
210: attribute26 gmd_operation_resources.attribute26%type ,
211: attribute27 gmd_operation_resources.attribute27%type ,
212: attribute28 gmd_operation_resources.attribute28%type ,
213: attribute29 gmd_operation_resources.attribute29%type ,
214: attribute30 gmd_operation_resources.attribute30%type
215:
208: attribute24 gmd_operation_resources.attribute24%type ,
209: attribute25 gmd_operation_resources.attribute25%type ,
210: attribute26 gmd_operation_resources.attribute26%type ,
211: attribute27 gmd_operation_resources.attribute27%type ,
212: attribute28 gmd_operation_resources.attribute28%type ,
213: attribute29 gmd_operation_resources.attribute29%type ,
214: attribute30 gmd_operation_resources.attribute30%type
215:
216: );
209: attribute25 gmd_operation_resources.attribute25%type ,
210: attribute26 gmd_operation_resources.attribute26%type ,
211: attribute27 gmd_operation_resources.attribute27%type ,
212: attribute28 gmd_operation_resources.attribute28%type ,
213: attribute29 gmd_operation_resources.attribute29%type ,
214: attribute30 gmd_operation_resources.attribute30%type
215:
216: );
217:
210: attribute26 gmd_operation_resources.attribute26%type ,
211: attribute27 gmd_operation_resources.attribute27%type ,
212: attribute28 gmd_operation_resources.attribute28%type ,
213: attribute29 gmd_operation_resources.attribute29%type ,
214: attribute30 gmd_operation_resources.attribute30%type
215:
216: );
217:
218: TYPE oprn_act_tbl IS TABLE OF oprn_act_out
233: oprn_no gmd_operations_vl.oprn_no%type ,
234: oprn_vers gmd_operations_vl.oprn_vers%type ,
235: oprn_desc gmd_operations_vl.oprn_desc%type ,
236: activity gmd_operation_activities.activity%type ,
237: oprn_line_id gmd_operation_resources.oprn_line_id%type ,
238: resources gmd_operation_resources.resources%type ,
239: resource_usage gmd_operation_resources.resource_usage%type ,
240: resource_count gmd_operation_resources.resource_count%type ,
241: process_qty gmd_operation_resources.process_qty%type ,
234: oprn_vers gmd_operations_vl.oprn_vers%type ,
235: oprn_desc gmd_operations_vl.oprn_desc%type ,
236: activity gmd_operation_activities.activity%type ,
237: oprn_line_id gmd_operation_resources.oprn_line_id%type ,
238: resources gmd_operation_resources.resources%type ,
239: resource_usage gmd_operation_resources.resource_usage%type ,
240: resource_count gmd_operation_resources.resource_count%type ,
241: process_qty gmd_operation_resources.process_qty%type ,
242: process_uom gmd_operation_resources.resource_process_uom%type ,
235: oprn_desc gmd_operations_vl.oprn_desc%type ,
236: activity gmd_operation_activities.activity%type ,
237: oprn_line_id gmd_operation_resources.oprn_line_id%type ,
238: resources gmd_operation_resources.resources%type ,
239: resource_usage gmd_operation_resources.resource_usage%type ,
240: resource_count gmd_operation_resources.resource_count%type ,
241: process_qty gmd_operation_resources.process_qty%type ,
242: process_uom gmd_operation_resources.resource_process_uom%type ,
243: prim_rsrc_ind gmd_operation_resources.prim_rsrc_ind%type ,
236: activity gmd_operation_activities.activity%type ,
237: oprn_line_id gmd_operation_resources.oprn_line_id%type ,
238: resources gmd_operation_resources.resources%type ,
239: resource_usage gmd_operation_resources.resource_usage%type ,
240: resource_count gmd_operation_resources.resource_count%type ,
241: process_qty gmd_operation_resources.process_qty%type ,
242: process_uom gmd_operation_resources.resource_process_uom%type ,
243: prim_rsrc_ind gmd_operation_resources.prim_rsrc_ind%type ,
244: scale_type gmd_operation_resources.scale_type%type ,
237: oprn_line_id gmd_operation_resources.oprn_line_id%type ,
238: resources gmd_operation_resources.resources%type ,
239: resource_usage gmd_operation_resources.resource_usage%type ,
240: resource_count gmd_operation_resources.resource_count%type ,
241: process_qty gmd_operation_resources.process_qty%type ,
242: process_uom gmd_operation_resources.resource_process_uom%type ,
243: prim_rsrc_ind gmd_operation_resources.prim_rsrc_ind%type ,
244: scale_type gmd_operation_resources.scale_type%type ,
245: cost_analysis_code gmd_operation_resources.cost_analysis_code%type ,
238: resources gmd_operation_resources.resources%type ,
239: resource_usage gmd_operation_resources.resource_usage%type ,
240: resource_count gmd_operation_resources.resource_count%type ,
241: process_qty gmd_operation_resources.process_qty%type ,
242: process_uom gmd_operation_resources.resource_process_uom%type ,
243: prim_rsrc_ind gmd_operation_resources.prim_rsrc_ind%type ,
244: scale_type gmd_operation_resources.scale_type%type ,
245: cost_analysis_code gmd_operation_resources.cost_analysis_code%type ,
246: cost_cmpntcls_id gmd_operation_resources.cost_cmpntcls_id%type ,
239: resource_usage gmd_operation_resources.resource_usage%type ,
240: resource_count gmd_operation_resources.resource_count%type ,
241: process_qty gmd_operation_resources.process_qty%type ,
242: process_uom gmd_operation_resources.resource_process_uom%type ,
243: prim_rsrc_ind gmd_operation_resources.prim_rsrc_ind%type ,
244: scale_type gmd_operation_resources.scale_type%type ,
245: cost_analysis_code gmd_operation_resources.cost_analysis_code%type ,
246: cost_cmpntcls_id gmd_operation_resources.cost_cmpntcls_id%type ,
247: usage_um gmd_operation_resources.resource_usage_uom%type ,
240: resource_count gmd_operation_resources.resource_count%type ,
241: process_qty gmd_operation_resources.process_qty%type ,
242: process_uom gmd_operation_resources.resource_process_uom%type ,
243: prim_rsrc_ind gmd_operation_resources.prim_rsrc_ind%type ,
244: scale_type gmd_operation_resources.scale_type%type ,
245: cost_analysis_code gmd_operation_resources.cost_analysis_code%type ,
246: cost_cmpntcls_id gmd_operation_resources.cost_cmpntcls_id%type ,
247: usage_um gmd_operation_resources.resource_usage_uom%type ,
248: offset_interval gmd_operation_resources.offset_interval%type ,
241: process_qty gmd_operation_resources.process_qty%type ,
242: process_uom gmd_operation_resources.resource_process_uom%type ,
243: prim_rsrc_ind gmd_operation_resources.prim_rsrc_ind%type ,
244: scale_type gmd_operation_resources.scale_type%type ,
245: cost_analysis_code gmd_operation_resources.cost_analysis_code%type ,
246: cost_cmpntcls_id gmd_operation_resources.cost_cmpntcls_id%type ,
247: usage_um gmd_operation_resources.resource_usage_uom%type ,
248: offset_interval gmd_operation_resources.offset_interval%type ,
249: max_capacity cr_rsrc_mst.max_capacity%type ,
242: process_uom gmd_operation_resources.resource_process_uom%type ,
243: prim_rsrc_ind gmd_operation_resources.prim_rsrc_ind%type ,
244: scale_type gmd_operation_resources.scale_type%type ,
245: cost_analysis_code gmd_operation_resources.cost_analysis_code%type ,
246: cost_cmpntcls_id gmd_operation_resources.cost_cmpntcls_id%type ,
247: usage_um gmd_operation_resources.resource_usage_uom%type ,
248: offset_interval gmd_operation_resources.offset_interval%type ,
249: max_capacity cr_rsrc_mst.max_capacity%type ,
250: min_capacity cr_rsrc_mst.min_capacity%type ,
243: prim_rsrc_ind gmd_operation_resources.prim_rsrc_ind%type ,
244: scale_type gmd_operation_resources.scale_type%type ,
245: cost_analysis_code gmd_operation_resources.cost_analysis_code%type ,
246: cost_cmpntcls_id gmd_operation_resources.cost_cmpntcls_id%type ,
247: usage_um gmd_operation_resources.resource_usage_uom%type ,
248: offset_interval gmd_operation_resources.offset_interval%type ,
249: max_capacity cr_rsrc_mst.max_capacity%type ,
250: min_capacity cr_rsrc_mst.min_capacity%type ,
251: capacity_constraint cr_rsrc_mst.capacity_constraint%type ,
244: scale_type gmd_operation_resources.scale_type%type ,
245: cost_analysis_code gmd_operation_resources.cost_analysis_code%type ,
246: cost_cmpntcls_id gmd_operation_resources.cost_cmpntcls_id%type ,
247: usage_um gmd_operation_resources.resource_usage_uom%type ,
248: offset_interval gmd_operation_resources.offset_interval%type ,
249: max_capacity cr_rsrc_mst.max_capacity%type ,
250: min_capacity cr_rsrc_mst.min_capacity%type ,
251: capacity_constraint cr_rsrc_mst.capacity_constraint%type ,
252: capacity_tolerance cr_rsrc_dtl.capacity_tolerance%type ,
251: capacity_constraint cr_rsrc_mst.capacity_constraint%type ,
252: capacity_tolerance cr_rsrc_dtl.capacity_tolerance%type ,
253: capacity_uom cr_rsrc_dtl.capacity_um%type,
254:
255: process_parameter_1 gmd_operation_resources.process_parameter_1%type ,
256: process_parameter_2 gmd_operation_resources.process_parameter_2%type ,
257: process_parameter_3 gmd_operation_resources.process_parameter_3%type ,
258: process_parameter_4 gmd_operation_resources.process_parameter_4%type ,
259: process_parameter_5 gmd_operation_resources.PROCESS_PARAMETER_5%type ,
252: capacity_tolerance cr_rsrc_dtl.capacity_tolerance%type ,
253: capacity_uom cr_rsrc_dtl.capacity_um%type,
254:
255: process_parameter_1 gmd_operation_resources.process_parameter_1%type ,
256: process_parameter_2 gmd_operation_resources.process_parameter_2%type ,
257: process_parameter_3 gmd_operation_resources.process_parameter_3%type ,
258: process_parameter_4 gmd_operation_resources.process_parameter_4%type ,
259: process_parameter_5 gmd_operation_resources.PROCESS_PARAMETER_5%type ,
260:
253: capacity_uom cr_rsrc_dtl.capacity_um%type,
254:
255: process_parameter_1 gmd_operation_resources.process_parameter_1%type ,
256: process_parameter_2 gmd_operation_resources.process_parameter_2%type ,
257: process_parameter_3 gmd_operation_resources.process_parameter_3%type ,
258: process_parameter_4 gmd_operation_resources.process_parameter_4%type ,
259: process_parameter_5 gmd_operation_resources.PROCESS_PARAMETER_5%type ,
260:
261: recipe_override NUMBER(5) ,
254:
255: process_parameter_1 gmd_operation_resources.process_parameter_1%type ,
256: process_parameter_2 gmd_operation_resources.process_parameter_2%type ,
257: process_parameter_3 gmd_operation_resources.process_parameter_3%type ,
258: process_parameter_4 gmd_operation_resources.process_parameter_4%type ,
259: process_parameter_5 gmd_operation_resources.PROCESS_PARAMETER_5%type ,
260:
261: recipe_override NUMBER(5) ,
262: text_code gmd_operation_resources.text_code%type ,
255: process_parameter_1 gmd_operation_resources.process_parameter_1%type ,
256: process_parameter_2 gmd_operation_resources.process_parameter_2%type ,
257: process_parameter_3 gmd_operation_resources.process_parameter_3%type ,
258: process_parameter_4 gmd_operation_resources.process_parameter_4%type ,
259: process_parameter_5 gmd_operation_resources.PROCESS_PARAMETER_5%type ,
260:
261: recipe_override NUMBER(5) ,
262: text_code gmd_operation_resources.text_code%type ,
263: created_by gmd_operation_resources.created_by%type ,
258: process_parameter_4 gmd_operation_resources.process_parameter_4%type ,
259: process_parameter_5 gmd_operation_resources.PROCESS_PARAMETER_5%type ,
260:
261: recipe_override NUMBER(5) ,
262: text_code gmd_operation_resources.text_code%type ,
263: created_by gmd_operation_resources.created_by%type ,
264: last_updated_by gmd_operation_resources.last_updated_by%type ,
265: last_update_date gmd_operation_resources.last_update_date%type ,
266: creation_date gmd_operation_resources.creation_date%type ,
259: process_parameter_5 gmd_operation_resources.PROCESS_PARAMETER_5%type ,
260:
261: recipe_override NUMBER(5) ,
262: text_code gmd_operation_resources.text_code%type ,
263: created_by gmd_operation_resources.created_by%type ,
264: last_updated_by gmd_operation_resources.last_updated_by%type ,
265: last_update_date gmd_operation_resources.last_update_date%type ,
266: creation_date gmd_operation_resources.creation_date%type ,
267: last_update_login gmd_operation_resources.last_update_login%type ,
260:
261: recipe_override NUMBER(5) ,
262: text_code gmd_operation_resources.text_code%type ,
263: created_by gmd_operation_resources.created_by%type ,
264: last_updated_by gmd_operation_resources.last_updated_by%type ,
265: last_update_date gmd_operation_resources.last_update_date%type ,
266: creation_date gmd_operation_resources.creation_date%type ,
267: last_update_login gmd_operation_resources.last_update_login%type ,
268: attribute_category gmd_operation_resources.attribute_category%type ,
261: recipe_override NUMBER(5) ,
262: text_code gmd_operation_resources.text_code%type ,
263: created_by gmd_operation_resources.created_by%type ,
264: last_updated_by gmd_operation_resources.last_updated_by%type ,
265: last_update_date gmd_operation_resources.last_update_date%type ,
266: creation_date gmd_operation_resources.creation_date%type ,
267: last_update_login gmd_operation_resources.last_update_login%type ,
268: attribute_category gmd_operation_resources.attribute_category%type ,
269: attribute1 gmd_operation_resources.attribute1%type ,
262: text_code gmd_operation_resources.text_code%type ,
263: created_by gmd_operation_resources.created_by%type ,
264: last_updated_by gmd_operation_resources.last_updated_by%type ,
265: last_update_date gmd_operation_resources.last_update_date%type ,
266: creation_date gmd_operation_resources.creation_date%type ,
267: last_update_login gmd_operation_resources.last_update_login%type ,
268: attribute_category gmd_operation_resources.attribute_category%type ,
269: attribute1 gmd_operation_resources.attribute1%type ,
270: attribute2 gmd_operation_resources.attribute2%type ,
263: created_by gmd_operation_resources.created_by%type ,
264: last_updated_by gmd_operation_resources.last_updated_by%type ,
265: last_update_date gmd_operation_resources.last_update_date%type ,
266: creation_date gmd_operation_resources.creation_date%type ,
267: last_update_login gmd_operation_resources.last_update_login%type ,
268: attribute_category gmd_operation_resources.attribute_category%type ,
269: attribute1 gmd_operation_resources.attribute1%type ,
270: attribute2 gmd_operation_resources.attribute2%type ,
271: attribute3 gmd_operation_resources.attribute3%type ,
264: last_updated_by gmd_operation_resources.last_updated_by%type ,
265: last_update_date gmd_operation_resources.last_update_date%type ,
266: creation_date gmd_operation_resources.creation_date%type ,
267: last_update_login gmd_operation_resources.last_update_login%type ,
268: attribute_category gmd_operation_resources.attribute_category%type ,
269: attribute1 gmd_operation_resources.attribute1%type ,
270: attribute2 gmd_operation_resources.attribute2%type ,
271: attribute3 gmd_operation_resources.attribute3%type ,
272: attribute4 gmd_operation_resources.attribute4%type ,
265: last_update_date gmd_operation_resources.last_update_date%type ,
266: creation_date gmd_operation_resources.creation_date%type ,
267: last_update_login gmd_operation_resources.last_update_login%type ,
268: attribute_category gmd_operation_resources.attribute_category%type ,
269: attribute1 gmd_operation_resources.attribute1%type ,
270: attribute2 gmd_operation_resources.attribute2%type ,
271: attribute3 gmd_operation_resources.attribute3%type ,
272: attribute4 gmd_operation_resources.attribute4%type ,
273: attribute5 gmd_operation_resources.attribute5%type ,
266: creation_date gmd_operation_resources.creation_date%type ,
267: last_update_login gmd_operation_resources.last_update_login%type ,
268: attribute_category gmd_operation_resources.attribute_category%type ,
269: attribute1 gmd_operation_resources.attribute1%type ,
270: attribute2 gmd_operation_resources.attribute2%type ,
271: attribute3 gmd_operation_resources.attribute3%type ,
272: attribute4 gmd_operation_resources.attribute4%type ,
273: attribute5 gmd_operation_resources.attribute5%type ,
274: attribute6 gmd_operation_resources.attribute6%type ,
267: last_update_login gmd_operation_resources.last_update_login%type ,
268: attribute_category gmd_operation_resources.attribute_category%type ,
269: attribute1 gmd_operation_resources.attribute1%type ,
270: attribute2 gmd_operation_resources.attribute2%type ,
271: attribute3 gmd_operation_resources.attribute3%type ,
272: attribute4 gmd_operation_resources.attribute4%type ,
273: attribute5 gmd_operation_resources.attribute5%type ,
274: attribute6 gmd_operation_resources.attribute6%type ,
275: attribute7 gmd_operation_resources.attribute7%type ,
268: attribute_category gmd_operation_resources.attribute_category%type ,
269: attribute1 gmd_operation_resources.attribute1%type ,
270: attribute2 gmd_operation_resources.attribute2%type ,
271: attribute3 gmd_operation_resources.attribute3%type ,
272: attribute4 gmd_operation_resources.attribute4%type ,
273: attribute5 gmd_operation_resources.attribute5%type ,
274: attribute6 gmd_operation_resources.attribute6%type ,
275: attribute7 gmd_operation_resources.attribute7%type ,
276: attribute8 gmd_operation_resources.attribute8%type ,
269: attribute1 gmd_operation_resources.attribute1%type ,
270: attribute2 gmd_operation_resources.attribute2%type ,
271: attribute3 gmd_operation_resources.attribute3%type ,
272: attribute4 gmd_operation_resources.attribute4%type ,
273: attribute5 gmd_operation_resources.attribute5%type ,
274: attribute6 gmd_operation_resources.attribute6%type ,
275: attribute7 gmd_operation_resources.attribute7%type ,
276: attribute8 gmd_operation_resources.attribute8%type ,
277: attribute9 gmd_operation_resources.attribute9%type ,
270: attribute2 gmd_operation_resources.attribute2%type ,
271: attribute3 gmd_operation_resources.attribute3%type ,
272: attribute4 gmd_operation_resources.attribute4%type ,
273: attribute5 gmd_operation_resources.attribute5%type ,
274: attribute6 gmd_operation_resources.attribute6%type ,
275: attribute7 gmd_operation_resources.attribute7%type ,
276: attribute8 gmd_operation_resources.attribute8%type ,
277: attribute9 gmd_operation_resources.attribute9%type ,
278: attribute10 gmd_operation_resources.attribute10%type ,
271: attribute3 gmd_operation_resources.attribute3%type ,
272: attribute4 gmd_operation_resources.attribute4%type ,
273: attribute5 gmd_operation_resources.attribute5%type ,
274: attribute6 gmd_operation_resources.attribute6%type ,
275: attribute7 gmd_operation_resources.attribute7%type ,
276: attribute8 gmd_operation_resources.attribute8%type ,
277: attribute9 gmd_operation_resources.attribute9%type ,
278: attribute10 gmd_operation_resources.attribute10%type ,
279: attribute11 gmd_operation_resources.attribute11%type ,
272: attribute4 gmd_operation_resources.attribute4%type ,
273: attribute5 gmd_operation_resources.attribute5%type ,
274: attribute6 gmd_operation_resources.attribute6%type ,
275: attribute7 gmd_operation_resources.attribute7%type ,
276: attribute8 gmd_operation_resources.attribute8%type ,
277: attribute9 gmd_operation_resources.attribute9%type ,
278: attribute10 gmd_operation_resources.attribute10%type ,
279: attribute11 gmd_operation_resources.attribute11%type ,
280: attribute12 gmd_operation_resources.attribute12%type ,
273: attribute5 gmd_operation_resources.attribute5%type ,
274: attribute6 gmd_operation_resources.attribute6%type ,
275: attribute7 gmd_operation_resources.attribute7%type ,
276: attribute8 gmd_operation_resources.attribute8%type ,
277: attribute9 gmd_operation_resources.attribute9%type ,
278: attribute10 gmd_operation_resources.attribute10%type ,
279: attribute11 gmd_operation_resources.attribute11%type ,
280: attribute12 gmd_operation_resources.attribute12%type ,
281: attribute13 gmd_operation_resources.attribute13%type ,
274: attribute6 gmd_operation_resources.attribute6%type ,
275: attribute7 gmd_operation_resources.attribute7%type ,
276: attribute8 gmd_operation_resources.attribute8%type ,
277: attribute9 gmd_operation_resources.attribute9%type ,
278: attribute10 gmd_operation_resources.attribute10%type ,
279: attribute11 gmd_operation_resources.attribute11%type ,
280: attribute12 gmd_operation_resources.attribute12%type ,
281: attribute13 gmd_operation_resources.attribute13%type ,
282: attribute14 gmd_operation_resources.attribute14%type ,
275: attribute7 gmd_operation_resources.attribute7%type ,
276: attribute8 gmd_operation_resources.attribute8%type ,
277: attribute9 gmd_operation_resources.attribute9%type ,
278: attribute10 gmd_operation_resources.attribute10%type ,
279: attribute11 gmd_operation_resources.attribute11%type ,
280: attribute12 gmd_operation_resources.attribute12%type ,
281: attribute13 gmd_operation_resources.attribute13%type ,
282: attribute14 gmd_operation_resources.attribute14%type ,
283: attribute15 gmd_operation_resources.attribute15%type ,
276: attribute8 gmd_operation_resources.attribute8%type ,
277: attribute9 gmd_operation_resources.attribute9%type ,
278: attribute10 gmd_operation_resources.attribute10%type ,
279: attribute11 gmd_operation_resources.attribute11%type ,
280: attribute12 gmd_operation_resources.attribute12%type ,
281: attribute13 gmd_operation_resources.attribute13%type ,
282: attribute14 gmd_operation_resources.attribute14%type ,
283: attribute15 gmd_operation_resources.attribute15%type ,
284: attribute16 gmd_operation_resources.attribute16%type ,
277: attribute9 gmd_operation_resources.attribute9%type ,
278: attribute10 gmd_operation_resources.attribute10%type ,
279: attribute11 gmd_operation_resources.attribute11%type ,
280: attribute12 gmd_operation_resources.attribute12%type ,
281: attribute13 gmd_operation_resources.attribute13%type ,
282: attribute14 gmd_operation_resources.attribute14%type ,
283: attribute15 gmd_operation_resources.attribute15%type ,
284: attribute16 gmd_operation_resources.attribute16%type ,
285: attribute17 gmd_operation_resources.attribute17%type ,
278: attribute10 gmd_operation_resources.attribute10%type ,
279: attribute11 gmd_operation_resources.attribute11%type ,
280: attribute12 gmd_operation_resources.attribute12%type ,
281: attribute13 gmd_operation_resources.attribute13%type ,
282: attribute14 gmd_operation_resources.attribute14%type ,
283: attribute15 gmd_operation_resources.attribute15%type ,
284: attribute16 gmd_operation_resources.attribute16%type ,
285: attribute17 gmd_operation_resources.attribute17%type ,
286: attribute18 gmd_operation_resources.attribute18%type ,
279: attribute11 gmd_operation_resources.attribute11%type ,
280: attribute12 gmd_operation_resources.attribute12%type ,
281: attribute13 gmd_operation_resources.attribute13%type ,
282: attribute14 gmd_operation_resources.attribute14%type ,
283: attribute15 gmd_operation_resources.attribute15%type ,
284: attribute16 gmd_operation_resources.attribute16%type ,
285: attribute17 gmd_operation_resources.attribute17%type ,
286: attribute18 gmd_operation_resources.attribute18%type ,
287: attribute19 gmd_operation_resources.attribute19%type ,
280: attribute12 gmd_operation_resources.attribute12%type ,
281: attribute13 gmd_operation_resources.attribute13%type ,
282: attribute14 gmd_operation_resources.attribute14%type ,
283: attribute15 gmd_operation_resources.attribute15%type ,
284: attribute16 gmd_operation_resources.attribute16%type ,
285: attribute17 gmd_operation_resources.attribute17%type ,
286: attribute18 gmd_operation_resources.attribute18%type ,
287: attribute19 gmd_operation_resources.attribute19%type ,
288: attribute20 gmd_operation_resources.attribute20%type ,
281: attribute13 gmd_operation_resources.attribute13%type ,
282: attribute14 gmd_operation_resources.attribute14%type ,
283: attribute15 gmd_operation_resources.attribute15%type ,
284: attribute16 gmd_operation_resources.attribute16%type ,
285: attribute17 gmd_operation_resources.attribute17%type ,
286: attribute18 gmd_operation_resources.attribute18%type ,
287: attribute19 gmd_operation_resources.attribute19%type ,
288: attribute20 gmd_operation_resources.attribute20%type ,
289: attribute21 gmd_operation_resources.attribute21%type ,
282: attribute14 gmd_operation_resources.attribute14%type ,
283: attribute15 gmd_operation_resources.attribute15%type ,
284: attribute16 gmd_operation_resources.attribute16%type ,
285: attribute17 gmd_operation_resources.attribute17%type ,
286: attribute18 gmd_operation_resources.attribute18%type ,
287: attribute19 gmd_operation_resources.attribute19%type ,
288: attribute20 gmd_operation_resources.attribute20%type ,
289: attribute21 gmd_operation_resources.attribute21%type ,
290: attribute22 gmd_operation_resources.attribute22%type ,
283: attribute15 gmd_operation_resources.attribute15%type ,
284: attribute16 gmd_operation_resources.attribute16%type ,
285: attribute17 gmd_operation_resources.attribute17%type ,
286: attribute18 gmd_operation_resources.attribute18%type ,
287: attribute19 gmd_operation_resources.attribute19%type ,
288: attribute20 gmd_operation_resources.attribute20%type ,
289: attribute21 gmd_operation_resources.attribute21%type ,
290: attribute22 gmd_operation_resources.attribute22%type ,
291: attribute23 gmd_operation_resources.attribute23%type ,
284: attribute16 gmd_operation_resources.attribute16%type ,
285: attribute17 gmd_operation_resources.attribute17%type ,
286: attribute18 gmd_operation_resources.attribute18%type ,
287: attribute19 gmd_operation_resources.attribute19%type ,
288: attribute20 gmd_operation_resources.attribute20%type ,
289: attribute21 gmd_operation_resources.attribute21%type ,
290: attribute22 gmd_operation_resources.attribute22%type ,
291: attribute23 gmd_operation_resources.attribute23%type ,
292: attribute24 gmd_operation_resources.attribute24%type ,
285: attribute17 gmd_operation_resources.attribute17%type ,
286: attribute18 gmd_operation_resources.attribute18%type ,
287: attribute19 gmd_operation_resources.attribute19%type ,
288: attribute20 gmd_operation_resources.attribute20%type ,
289: attribute21 gmd_operation_resources.attribute21%type ,
290: attribute22 gmd_operation_resources.attribute22%type ,
291: attribute23 gmd_operation_resources.attribute23%type ,
292: attribute24 gmd_operation_resources.attribute24%type ,
293: attribute25 gmd_operation_resources.attribute25%type ,
286: attribute18 gmd_operation_resources.attribute18%type ,
287: attribute19 gmd_operation_resources.attribute19%type ,
288: attribute20 gmd_operation_resources.attribute20%type ,
289: attribute21 gmd_operation_resources.attribute21%type ,
290: attribute22 gmd_operation_resources.attribute22%type ,
291: attribute23 gmd_operation_resources.attribute23%type ,
292: attribute24 gmd_operation_resources.attribute24%type ,
293: attribute25 gmd_operation_resources.attribute25%type ,
294: attribute26 gmd_operation_resources.attribute26%type ,
287: attribute19 gmd_operation_resources.attribute19%type ,
288: attribute20 gmd_operation_resources.attribute20%type ,
289: attribute21 gmd_operation_resources.attribute21%type ,
290: attribute22 gmd_operation_resources.attribute22%type ,
291: attribute23 gmd_operation_resources.attribute23%type ,
292: attribute24 gmd_operation_resources.attribute24%type ,
293: attribute25 gmd_operation_resources.attribute25%type ,
294: attribute26 gmd_operation_resources.attribute26%type ,
295: attribute27 gmd_operation_resources.attribute27%type ,
288: attribute20 gmd_operation_resources.attribute20%type ,
289: attribute21 gmd_operation_resources.attribute21%type ,
290: attribute22 gmd_operation_resources.attribute22%type ,
291: attribute23 gmd_operation_resources.attribute23%type ,
292: attribute24 gmd_operation_resources.attribute24%type ,
293: attribute25 gmd_operation_resources.attribute25%type ,
294: attribute26 gmd_operation_resources.attribute26%type ,
295: attribute27 gmd_operation_resources.attribute27%type ,
296: attribute28 gmd_operation_resources.attribute28%type ,
289: attribute21 gmd_operation_resources.attribute21%type ,
290: attribute22 gmd_operation_resources.attribute22%type ,
291: attribute23 gmd_operation_resources.attribute23%type ,
292: attribute24 gmd_operation_resources.attribute24%type ,
293: attribute25 gmd_operation_resources.attribute25%type ,
294: attribute26 gmd_operation_resources.attribute26%type ,
295: attribute27 gmd_operation_resources.attribute27%type ,
296: attribute28 gmd_operation_resources.attribute28%type ,
297: attribute29 gmd_operation_resources.attribute29%type ,
290: attribute22 gmd_operation_resources.attribute22%type ,
291: attribute23 gmd_operation_resources.attribute23%type ,
292: attribute24 gmd_operation_resources.attribute24%type ,
293: attribute25 gmd_operation_resources.attribute25%type ,
294: attribute26 gmd_operation_resources.attribute26%type ,
295: attribute27 gmd_operation_resources.attribute27%type ,
296: attribute28 gmd_operation_resources.attribute28%type ,
297: attribute29 gmd_operation_resources.attribute29%type ,
298: attribute30 gmd_operation_resources.attribute30%type
291: attribute23 gmd_operation_resources.attribute23%type ,
292: attribute24 gmd_operation_resources.attribute24%type ,
293: attribute25 gmd_operation_resources.attribute25%type ,
294: attribute26 gmd_operation_resources.attribute26%type ,
295: attribute27 gmd_operation_resources.attribute27%type ,
296: attribute28 gmd_operation_resources.attribute28%type ,
297: attribute29 gmd_operation_resources.attribute29%type ,
298: attribute30 gmd_operation_resources.attribute30%type
299:
292: attribute24 gmd_operation_resources.attribute24%type ,
293: attribute25 gmd_operation_resources.attribute25%type ,
294: attribute26 gmd_operation_resources.attribute26%type ,
295: attribute27 gmd_operation_resources.attribute27%type ,
296: attribute28 gmd_operation_resources.attribute28%type ,
297: attribute29 gmd_operation_resources.attribute29%type ,
298: attribute30 gmd_operation_resources.attribute30%type
299:
300: );
293: attribute25 gmd_operation_resources.attribute25%type ,
294: attribute26 gmd_operation_resources.attribute26%type ,
295: attribute27 gmd_operation_resources.attribute27%type ,
296: attribute28 gmd_operation_resources.attribute28%type ,
297: attribute29 gmd_operation_resources.attribute29%type ,
298: attribute30 gmd_operation_resources.attribute30%type
299:
300: );
301: TYPE oprn_resc_tbl IS TABLE OF oprn_resc_rec
294: attribute26 gmd_operation_resources.attribute26%type ,
295: attribute27 gmd_operation_resources.attribute27%type ,
296: attribute28 gmd_operation_resources.attribute28%type ,
297: attribute29 gmd_operation_resources.attribute29%type ,
298: attribute30 gmd_operation_resources.attribute30%type
299:
300: );
301: TYPE oprn_resc_tbl IS TABLE OF oprn_resc_rec
302: INDEX BY BINARY_INTEGER;
306: (
307: recipe_id gmd_recipes.recipe_id%type ,
308: routingstep_id fm_rout_dtl.routingstep_id%type ,
309: routingstep_no fm_rout_dtl.routingstep_no%type ,
310: oprn_line_id gmd_operation_resources.oprn_line_id%type ,
311: resources gmd_operation_resources.resources%type ,
312: parameter_id gmp_process_parameters.parameter_id%type ,
313: parameter_name gmp_process_parameters.parameter_name%type ,
314: parameter_description gmp_process_parameters.parameter_description%type ,
307: recipe_id gmd_recipes.recipe_id%type ,
308: routingstep_id fm_rout_dtl.routingstep_id%type ,
309: routingstep_no fm_rout_dtl.routingstep_no%type ,
310: oprn_line_id gmd_operation_resources.oprn_line_id%type ,
311: resources gmd_operation_resources.resources%type ,
312: parameter_id gmp_process_parameters.parameter_id%type ,
313: parameter_name gmp_process_parameters.parameter_name%type ,
314: parameter_description gmp_process_parameters.parameter_description%type ,
315: units gmp_process_parameters.units%type ,