DBA Data[Home] [Help]

APPS.GMD_RECIPE_FETCH_PUB dependencies on GMD_OPERATION_RESOURCES

Line 95: resources gmd_operation_resources.resources%type

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:

Line 168: oprn_line_id gmd_operation_resources.oprn_line_id%type ,

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 ,

Line 178: text_code gmd_operation_resources.text_code%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 ,

Line 179: created_by gmd_operation_resources.created_by%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 ,

Line 180: last_updated_by gmd_operation_resources.last_updated_by%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 ,

Line 181: last_update_date gmd_operation_resources.last_update_date%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 ,

Line 182: creation_date gmd_operation_resources.creation_date%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 ,

Line 183: last_update_login gmd_operation_resources.last_update_login%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 ,

Line 184: attribute_category gmd_operation_resources.attribute_category%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 ,

Line 185: attribute1 gmd_operation_resources.attribute1%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 ,

Line 186: attribute2 gmd_operation_resources.attribute2%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 ,

Line 187: attribute3 gmd_operation_resources.attribute3%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 ,

Line 188: attribute4 gmd_operation_resources.attribute4%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 ,

Line 189: attribute5 gmd_operation_resources.attribute5%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 ,

Line 190: attribute6 gmd_operation_resources.attribute6%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 ,

Line 191: attribute7 gmd_operation_resources.attribute7%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 ,

Line 192: attribute8 gmd_operation_resources.attribute8%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 ,

Line 193: attribute9 gmd_operation_resources.attribute9%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 ,

Line 194: attribute10 gmd_operation_resources.attribute10%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 ,

Line 195: attribute11 gmd_operation_resources.attribute11%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 ,

Line 196: attribute12 gmd_operation_resources.attribute12%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 ,

Line 197: attribute13 gmd_operation_resources.attribute13%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 ,

Line 198: attribute14 gmd_operation_resources.attribute14%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 ,

Line 199: attribute15 gmd_operation_resources.attribute15%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 ,

Line 200: attribute16 gmd_operation_resources.attribute16%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 ,

Line 201: attribute17 gmd_operation_resources.attribute17%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 ,

Line 202: attribute18 gmd_operation_resources.attribute18%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 ,

Line 203: attribute19 gmd_operation_resources.attribute19%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 ,

Line 204: attribute20 gmd_operation_resources.attribute20%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 ,

Line 205: attribute21 gmd_operation_resources.attribute21%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 ,

Line 206: attribute22 gmd_operation_resources.attribute22%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 ,

Line 207: attribute23 gmd_operation_resources.attribute23%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 ,

Line 208: attribute24 gmd_operation_resources.attribute24%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 ,

Line 209: attribute25 gmd_operation_resources.attribute25%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 ,

Line 210: attribute26 gmd_operation_resources.attribute26%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

Line 211: attribute27 gmd_operation_resources.attribute27%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:

Line 212: attribute28 gmd_operation_resources.attribute28%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:
216: );

Line 213: attribute29 gmd_operation_resources.attribute29%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: );
217:

Line 214: attribute30 gmd_operation_resources.attribute30%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:
218: TYPE oprn_act_tbl IS TABLE OF oprn_act_out

Line 237: oprn_line_id gmd_operation_resources.oprn_line_id%type ,

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 ,

Line 238: resources gmd_operation_resources.resources%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 ,

Line 239: resource_usage gmd_operation_resources.resource_usage%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 ,

Line 240: resource_count gmd_operation_resources.resource_count%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 ,

Line 241: process_qty gmd_operation_resources.process_qty%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 ,

Line 242: process_uom gmd_operation_resources.resource_process_uom%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 ,

Line 243: prim_rsrc_ind gmd_operation_resources.prim_rsrc_ind%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 ,

Line 244: scale_type gmd_operation_resources.scale_type%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 ,

Line 245: cost_analysis_code gmd_operation_resources.cost_analysis_code%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 ,

Line 246: cost_cmpntcls_id gmd_operation_resources.cost_cmpntcls_id%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 ,

Line 247: usage_um gmd_operation_resources.resource_usage_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 ,
251:

