40: routingstep_id fm_rout_dtl.routingstep_id%type ,
41: step_qty fm_rout_dtl.step_qty%type ,
42: steprelease_type fm_rout_dtl.steprelease_type%type ,
43: minimum_transfer_qty fm_rout_dtl.minimum_transfer_qty%type,
44: oprn_id gmd_operations_vl.oprn_id%type ,
45: oprn_no gmd_operations_vl.oprn_no%type ,
46: oprn_desc gmd_operations_vl.oprn_desc%type ,
47: oprn_vers gmd_operations_vl.oprn_vers%type ,
48: process_qty_uom gmd_operations_vl.process_qty_uom%type ,
41: step_qty fm_rout_dtl.step_qty%type ,
42: steprelease_type fm_rout_dtl.steprelease_type%type ,
43: minimum_transfer_qty fm_rout_dtl.minimum_transfer_qty%type,
44: oprn_id gmd_operations_vl.oprn_id%type ,
45: oprn_no gmd_operations_vl.oprn_no%type ,
46: oprn_desc gmd_operations_vl.oprn_desc%type ,
47: oprn_vers gmd_operations_vl.oprn_vers%type ,
48: process_qty_uom gmd_operations_vl.process_qty_uom%type ,
49: max_capacity cr_rsrc_mst.max_capacity%type ,
42: steprelease_type fm_rout_dtl.steprelease_type%type ,
43: minimum_transfer_qty fm_rout_dtl.minimum_transfer_qty%type,
44: oprn_id gmd_operations_vl.oprn_id%type ,
45: oprn_no gmd_operations_vl.oprn_no%type ,
46: oprn_desc gmd_operations_vl.oprn_desc%type ,
47: oprn_vers gmd_operations_vl.oprn_vers%type ,
48: process_qty_uom gmd_operations_vl.process_qty_uom%type ,
49: max_capacity cr_rsrc_mst.max_capacity%type ,
50: capacity_uom cr_rsrc_dtl.capacity_um%type ,
43: minimum_transfer_qty fm_rout_dtl.minimum_transfer_qty%type,
44: oprn_id gmd_operations_vl.oprn_id%type ,
45: oprn_no gmd_operations_vl.oprn_no%type ,
46: oprn_desc gmd_operations_vl.oprn_desc%type ,
47: oprn_vers gmd_operations_vl.oprn_vers%type ,
48: process_qty_uom gmd_operations_vl.process_qty_uom%type ,
49: max_capacity cr_rsrc_mst.max_capacity%type ,
50: capacity_uom cr_rsrc_dtl.capacity_um%type ,
51: /* Bug 1683702 Thomas Daniel */
44: oprn_id gmd_operations_vl.oprn_id%type ,
45: oprn_no gmd_operations_vl.oprn_no%type ,
46: oprn_desc gmd_operations_vl.oprn_desc%type ,
47: oprn_vers gmd_operations_vl.oprn_vers%type ,
48: process_qty_uom gmd_operations_vl.process_qty_uom%type ,
49: max_capacity cr_rsrc_mst.max_capacity%type ,
50: capacity_uom cr_rsrc_dtl.capacity_um%type ,
51: /* Bug 1683702 Thomas Daniel */
52: /* Added the charges column to the table to be able to pass back */
106: routingstep_id fm_rout_dtl.routingstep_id%type ,
107: step_qty fm_rout_dtl.step_qty%type ,
108: steprelease_type fm_rout_dtl.steprelease_type%type ,
109: oprn_id fm_rout_dtl.oprn_id%type ,
110: oprn_no gmd_operations_vl.oprn_no%type ,
111: oprn_desc gmd_operations_vl.oprn_desc%type ,
112: oprn_vers gmd_operations_vl.oprn_vers%type ,
113: process_qty_uom gmd_operations_vl.process_qty_uom%type ,
114: minimum_transfer_qty fm_rout_dtl.minimum_transfer_qty%type ,
107: step_qty fm_rout_dtl.step_qty%type ,
108: steprelease_type fm_rout_dtl.steprelease_type%type ,
109: oprn_id fm_rout_dtl.oprn_id%type ,
110: oprn_no gmd_operations_vl.oprn_no%type ,
111: oprn_desc gmd_operations_vl.oprn_desc%type ,
112: oprn_vers gmd_operations_vl.oprn_vers%type ,
113: process_qty_uom gmd_operations_vl.process_qty_uom%type ,
114: minimum_transfer_qty fm_rout_dtl.minimum_transfer_qty%type ,
115: max_capacity cr_rsrc_mst.max_capacity%type ,
108: steprelease_type fm_rout_dtl.steprelease_type%type ,
109: oprn_id fm_rout_dtl.oprn_id%type ,
110: oprn_no gmd_operations_vl.oprn_no%type ,
111: oprn_desc gmd_operations_vl.oprn_desc%type ,
112: oprn_vers gmd_operations_vl.oprn_vers%type ,
113: process_qty_uom gmd_operations_vl.process_qty_uom%type ,
114: minimum_transfer_qty fm_rout_dtl.minimum_transfer_qty%type ,
115: max_capacity cr_rsrc_mst.max_capacity%type ,
116: capacity_uom cr_rsrc_dtl.capacity_um%type ,
109: oprn_id fm_rout_dtl.oprn_id%type ,
110: oprn_no gmd_operations_vl.oprn_no%type ,
111: oprn_desc gmd_operations_vl.oprn_desc%type ,
112: oprn_vers gmd_operations_vl.oprn_vers%type ,
113: process_qty_uom gmd_operations_vl.process_qty_uom%type ,
114: minimum_transfer_qty fm_rout_dtl.minimum_transfer_qty%type ,
115: max_capacity cr_rsrc_mst.max_capacity%type ,
116: capacity_uom cr_rsrc_dtl.capacity_um%type ,
117: text_code fm_rout_dtl.text_code%type ,
159: TYPE oprn_act_out IS RECORD
160: ( recipe_id gmd_recipes.recipe_id%type ,
161: routingstep_id fm_rout_dtl.routingstep_id%type ,
162: routingstep_no fm_rout_dtl.routingstep_no%type ,
163: oprn_no gmd_operations_vl.oprn_no%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 ,
160: ( recipe_id gmd_recipes.recipe_id%type ,
161: routingstep_id fm_rout_dtl.routingstep_id%type ,
162: routingstep_no fm_rout_dtl.routingstep_no%type ,
163: oprn_no gmd_operations_vl.oprn_no%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 ,
161: routingstep_id fm_rout_dtl.routingstep_id%type ,
162: routingstep_no fm_rout_dtl.routingstep_no%type ,
163: oprn_no gmd_operations_vl.oprn_no%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 ,
162: routingstep_no fm_rout_dtl.routingstep_no%type ,
163: oprn_no gmd_operations_vl.oprn_no%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 ,
228: (
229: recipe_id gmd_recipes.recipe_id%type ,
230: routingstep_id fm_rout_dtl.routingstep_id%type ,
231: routingstep_no fm_rout_dtl.routingstep_no%type ,
232: oprn_id gmd_operations_vl.oprn_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 ,
229: recipe_id gmd_recipes.recipe_id%type ,
230: routingstep_id fm_rout_dtl.routingstep_id%type ,
231: routingstep_no fm_rout_dtl.routingstep_no%type ,
232: oprn_id gmd_operations_vl.oprn_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 ,
230: routingstep_id fm_rout_dtl.routingstep_id%type ,
231: routingstep_no fm_rout_dtl.routingstep_no%type ,
232: oprn_id gmd_operations_vl.oprn_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 ,
231: routingstep_no fm_rout_dtl.routingstep_no%type ,
232: oprn_id gmd_operations_vl.oprn_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 ,