DBA Data[Home] [Help]

APPS.GMD_RECIPE_FETCH_PUB dependencies on GMD_OPERATIONS_VL

Line 44: oprn_id gmd_operations_vl.oprn_id%type ,

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 ,

Line 45: oprn_no gmd_operations_vl.oprn_no%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 ,

Line 46: oprn_desc gmd_operations_vl.oprn_desc%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 ,

Line 47: oprn_vers gmd_operations_vl.oprn_vers%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 */

Line 48: process_qty_uom gmd_operations_vl.process_qty_uom%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 */
52: /* Added the charges column to the table to be able to pass back */

Line 110: oprn_no gmd_operations_vl.oprn_no%type ,

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 ,

Line 111: oprn_desc gmd_operations_vl.oprn_desc%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 ,

Line 112: oprn_vers gmd_operations_vl.oprn_vers%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 ,

Line 113: process_qty_uom gmd_operations_vl.process_qty_uom%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 ,

Line 163: oprn_no gmd_operations_vl.oprn_no%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 ,

Line 164: oprn_vers gmd_operations_vl.oprn_vers%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 ,

Line 165: oprn_desc gmd_operations_vl.oprn_desc%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 ,

Line 166: oprn_id gmd_operations_vl.oprn_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 ,
170: activity_desc fm_actv_mst.activity_desc%type ,

Line 232: oprn_id gmd_operations_vl.oprn_id%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 ,

Line 233: oprn_no gmd_operations_vl.oprn_no%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 ,

Line 234: oprn_vers gmd_operations_vl.oprn_vers%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 ,

Line 235: oprn_desc gmd_operations_vl.oprn_desc%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 ,