Line 248: offset_interval gmd_operation_resources.offset_interval%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:
252: max_calc_capacity cr_rsrc_mst.max_capacity%type ,/*Added in bug 13440294 ,this column take the tolerance into conern,fix the bug 4671464's error*/

Line 259: process_parameter_1 gmd_operation_resources.process_parameter_1%type ,

255: capacity_constraint cr_rsrc_mst.capacity_constraint%type ,
256: capacity_tolerance cr_rsrc_dtl.capacity_tolerance%type ,
257: capacity_uom cr_rsrc_dtl.capacity_um%type,
258:
259: process_parameter_1 gmd_operation_resources.process_parameter_1%type ,
260: process_parameter_2 gmd_operation_resources.process_parameter_2%type ,
261: process_parameter_3 gmd_operation_resources.process_parameter_3%type ,
262: process_parameter_4 gmd_operation_resources.process_parameter_4%type ,
263: process_parameter_5 gmd_operation_resources.PROCESS_PARAMETER_5%type ,

Line 260: process_parameter_2 gmd_operation_resources.process_parameter_2%type ,

256: capacity_tolerance cr_rsrc_dtl.capacity_tolerance%type ,
257: capacity_uom cr_rsrc_dtl.capacity_um%type,
258:
259: process_parameter_1 gmd_operation_resources.process_parameter_1%type ,
260: process_parameter_2 gmd_operation_resources.process_parameter_2%type ,
261: process_parameter_3 gmd_operation_resources.process_parameter_3%type ,
262: process_parameter_4 gmd_operation_resources.process_parameter_4%type ,
263: process_parameter_5 gmd_operation_resources.PROCESS_PARAMETER_5%type ,
264:

Line 261: process_parameter_3 gmd_operation_resources.process_parameter_3%type ,

257: capacity_uom cr_rsrc_dtl.capacity_um%type,
258:
259: process_parameter_1 gmd_operation_resources.process_parameter_1%type ,
260: process_parameter_2 gmd_operation_resources.process_parameter_2%type ,
261: process_parameter_3 gmd_operation_resources.process_parameter_3%type ,
262: process_parameter_4 gmd_operation_resources.process_parameter_4%type ,
263: process_parameter_5 gmd_operation_resources.PROCESS_PARAMETER_5%type ,
264:
265: recipe_override NUMBER(5) ,

Line 262: process_parameter_4 gmd_operation_resources.process_parameter_4%type ,

258:
259: process_parameter_1 gmd_operation_resources.process_parameter_1%type ,
260: process_parameter_2 gmd_operation_resources.process_parameter_2%type ,
261: process_parameter_3 gmd_operation_resources.process_parameter_3%type ,
262: process_parameter_4 gmd_operation_resources.process_parameter_4%type ,
263: process_parameter_5 gmd_operation_resources.PROCESS_PARAMETER_5%type ,
264:
265: recipe_override NUMBER(5) ,
266: text_code gmd_operation_resources.text_code%type ,

Line 263: process_parameter_5 gmd_operation_resources.PROCESS_PARAMETER_5%type ,

259: process_parameter_1 gmd_operation_resources.process_parameter_1%type ,
260: process_parameter_2 gmd_operation_resources.process_parameter_2%type ,
261: process_parameter_3 gmd_operation_resources.process_parameter_3%type ,
262: process_parameter_4 gmd_operation_resources.process_parameter_4%type ,
263: process_parameter_5 gmd_operation_resources.PROCESS_PARAMETER_5%type ,
264:
265: recipe_override NUMBER(5) ,
266: text_code gmd_operation_resources.text_code%type ,
267: created_by gmd_operation_resources.created_by%type ,

Line 266: text_code gmd_operation_resources.text_code%type ,

262: process_parameter_4 gmd_operation_resources.process_parameter_4%type ,
263: process_parameter_5 gmd_operation_resources.PROCESS_PARAMETER_5%type ,
264:
265: recipe_override NUMBER(5) ,
266: text_code gmd_operation_resources.text_code%type ,
267: created_by gmd_operation_resources.created_by%type ,
268: last_updated_by gmd_operation_resources.last_updated_by%type ,
269: last_update_date gmd_operation_resources.last_update_date%type ,
270: creation_date gmd_operation_resources.creation_date%type ,

Line 267: created_by gmd_operation_resources.created_by%type ,

263: process_parameter_5 gmd_operation_resources.PROCESS_PARAMETER_5%type ,
264:
265: recipe_override NUMBER(5) ,
266: text_code gmd_operation_resources.text_code%type ,
267: created_by gmd_operation_resources.created_by%type ,
268: last_updated_by gmd_operation_resources.last_updated_by%type ,
269: last_update_date gmd_operation_resources.last_update_date%type ,
270: creation_date gmd_operation_resources.creation_date%type ,
271: last_update_login gmd_operation_resources.last_update_login%type ,

Line 268: last_updated_by gmd_operation_resources.last_updated_by%type ,

264:
265: recipe_override NUMBER(5) ,
266: text_code gmd_operation_resources.text_code%type ,
267: created_by gmd_operation_resources.created_by%type ,
268: last_updated_by gmd_operation_resources.last_updated_by%type ,
269: last_update_date gmd_operation_resources.last_update_date%type ,
270: creation_date gmd_operation_resources.creation_date%type ,
271: last_update_login gmd_operation_resources.last_update_login%type ,
272: attribute_category gmd_operation_resources.attribute_category%type ,

Line 269: last_update_date gmd_operation_resources.last_update_date%type ,

265: recipe_override NUMBER(5) ,
266: text_code gmd_operation_resources.text_code%type ,
267: created_by gmd_operation_resources.created_by%type ,
268: last_updated_by gmd_operation_resources.last_updated_by%type ,
269: last_update_date gmd_operation_resources.last_update_date%type ,
270: creation_date gmd_operation_resources.creation_date%type ,
271: last_update_login gmd_operation_resources.last_update_login%type ,
272: attribute_category gmd_operation_resources.attribute_category%type ,
273: attribute1 gmd_operation_resources.attribute1%type ,

Line 270: creation_date gmd_operation_resources.creation_date%type ,

266: text_code gmd_operation_resources.text_code%type ,
267: created_by gmd_operation_resources.created_by%type ,
268: last_updated_by gmd_operation_resources.last_updated_by%type ,
269: last_update_date gmd_operation_resources.last_update_date%type ,
270: creation_date gmd_operation_resources.creation_date%type ,
271: last_update_login gmd_operation_resources.last_update_login%type ,
272: attribute_category gmd_operation_resources.attribute_category%type ,
273: attribute1 gmd_operation_resources.attribute1%type ,
274: attribute2 gmd_operation_resources.attribute2%type ,

Line 271: last_update_login gmd_operation_resources.last_update_login%type ,

267: created_by gmd_operation_resources.created_by%type ,
268: last_updated_by gmd_operation_resources.last_updated_by%type ,
269: last_update_date gmd_operation_resources.last_update_date%type ,
270: creation_date gmd_operation_resources.creation_date%type ,
271: last_update_login gmd_operation_resources.last_update_login%type ,
272: attribute_category gmd_operation_resources.attribute_category%type ,
273: attribute1 gmd_operation_resources.attribute1%type ,
274: attribute2 gmd_operation_resources.attribute2%type ,
275: attribute3 gmd_operation_resources.attribute3%type ,

Line 272: attribute_category gmd_operation_resources.attribute_category%type ,

268: last_updated_by gmd_operation_resources.last_updated_by%type ,
269: last_update_date gmd_operation_resources.last_update_date%type ,
270: creation_date gmd_operation_resources.creation_date%type ,
271: last_update_login gmd_operation_resources.last_update_login%type ,
272: attribute_category gmd_operation_resources.attribute_category%type ,
273: attribute1 gmd_operation_resources.attribute1%type ,
274: attribute2 gmd_operation_resources.attribute2%type ,
275: attribute3 gmd_operation_resources.attribute3%type ,
276: attribute4 gmd_operation_resources.attribute4%type ,

Line 273: attribute1 gmd_operation_resources.attribute1%type ,

269: last_update_date gmd_operation_resources.last_update_date%type ,
270: creation_date gmd_operation_resources.creation_date%type ,
271: last_update_login gmd_operation_resources.last_update_login%type ,
272: attribute_category gmd_operation_resources.attribute_category%type ,
273: attribute1 gmd_operation_resources.attribute1%type ,
274: attribute2 gmd_operation_resources.attribute2%type ,
275: attribute3 gmd_operation_resources.attribute3%type ,
276: attribute4 gmd_operation_resources.attribute4%type ,
277: attribute5 gmd_operation_resources.attribute5%type ,

Line 274: attribute2 gmd_operation_resources.attribute2%type ,

270: creation_date gmd_operation_resources.creation_date%type ,
271: last_update_login gmd_operation_resources.last_update_login%type ,
272: attribute_category gmd_operation_resources.attribute_category%type ,
273: attribute1 gmd_operation_resources.attribute1%type ,
274: attribute2 gmd_operation_resources.attribute2%type ,
275: attribute3 gmd_operation_resources.attribute3%type ,
276: attribute4 gmd_operation_resources.attribute4%type ,
277: attribute5 gmd_operation_resources.attribute5%type ,
278: attribute6 gmd_operation_resources.attribute6%type ,

Line 275: attribute3 gmd_operation_resources.attribute3%type ,

271: last_update_login gmd_operation_resources.last_update_login%type ,
272: attribute_category gmd_operation_resources.attribute_category%type ,
273: attribute1 gmd_operation_resources.attribute1%type ,
274: attribute2 gmd_operation_resources.attribute2%type ,
275: attribute3 gmd_operation_resources.attribute3%type ,
276: attribute4 gmd_operation_resources.attribute4%type ,
277: attribute5 gmd_operation_resources.attribute5%type ,
278: attribute6 gmd_operation_resources.attribute6%type ,
279: attribute7 gmd_operation_resources.attribute7%type ,

Line 276: attribute4 gmd_operation_resources.attribute4%type ,

272: attribute_category gmd_operation_resources.attribute_category%type ,
273: attribute1 gmd_operation_resources.attribute1%type ,
274: attribute2 gmd_operation_resources.attribute2%type ,
275: attribute3 gmd_operation_resources.attribute3%type ,
276: attribute4 gmd_operation_resources.attribute4%type ,
277: attribute5 gmd_operation_resources.attribute5%type ,
278: attribute6 gmd_operation_resources.attribute6%type ,
279: attribute7 gmd_operation_resources.attribute7%type ,
280: attribute8 gmd_operation_resources.attribute8%type ,

Line 277: attribute5 gmd_operation_resources.attribute5%type ,

273: attribute1 gmd_operation_resources.attribute1%type ,
274: attribute2 gmd_operation_resources.attribute2%type ,
275: attribute3 gmd_operation_resources.attribute3%type ,
276: attribute4 gmd_operation_resources.attribute4%type ,
277: attribute5 gmd_operation_resources.attribute5%type ,
278: attribute6 gmd_operation_resources.attribute6%type ,
279: attribute7 gmd_operation_resources.attribute7%type ,
280: attribute8 gmd_operation_resources.attribute8%type ,
281: attribute9 gmd_operation_resources.attribute9%type ,

Line 278: attribute6 gmd_operation_resources.attribute6%type ,

274: attribute2 gmd_operation_resources.attribute2%type ,
275: attribute3 gmd_operation_resources.attribute3%type ,
276: attribute4 gmd_operation_resources.attribute4%type ,
277: attribute5 gmd_operation_resources.attribute5%type ,
278: attribute6 gmd_operation_resources.attribute6%type ,
279: attribute7 gmd_operation_resources.attribute7%type ,
280: attribute8 gmd_operation_resources.attribute8%type ,
281: attribute9 gmd_operation_resources.attribute9%type ,
282: attribute10 gmd_operation_resources.attribute10%type ,

Line 279: attribute7 gmd_operation_resources.attribute7%type ,

275: attribute3 gmd_operation_resources.attribute3%type ,
276: attribute4 gmd_operation_resources.attribute4%type ,
277: attribute5 gmd_operation_resources.attribute5%type ,
278: attribute6 gmd_operation_resources.attribute6%type ,
279: attribute7 gmd_operation_resources.attribute7%type ,
280: attribute8 gmd_operation_resources.attribute8%type ,
281: attribute9 gmd_operation_resources.attribute9%type ,
282: attribute10 gmd_operation_resources.attribute10%type ,
283: attribute11 gmd_operation_resources.attribute11%type ,

Line 280: attribute8 gmd_operation_resources.attribute8%type ,

276: attribute4 gmd_operation_resources.attribute4%type ,
277: attribute5 gmd_operation_resources.attribute5%type ,
278: attribute6 gmd_operation_resources.attribute6%type ,
279: attribute7 gmd_operation_resources.attribute7%type ,
280: attribute8 gmd_operation_resources.attribute8%type ,
281: attribute9 gmd_operation_resources.attribute9%type ,
282: attribute10 gmd_operation_resources.attribute10%type ,
283: attribute11 gmd_operation_resources.attribute11%type ,
284: attribute12 gmd_operation_resources.attribute12%type ,

Line 281: attribute9 gmd_operation_resources.attribute9%type ,

277: attribute5 gmd_operation_resources.attribute5%type ,
278: attribute6 gmd_operation_resources.attribute6%type ,
279: attribute7 gmd_operation_resources.attribute7%type ,
280: attribute8 gmd_operation_resources.attribute8%type ,
281: attribute9 gmd_operation_resources.attribute9%type ,
282: attribute10 gmd_operation_resources.attribute10%type ,
283: attribute11 gmd_operation_resources.attribute11%type ,
284: attribute12 gmd_operation_resources.attribute12%type ,
285: attribute13 gmd_operation_resources.attribute13%type ,

Line 282: attribute10 gmd_operation_resources.attribute10%type ,

278: attribute6 gmd_operation_resources.attribute6%type ,
279: attribute7 gmd_operation_resources.attribute7%type ,
280: attribute8 gmd_operation_resources.attribute8%type ,
281: attribute9 gmd_operation_resources.attribute9%type ,
282: attribute10 gmd_operation_resources.attribute10%type ,
283: attribute11 gmd_operation_resources.attribute11%type ,
284: attribute12 gmd_operation_resources.attribute12%type ,
285: attribute13 gmd_operation_resources.attribute13%type ,
286: attribute14 gmd_operation_resources.attribute14%type ,

Line 283: attribute11 gmd_operation_resources.attribute11%type ,

279: attribute7 gmd_operation_resources.attribute7%type ,
280: attribute8 gmd_operation_resources.attribute8%type ,
281: attribute9 gmd_operation_resources.attribute9%type ,
282: attribute10 gmd_operation_resources.attribute10%type ,
283: attribute11 gmd_operation_resources.attribute11%type ,
284: attribute12 gmd_operation_resources.attribute12%type ,
285: attribute13 gmd_operation_resources.attribute13%type ,
286: attribute14 gmd_operation_resources.attribute14%type ,
287: attribute15 gmd_operation_resources.attribute15%type ,

Line 284: attribute12 gmd_operation_resources.attribute12%type ,

280: attribute8 gmd_operation_resources.attribute8%type ,
281: attribute9 gmd_operation_resources.attribute9%type ,
282: attribute10 gmd_operation_resources.attribute10%type ,
283: attribute11 gmd_operation_resources.attribute11%type ,
284: attribute12 gmd_operation_resources.attribute12%type ,
285: attribute13 gmd_operation_resources.attribute13%type ,
286: attribute14 gmd_operation_resources.attribute14%type ,
287: attribute15 gmd_operation_resources.attribute15%type ,
288: attribute16 gmd_operation_resources.attribute16%type ,

Line 285: attribute13 gmd_operation_resources.attribute13%type ,

281: attribute9 gmd_operation_resources.attribute9%type ,
282: attribute10 gmd_operation_resources.attribute10%type ,
283: attribute11 gmd_operation_resources.attribute11%type ,
284: attribute12 gmd_operation_resources.attribute12%type ,
285: attribute13 gmd_operation_resources.attribute13%type ,
286: attribute14 gmd_operation_resources.attribute14%type ,
287: attribute15 gmd_operation_resources.attribute15%type ,
288: attribute16 gmd_operation_resources.attribute16%type ,
289: attribute17 gmd_operation_resources.attribute17%type ,

Line 286: attribute14 gmd_operation_resources.attribute14%type ,

282: attribute10 gmd_operation_resources.attribute10%type ,
283: attribute11 gmd_operation_resources.attribute11%type ,
284: attribute12 gmd_operation_resources.attribute12%type ,
285: attribute13 gmd_operation_resources.attribute13%type ,
286: attribute14 gmd_operation_resources.attribute14%type ,
287: attribute15 gmd_operation_resources.attribute15%type ,
288: attribute16 gmd_operation_resources.attribute16%type ,
289: attribute17 gmd_operation_resources.attribute17%type ,
290: attribute18 gmd_operation_resources.attribute18%type ,

Line 287: attribute15 gmd_operation_resources.attribute15%type ,

283: attribute11 gmd_operation_resources.attribute11%type ,
284: attribute12 gmd_operation_resources.attribute12%type ,
285: attribute13 gmd_operation_resources.attribute13%type ,
286: attribute14 gmd_operation_resources.attribute14%type ,
287: attribute15 gmd_operation_resources.attribute15%type ,
288: attribute16 gmd_operation_resources.attribute16%type ,
289: attribute17 gmd_operation_resources.attribute17%type ,
290: attribute18 gmd_operation_resources.attribute18%type ,
291: attribute19 gmd_operation_resources.attribute19%type ,

Line 288: attribute16 gmd_operation_resources.attribute16%type ,

284: attribute12 gmd_operation_resources.attribute12%type ,
285: attribute13 gmd_operation_resources.attribute13%type ,
286: attribute14 gmd_operation_resources.attribute14%type ,
287: attribute15 gmd_operation_resources.attribute15%type ,
288: attribute16 gmd_operation_resources.attribute16%type ,
289: attribute17 gmd_operation_resources.attribute17%type ,
290: attribute18 gmd_operation_resources.attribute18%type ,
291: attribute19 gmd_operation_resources.attribute19%type ,
292: attribute20 gmd_operation_resources.attribute20%type ,

Line 289: attribute17 gmd_operation_resources.attribute17%type ,

285: attribute13 gmd_operation_resources.attribute13%type ,
286: attribute14 gmd_operation_resources.attribute14%type ,
287: attribute15 gmd_operation_resources.attribute15%type ,
288: attribute16 gmd_operation_resources.attribute16%type ,
289: attribute17 gmd_operation_resources.attribute17%type ,
290: attribute18 gmd_operation_resources.attribute18%type ,
291: attribute19 gmd_operation_resources.attribute19%type ,
292: attribute20 gmd_operation_resources.attribute20%type ,
293: attribute21 gmd_operation_resources.attribute21%type ,

Line 290: attribute18 gmd_operation_resources.attribute18%type ,

286: attribute14 gmd_operation_resources.attribute14%type ,
287: attribute15 gmd_operation_resources.attribute15%type ,
288: attribute16 gmd_operation_resources.attribute16%type ,
289: attribute17 gmd_operation_resources.attribute17%type ,
290: attribute18 gmd_operation_resources.attribute18%type ,
291: attribute19 gmd_operation_resources.attribute19%type ,
292: attribute20 gmd_operation_resources.attribute20%type ,
293: attribute21 gmd_operation_resources.attribute21%type ,
294: attribute22 gmd_operation_resources.attribute22%type ,

Line 291: attribute19 gmd_operation_resources.attribute19%type ,

287: attribute15 gmd_operation_resources.attribute15%type ,
288: attribute16 gmd_operation_resources.attribute16%type ,
289: attribute17 gmd_operation_resources.attribute17%type ,
290: attribute18 gmd_operation_resources.attribute18%type ,
291: attribute19 gmd_operation_resources.attribute19%type ,
292: attribute20 gmd_operation_resources.attribute20%type ,
293: attribute21 gmd_operation_resources.attribute21%type ,
294: attribute22 gmd_operation_resources.attribute22%type ,
295: attribute23 gmd_operation_resources.attribute23%type ,

Line 292: attribute20 gmd_operation_resources.attribute20%type ,

288: attribute16 gmd_operation_resources.attribute16%type ,
289: attribute17 gmd_operation_resources.attribute17%type ,
290: attribute18 gmd_operation_resources.attribute18%type ,
291: attribute19 gmd_operation_resources.attribute19%type ,
292: attribute20 gmd_operation_resources.attribute20%type ,
293: attribute21 gmd_operation_resources.attribute21%type ,
294: attribute22 gmd_operation_resources.attribute22%type ,
295: attribute23 gmd_operation_resources.attribute23%type ,
296: attribute24 gmd_operation_resources.attribute24%type ,

Line 293: attribute21 gmd_operation_resources.attribute21%type ,

289: attribute17 gmd_operation_resources.attribute17%type ,
290: attribute18 gmd_operation_resources.attribute18%type ,
291: attribute19 gmd_operation_resources.attribute19%type ,
292: attribute20 gmd_operation_resources.attribute20%type ,
293: attribute21 gmd_operation_resources.attribute21%type ,
294: attribute22 gmd_operation_resources.attribute22%type ,
295: attribute23 gmd_operation_resources.attribute23%type ,
296: attribute24 gmd_operation_resources.attribute24%type ,
297: attribute25 gmd_operation_resources.attribute25%type ,

Line 294: attribute22 gmd_operation_resources.attribute22%type ,

290: attribute18 gmd_operation_resources.attribute18%type ,
291: attribute19 gmd_operation_resources.attribute19%type ,
292: attribute20 gmd_operation_resources.attribute20%type ,
293: attribute21 gmd_operation_resources.attribute21%type ,
294: attribute22 gmd_operation_resources.attribute22%type ,
295: attribute23 gmd_operation_resources.attribute23%type ,
296: attribute24 gmd_operation_resources.attribute24%type ,
297: attribute25 gmd_operation_resources.attribute25%type ,
298: attribute26 gmd_operation_resources.attribute26%type ,

Line 295: attribute23 gmd_operation_resources.attribute23%type ,

291: attribute19 gmd_operation_resources.attribute19%type ,
292: attribute20 gmd_operation_resources.attribute20%type ,
293: attribute21 gmd_operation_resources.attribute21%type ,
294: attribute22 gmd_operation_resources.attribute22%type ,
295: attribute23 gmd_operation_resources.attribute23%type ,
296: attribute24 gmd_operation_resources.attribute24%type ,
297: attribute25 gmd_operation_resources.attribute25%type ,
298: attribute26 gmd_operation_resources.attribute26%type ,
299: attribute27 gmd_operation_resources.attribute27%type ,

Line 296: attribute24 gmd_operation_resources.attribute24%type ,

292: attribute20 gmd_operation_resources.attribute20%type ,
293: attribute21 gmd_operation_resources.attribute21%type ,
294: attribute22 gmd_operation_resources.attribute22%type ,
295: attribute23 gmd_operation_resources.attribute23%type ,
296: attribute24 gmd_operation_resources.attribute24%type ,
297: attribute25 gmd_operation_resources.attribute25%type ,
298: attribute26 gmd_operation_resources.attribute26%type ,
299: attribute27 gmd_operation_resources.attribute27%type ,
300: attribute28 gmd_operation_resources.attribute28%type ,

Line 297: attribute25 gmd_operation_resources.attribute25%type ,

293: attribute21 gmd_operation_resources.attribute21%type ,
294: attribute22 gmd_operation_resources.attribute22%type ,
295: attribute23 gmd_operation_resources.attribute23%type ,
296: attribute24 gmd_operation_resources.attribute24%type ,
297: attribute25 gmd_operation_resources.attribute25%type ,
298: attribute26 gmd_operation_resources.attribute26%type ,
299: attribute27 gmd_operation_resources.attribute27%type ,
300: attribute28 gmd_operation_resources.attribute28%type ,
301: attribute29 gmd_operation_resources.attribute29%type ,

Line 298: attribute26 gmd_operation_resources.attribute26%type ,

294: attribute22 gmd_operation_resources.attribute22%type ,
295: attribute23 gmd_operation_resources.attribute23%type ,
296: attribute24 gmd_operation_resources.attribute24%type ,
297: attribute25 gmd_operation_resources.attribute25%type ,
298: attribute26 gmd_operation_resources.attribute26%type ,
299: attribute27 gmd_operation_resources.attribute27%type ,
300: attribute28 gmd_operation_resources.attribute28%type ,
301: attribute29 gmd_operation_resources.attribute29%type ,
302: attribute30 gmd_operation_resources.attribute30%type

Line 299: attribute27 gmd_operation_resources.attribute27%type ,

295: attribute23 gmd_operation_resources.attribute23%type ,
296: attribute24 gmd_operation_resources.attribute24%type ,
297: attribute25 gmd_operation_resources.attribute25%type ,
298: attribute26 gmd_operation_resources.attribute26%type ,
299: attribute27 gmd_operation_resources.attribute27%type ,
300: attribute28 gmd_operation_resources.attribute28%type ,
301: attribute29 gmd_operation_resources.attribute29%type ,
302: attribute30 gmd_operation_resources.attribute30%type
303:

Line 300: attribute28 gmd_operation_resources.attribute28%type ,

296: attribute24 gmd_operation_resources.attribute24%type ,
297: attribute25 gmd_operation_resources.attribute25%type ,
298: attribute26 gmd_operation_resources.attribute26%type ,
299: attribute27 gmd_operation_resources.attribute27%type ,
300: attribute28 gmd_operation_resources.attribute28%type ,
301: attribute29 gmd_operation_resources.attribute29%type ,
302: attribute30 gmd_operation_resources.attribute30%type
303:
304: );

Line 301: attribute29 gmd_operation_resources.attribute29%type ,

297: attribute25 gmd_operation_resources.attribute25%type ,
298: attribute26 gmd_operation_resources.attribute26%type ,
299: attribute27 gmd_operation_resources.attribute27%type ,
300: attribute28 gmd_operation_resources.attribute28%type ,
301: attribute29 gmd_operation_resources.attribute29%type ,
302: attribute30 gmd_operation_resources.attribute30%type
303:
304: );
305: TYPE oprn_resc_tbl IS TABLE OF oprn_resc_rec

Line 302: attribute30 gmd_operation_resources.attribute30%type

298: attribute26 gmd_operation_resources.attribute26%type ,
299: attribute27 gmd_operation_resources.attribute27%type ,
300: attribute28 gmd_operation_resources.attribute28%type ,
301: attribute29 gmd_operation_resources.attribute29%type ,
302: attribute30 gmd_operation_resources.attribute30%type
303:
304: );
305: TYPE oprn_resc_tbl IS TABLE OF oprn_resc_rec
306: INDEX BY BINARY_INTEGER;

Line 314: oprn_line_id gmd_operation_resources.oprn_line_id%type ,

310: (
311: recipe_id gmd_recipes.recipe_id%type ,
312: routingstep_id fm_rout_dtl.routingstep_id%type ,
313: routingstep_no fm_rout_dtl.routingstep_no%type ,
314: oprn_line_id gmd_operation_resources.oprn_line_id%type ,
315: resources gmd_operation_resources.resources%type ,
316: parameter_id gmp_process_parameters.parameter_id%type ,
317: parameter_name gmp_process_parameters.parameter_name%type ,
318: parameter_description gmp_process_parameters.parameter_description%type ,

Line 315: resources gmd_operation_resources.resources%type ,

311: recipe_id gmd_recipes.recipe_id%type ,
312: routingstep_id fm_rout_dtl.routingstep_id%type ,
313: routingstep_no fm_rout_dtl.routingstep_no%type ,
314: oprn_line_id gmd_operation_resources.oprn_line_id%type ,
315: resources gmd_operation_resources.resources%type ,
316: parameter_id gmp_process_parameters.parameter_id%type ,
317: parameter_name gmp_process_parameters.parameter_name%type ,
318: parameter_description gmp_process_parameters.parameter_description%type ,
319: units gmp_process_parameters.units%type ,