APPS.GMD_RECIPE_FETCH_PUB dependencies on FM_ROUT_DTL

Line 39: routingstep_no fm_rout_dtl.routingstep_no%type ,

35: TYPE recipe_step_out IS RECORD
36:
37: (recipe_id gmd_recipes.recipe_id%type ,
38: rowid varchar2(18) ,
39: routingstep_no fm_rout_dtl.routingstep_no%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,

Line 40: routingstep_id fm_rout_dtl.routingstep_id%type ,

36:
37: (recipe_id gmd_recipes.recipe_id%type ,
38: rowid varchar2(18) ,
39: routingstep_no fm_rout_dtl.routingstep_no%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 ,

Line 41: step_qty fm_rout_dtl.step_qty%type ,

37: (recipe_id gmd_recipes.recipe_id%type ,
38: rowid varchar2(18) ,
39: routingstep_no fm_rout_dtl.routingstep_no%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 ,

Line 42: steprelease_type fm_rout_dtl.steprelease_type%type ,

38: rowid varchar2(18) ,
39: routingstep_no fm_rout_dtl.routingstep_no%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 ,

Line 43: minimum_transfer_qty fm_rout_dtl.minimum_transfer_qty%type,

39: routingstep_no fm_rout_dtl.routingstep_no%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 ,

Line 55: text_code fm_rout_dtl.text_code%type ,

51: /* Bug 1683702 Thomas Daniel */
52: /* Added the charges column to the table to be able to pass back */
53: /* the charges also in the recipe step detail fetch */
54: charge integer ,
55: text_code fm_rout_dtl.text_code%type ,
56: creation_date fm_rout_dtl.creation_date%type ,
57: created_by fm_rout_dtl.created_by%type ,
58: last_updated_by fm_rout_dtl.last_updated_by%type ,
59: last_update_date fm_rout_dtl.last_update_date%type ,

Line 56: creation_date fm_rout_dtl.creation_date%type ,

52: /* Added the charges column to the table to be able to pass back */
53: /* the charges also in the recipe step detail fetch */
54: charge integer ,
55: text_code fm_rout_dtl.text_code%type ,
56: creation_date fm_rout_dtl.creation_date%type ,
57: created_by fm_rout_dtl.created_by%type ,
58: last_updated_by fm_rout_dtl.last_updated_by%type ,
59: last_update_date fm_rout_dtl.last_update_date%type ,
60: last_update_login fm_rout_dtl.last_update_login%type ,

Line 57: created_by fm_rout_dtl.created_by%type ,

53: /* the charges also in the recipe step detail fetch */
54: charge integer ,
55: text_code fm_rout_dtl.text_code%type ,
56: creation_date fm_rout_dtl.creation_date%type ,
57: created_by fm_rout_dtl.created_by%type ,
58: last_updated_by fm_rout_dtl.last_updated_by%type ,
59: last_update_date fm_rout_dtl.last_update_date%type ,
60: last_update_login fm_rout_dtl.last_update_login%type ,
61: attribute_category fm_rout_dtl.attribute_category%type ,

Line 58: last_updated_by fm_rout_dtl.last_updated_by%type ,

54: charge integer ,
55: text_code fm_rout_dtl.text_code%type ,
56: creation_date fm_rout_dtl.creation_date%type ,
57: created_by fm_rout_dtl.created_by%type ,
58: last_updated_by fm_rout_dtl.last_updated_by%type ,
59: last_update_date fm_rout_dtl.last_update_date%type ,
60: last_update_login fm_rout_dtl.last_update_login%type ,
61: attribute_category fm_rout_dtl.attribute_category%type ,
62: attribute1 fm_rout_dtl.attribute1%type ,

Line 59: last_update_date fm_rout_dtl.last_update_date%type ,

55: text_code fm_rout_dtl.text_code%type ,
56: creation_date fm_rout_dtl.creation_date%type ,
57: created_by fm_rout_dtl.created_by%type ,
58: last_updated_by fm_rout_dtl.last_updated_by%type ,
59: last_update_date fm_rout_dtl.last_update_date%type ,
60: last_update_login fm_rout_dtl.last_update_login%type ,
61: attribute_category fm_rout_dtl.attribute_category%type ,
62: attribute1 fm_rout_dtl.attribute1%type ,
63: attribute2 fm_rout_dtl.attribute2%type ,

Line 60: last_update_login fm_rout_dtl.last_update_login%type ,

56: creation_date fm_rout_dtl.creation_date%type ,
57: created_by fm_rout_dtl.created_by%type ,
58: last_updated_by fm_rout_dtl.last_updated_by%type ,
59: last_update_date fm_rout_dtl.last_update_date%type ,
60: last_update_login fm_rout_dtl.last_update_login%type ,
61: attribute_category fm_rout_dtl.attribute_category%type ,
62: attribute1 fm_rout_dtl.attribute1%type ,
63: attribute2 fm_rout_dtl.attribute2%type ,
64: attribute3 fm_rout_dtl.attribute3%type ,

Line 61: attribute_category fm_rout_dtl.attribute_category%type ,

57: created_by fm_rout_dtl.created_by%type ,
58: last_updated_by fm_rout_dtl.last_updated_by%type ,
59: last_update_date fm_rout_dtl.last_update_date%type ,
60: last_update_login fm_rout_dtl.last_update_login%type ,
61: attribute_category fm_rout_dtl.attribute_category%type ,
62: attribute1 fm_rout_dtl.attribute1%type ,
63: attribute2 fm_rout_dtl.attribute2%type ,
64: attribute3 fm_rout_dtl.attribute3%type ,
65: attribute4 fm_rout_dtl.attribute4%type ,

Line 62: attribute1 fm_rout_dtl.attribute1%type ,

58: last_updated_by fm_rout_dtl.last_updated_by%type ,
59: last_update_date fm_rout_dtl.last_update_date%type ,
60: last_update_login fm_rout_dtl.last_update_login%type ,
61: attribute_category fm_rout_dtl.attribute_category%type ,
62: attribute1 fm_rout_dtl.attribute1%type ,
63: attribute2 fm_rout_dtl.attribute2%type ,
64: attribute3 fm_rout_dtl.attribute3%type ,
65: attribute4 fm_rout_dtl.attribute4%type ,
66: attribute5 fm_rout_dtl.attribute5%type ,

Line 63: attribute2 fm_rout_dtl.attribute2%type ,

59: last_update_date fm_rout_dtl.last_update_date%type ,
60: last_update_login fm_rout_dtl.last_update_login%type ,
61: attribute_category fm_rout_dtl.attribute_category%type ,
62: attribute1 fm_rout_dtl.attribute1%type ,
63: attribute2 fm_rout_dtl.attribute2%type ,
64: attribute3 fm_rout_dtl.attribute3%type ,
65: attribute4 fm_rout_dtl.attribute4%type ,
66: attribute5 fm_rout_dtl.attribute5%type ,
67: attribute6 fm_rout_dtl.attribute6%type ,

Line 64: attribute3 fm_rout_dtl.attribute3%type ,

60: last_update_login fm_rout_dtl.last_update_login%type ,
61: attribute_category fm_rout_dtl.attribute_category%type ,
62: attribute1 fm_rout_dtl.attribute1%type ,
63: attribute2 fm_rout_dtl.attribute2%type ,
64: attribute3 fm_rout_dtl.attribute3%type ,
65: attribute4 fm_rout_dtl.attribute4%type ,
66: attribute5 fm_rout_dtl.attribute5%type ,
67: attribute6 fm_rout_dtl.attribute6%type ,
68: attribute7 fm_rout_dtl.attribute7%type ,

Line 65: attribute4 fm_rout_dtl.attribute4%type ,

61: attribute_category fm_rout_dtl.attribute_category%type ,
62: attribute1 fm_rout_dtl.attribute1%type ,
63: attribute2 fm_rout_dtl.attribute2%type ,
64: attribute3 fm_rout_dtl.attribute3%type ,
65: attribute4 fm_rout_dtl.attribute4%type ,
66: attribute5 fm_rout_dtl.attribute5%type ,
67: attribute6 fm_rout_dtl.attribute6%type ,
68: attribute7 fm_rout_dtl.attribute7%type ,
69: attribute8 fm_rout_dtl.attribute8%type ,

Line 66: attribute5 fm_rout_dtl.attribute5%type ,

62: attribute1 fm_rout_dtl.attribute1%type ,
63: attribute2 fm_rout_dtl.attribute2%type ,
64: attribute3 fm_rout_dtl.attribute3%type ,
65: attribute4 fm_rout_dtl.attribute4%type ,
66: attribute5 fm_rout_dtl.attribute5%type ,
67: attribute6 fm_rout_dtl.attribute6%type ,
68: attribute7 fm_rout_dtl.attribute7%type ,
69: attribute8 fm_rout_dtl.attribute8%type ,
70: attribute9 fm_rout_dtl.attribute9%type ,

Line 67: attribute6 fm_rout_dtl.attribute6%type ,

63: attribute2 fm_rout_dtl.attribute2%type ,
64: attribute3 fm_rout_dtl.attribute3%type ,
65: attribute4 fm_rout_dtl.attribute4%type ,
66: attribute5 fm_rout_dtl.attribute5%type ,
67: attribute6 fm_rout_dtl.attribute6%type ,
68: attribute7 fm_rout_dtl.attribute7%type ,
69: attribute8 fm_rout_dtl.attribute8%type ,
70: attribute9 fm_rout_dtl.attribute9%type ,
71: attribute10 fm_rout_dtl.attribute10%type ,

Line 68: attribute7 fm_rout_dtl.attribute7%type ,

64: attribute3 fm_rout_dtl.attribute3%type ,
65: attribute4 fm_rout_dtl.attribute4%type ,
66: attribute5 fm_rout_dtl.attribute5%type ,
67: attribute6 fm_rout_dtl.attribute6%type ,
68: attribute7 fm_rout_dtl.attribute7%type ,
69: attribute8 fm_rout_dtl.attribute8%type ,
70: attribute9 fm_rout_dtl.attribute9%type ,
71: attribute10 fm_rout_dtl.attribute10%type ,
72: attribute11 fm_rout_dtl.attribute11%type ,

Line 69: attribute8 fm_rout_dtl.attribute8%type ,

65: attribute4 fm_rout_dtl.attribute4%type ,
66: attribute5 fm_rout_dtl.attribute5%type ,
67: attribute6 fm_rout_dtl.attribute6%type ,
68: attribute7 fm_rout_dtl.attribute7%type ,
69: attribute8 fm_rout_dtl.attribute8%type ,
70: attribute9 fm_rout_dtl.attribute9%type ,
71: attribute10 fm_rout_dtl.attribute10%type ,
72: attribute11 fm_rout_dtl.attribute11%type ,
73: attribute12 fm_rout_dtl.attribute12%type ,

Line 70: attribute9 fm_rout_dtl.attribute9%type ,

66: attribute5 fm_rout_dtl.attribute5%type ,
67: attribute6 fm_rout_dtl.attribute6%type ,
68: attribute7 fm_rout_dtl.attribute7%type ,
69: attribute8 fm_rout_dtl.attribute8%type ,
70: attribute9 fm_rout_dtl.attribute9%type ,
71: attribute10 fm_rout_dtl.attribute10%type ,
72: attribute11 fm_rout_dtl.attribute11%type ,
73: attribute12 fm_rout_dtl.attribute12%type ,
74: attribute13 fm_rout_dtl.attribute13%type ,

Line 71: attribute10 fm_rout_dtl.attribute10%type ,

67: attribute6 fm_rout_dtl.attribute6%type ,
68: attribute7 fm_rout_dtl.attribute7%type ,
69: attribute8 fm_rout_dtl.attribute8%type ,
70: attribute9 fm_rout_dtl.attribute9%type ,
71: attribute10 fm_rout_dtl.attribute10%type ,
72: attribute11 fm_rout_dtl.attribute11%type ,
73: attribute12 fm_rout_dtl.attribute12%type ,
74: attribute13 fm_rout_dtl.attribute13%type ,
75: attribute14 fm_rout_dtl.attribute14%type ,

Line 72: attribute11 fm_rout_dtl.attribute11%type ,

68: attribute7 fm_rout_dtl.attribute7%type ,
69: attribute8 fm_rout_dtl.attribute8%type ,
70: attribute9 fm_rout_dtl.attribute9%type ,
71: attribute10 fm_rout_dtl.attribute10%type ,
72: attribute11 fm_rout_dtl.attribute11%type ,
73: attribute12 fm_rout_dtl.attribute12%type ,
74: attribute13 fm_rout_dtl.attribute13%type ,
75: attribute14 fm_rout_dtl.attribute14%type ,
76: attribute15 fm_rout_dtl.attribute15%type ,

Line 73: attribute12 fm_rout_dtl.attribute12%type ,

69: attribute8 fm_rout_dtl.attribute8%type ,
70: attribute9 fm_rout_dtl.attribute9%type ,
71: attribute10 fm_rout_dtl.attribute10%type ,
72: attribute11 fm_rout_dtl.attribute11%type ,
73: attribute12 fm_rout_dtl.attribute12%type ,
74: attribute13 fm_rout_dtl.attribute13%type ,
75: attribute14 fm_rout_dtl.attribute14%type ,
76: attribute15 fm_rout_dtl.attribute15%type ,
77: attribute16 fm_rout_dtl.attribute16%type ,

Line 74: attribute13 fm_rout_dtl.attribute13%type ,

70: attribute9 fm_rout_dtl.attribute9%type ,
71: attribute10 fm_rout_dtl.attribute10%type ,
72: attribute11 fm_rout_dtl.attribute11%type ,
73: attribute12 fm_rout_dtl.attribute12%type ,
74: attribute13 fm_rout_dtl.attribute13%type ,
75: attribute14 fm_rout_dtl.attribute14%type ,
76: attribute15 fm_rout_dtl.attribute15%type ,
77: attribute16 fm_rout_dtl.attribute16%type ,
78: attribute17 fm_rout_dtl.attribute17%type ,

Line 75: attribute14 fm_rout_dtl.attribute14%type ,

71: attribute10 fm_rout_dtl.attribute10%type ,
72: attribute11 fm_rout_dtl.attribute11%type ,
73: attribute12 fm_rout_dtl.attribute12%type ,
74: attribute13 fm_rout_dtl.attribute13%type ,
75: attribute14 fm_rout_dtl.attribute14%type ,
76: attribute15 fm_rout_dtl.attribute15%type ,
77: attribute16 fm_rout_dtl.attribute16%type ,
78: attribute17 fm_rout_dtl.attribute17%type ,
79: attribute18 fm_rout_dtl.attribute18%type ,

Line 76: attribute15 fm_rout_dtl.attribute15%type ,

72: attribute11 fm_rout_dtl.attribute11%type ,
73: attribute12 fm_rout_dtl.attribute12%type ,
74: attribute13 fm_rout_dtl.attribute13%type ,
75: attribute14 fm_rout_dtl.attribute14%type ,
76: attribute15 fm_rout_dtl.attribute15%type ,
77: attribute16 fm_rout_dtl.attribute16%type ,
78: attribute17 fm_rout_dtl.attribute17%type ,
79: attribute18 fm_rout_dtl.attribute18%type ,
80: attribute19 fm_rout_dtl.attribute19%type ,

Line 77: attribute16 fm_rout_dtl.attribute16%type ,

73: attribute12 fm_rout_dtl.attribute12%type ,
74: attribute13 fm_rout_dtl.attribute13%type ,
75: attribute14 fm_rout_dtl.attribute14%type ,
76: attribute15 fm_rout_dtl.attribute15%type ,
77: attribute16 fm_rout_dtl.attribute16%type ,
78: attribute17 fm_rout_dtl.attribute17%type ,
79: attribute18 fm_rout_dtl.attribute18%type ,
80: attribute19 fm_rout_dtl.attribute19%type ,
81: attribute20 fm_rout_dtl.attribute20%type ,

Line 78: attribute17 fm_rout_dtl.attribute17%type ,

74: attribute13 fm_rout_dtl.attribute13%type ,
75: attribute14 fm_rout_dtl.attribute14%type ,
76: attribute15 fm_rout_dtl.attribute15%type ,
77: attribute16 fm_rout_dtl.attribute16%type ,
78: attribute17 fm_rout_dtl.attribute17%type ,
79: attribute18 fm_rout_dtl.attribute18%type ,
80: attribute19 fm_rout_dtl.attribute19%type ,
81: attribute20 fm_rout_dtl.attribute20%type ,
82: attribute21 fm_rout_dtl.attribute21%type ,

Line 79: attribute18 fm_rout_dtl.attribute18%type ,

75: attribute14 fm_rout_dtl.attribute14%type ,
76: attribute15 fm_rout_dtl.attribute15%type ,
77: attribute16 fm_rout_dtl.attribute16%type ,
78: attribute17 fm_rout_dtl.attribute17%type ,
79: attribute18 fm_rout_dtl.attribute18%type ,
80: attribute19 fm_rout_dtl.attribute19%type ,
81: attribute20 fm_rout_dtl.attribute20%type ,
82: attribute21 fm_rout_dtl.attribute21%type ,
83: attribute22 fm_rout_dtl.attribute22%type ,

Line 80: attribute19 fm_rout_dtl.attribute19%type ,

76: attribute15 fm_rout_dtl.attribute15%type ,
77: attribute16 fm_rout_dtl.attribute16%type ,
78: attribute17 fm_rout_dtl.attribute17%type ,
79: attribute18 fm_rout_dtl.attribute18%type ,
80: attribute19 fm_rout_dtl.attribute19%type ,
81: attribute20 fm_rout_dtl.attribute20%type ,
82: attribute21 fm_rout_dtl.attribute21%type ,
83: attribute22 fm_rout_dtl.attribute22%type ,
84: attribute23 fm_rout_dtl.attribute23%type ,

Line 81: attribute20 fm_rout_dtl.attribute20%type ,

77: attribute16 fm_rout_dtl.attribute16%type ,
78: attribute17 fm_rout_dtl.attribute17%type ,
79: attribute18 fm_rout_dtl.attribute18%type ,
80: attribute19 fm_rout_dtl.attribute19%type ,
81: attribute20 fm_rout_dtl.attribute20%type ,
82: attribute21 fm_rout_dtl.attribute21%type ,
83: attribute22 fm_rout_dtl.attribute22%type ,
84: attribute23 fm_rout_dtl.attribute23%type ,
85: attribute24 fm_rout_dtl.attribute24%type ,

Line 82: attribute21 fm_rout_dtl.attribute21%type ,

78: attribute17 fm_rout_dtl.attribute17%type ,
79: attribute18 fm_rout_dtl.attribute18%type ,
80: attribute19 fm_rout_dtl.attribute19%type ,
81: attribute20 fm_rout_dtl.attribute20%type ,
82: attribute21 fm_rout_dtl.attribute21%type ,
83: attribute22 fm_rout_dtl.attribute22%type ,
84: attribute23 fm_rout_dtl.attribute23%type ,
85: attribute24 fm_rout_dtl.attribute24%type ,
86: attribute25 fm_rout_dtl.attribute25%type ,

Line 83: attribute22 fm_rout_dtl.attribute22%type ,

79: attribute18 fm_rout_dtl.attribute18%type ,
80: attribute19 fm_rout_dtl.attribute19%type ,
81: attribute20 fm_rout_dtl.attribute20%type ,
82: attribute21 fm_rout_dtl.attribute21%type ,
83: attribute22 fm_rout_dtl.attribute22%type ,
84: attribute23 fm_rout_dtl.attribute23%type ,
85: attribute24 fm_rout_dtl.attribute24%type ,
86: attribute25 fm_rout_dtl.attribute25%type ,
87: attribute26 fm_rout_dtl.attribute26%type ,

Line 84: attribute23 fm_rout_dtl.attribute23%type ,

80: attribute19 fm_rout_dtl.attribute19%type ,
81: attribute20 fm_rout_dtl.attribute20%type ,
82: attribute21 fm_rout_dtl.attribute21%type ,
83: attribute22 fm_rout_dtl.attribute22%type ,
84: attribute23 fm_rout_dtl.attribute23%type ,
85: attribute24 fm_rout_dtl.attribute24%type ,
86: attribute25 fm_rout_dtl.attribute25%type ,
87: attribute26 fm_rout_dtl.attribute26%type ,
88: attribute27 fm_rout_dtl.attribute27%type ,

Line 85: attribute24 fm_rout_dtl.attribute24%type ,

81: attribute20 fm_rout_dtl.attribute20%type ,
82: attribute21 fm_rout_dtl.attribute21%type ,
83: attribute22 fm_rout_dtl.attribute22%type ,
84: attribute23 fm_rout_dtl.attribute23%type ,
85: attribute24 fm_rout_dtl.attribute24%type ,
86: attribute25 fm_rout_dtl.attribute25%type ,
87: attribute26 fm_rout_dtl.attribute26%type ,
88: attribute27 fm_rout_dtl.attribute27%type ,
89: attribute28 fm_rout_dtl.attribute28%type ,

Line 86: attribute25 fm_rout_dtl.attribute25%type ,

82: attribute21 fm_rout_dtl.attribute21%type ,
83: attribute22 fm_rout_dtl.attribute22%type ,
84: attribute23 fm_rout_dtl.attribute23%type ,
85: attribute24 fm_rout_dtl.attribute24%type ,
86: attribute25 fm_rout_dtl.attribute25%type ,
87: attribute26 fm_rout_dtl.attribute26%type ,
88: attribute27 fm_rout_dtl.attribute27%type ,
89: attribute28 fm_rout_dtl.attribute28%type ,
90: attribute29 fm_rout_dtl.attribute29%type ,

Line 87: attribute26 fm_rout_dtl.attribute26%type ,

83: attribute22 fm_rout_dtl.attribute22%type ,
84: attribute23 fm_rout_dtl.attribute23%type ,
85: attribute24 fm_rout_dtl.attribute24%type ,
86: attribute25 fm_rout_dtl.attribute25%type ,
87: attribute26 fm_rout_dtl.attribute26%type ,
88: attribute27 fm_rout_dtl.attribute27%type ,
89: attribute28 fm_rout_dtl.attribute28%type ,
90: attribute29 fm_rout_dtl.attribute29%type ,
91: attribute30 fm_rout_dtl.attribute30%type ,

Line 88: attribute27 fm_rout_dtl.attribute27%type ,

84: attribute23 fm_rout_dtl.attribute23%type ,
85: attribute24 fm_rout_dtl.attribute24%type ,
86: attribute25 fm_rout_dtl.attribute25%type ,
87: attribute26 fm_rout_dtl.attribute26%type ,
88: attribute27 fm_rout_dtl.attribute27%type ,
89: attribute28 fm_rout_dtl.attribute28%type ,
90: attribute29 fm_rout_dtl.attribute29%type ,
91: attribute30 fm_rout_dtl.attribute30%type ,
92: /* Bug 3612365 Thomas Daniel */

Line 89: attribute28 fm_rout_dtl.attribute28%type ,

85: attribute24 fm_rout_dtl.attribute24%type ,
86: attribute25 fm_rout_dtl.attribute25%type ,
87: attribute26 fm_rout_dtl.attribute26%type ,
88: attribute27 fm_rout_dtl.attribute27%type ,
89: attribute28 fm_rout_dtl.attribute28%type ,
90: attribute29 fm_rout_dtl.attribute29%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 */

Line 90: attribute29 fm_rout_dtl.attribute29%type ,

86: attribute25 fm_rout_dtl.attribute25%type ,
87: attribute26 fm_rout_dtl.attribute26%type ,
88: attribute27 fm_rout_dtl.attribute27%type ,
89: attribute28 fm_rout_dtl.attribute28%type ,
90: attribute29 fm_rout_dtl.attribute29%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 */

Line 91: attribute30 fm_rout_dtl.attribute30%type ,

87: attribute26 fm_rout_dtl.attribute26%type ,
88: attribute27 fm_rout_dtl.attribute27%type ,
89: attribute28 fm_rout_dtl.attribute28%type ,
90: attribute29 fm_rout_dtl.attribute29%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

Line 104: routing_id fm_rout_dtl.routing_id%type ,

100: /* Bug 2560037 S.Dulyk 20-SEP-2002 Added minimum_transfer_qty */
101: TYPE routing_step_out IS RECORD
102:
103: (
104: routing_id fm_rout_dtl.routing_id%type ,
105: routingstep_no fm_rout_dtl.routingstep_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 ,

Line 105: routingstep_no fm_rout_dtl.routingstep_no%type ,

101: TYPE routing_step_out IS RECORD
102:
103: (
104: routing_id fm_rout_dtl.routing_id%type ,
105: routingstep_no fm_rout_dtl.routingstep_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 ,

Line 106: routingstep_id fm_rout_dtl.routingstep_id%type ,

102:
103: (
104: routing_id fm_rout_dtl.routing_id%type ,
105: routingstep_no fm_rout_dtl.routingstep_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 ,

Line 107: step_qty fm_rout_dtl.step_qty%type ,

103: (
104: routing_id fm_rout_dtl.routing_id%type ,
105: routingstep_no fm_rout_dtl.routingstep_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 ,

Line 108: steprelease_type fm_rout_dtl.steprelease_type%type ,

104: routing_id fm_rout_dtl.routing_id%type ,
105: routingstep_no fm_rout_dtl.routingstep_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 ,

Line 109: oprn_id fm_rout_dtl.oprn_id%type ,

105: routingstep_no fm_rout_dtl.routingstep_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 ,

Line 114: minimum_transfer_qty fm_rout_dtl.minimum_transfer_qty%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 ,
118: creation_date fm_rout_dtl.creation_date%type ,

Line 117: text_code fm_rout_dtl.text_code%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 ,
118: creation_date fm_rout_dtl.creation_date%type ,
119: created_by fm_rout_dtl.created_by%type ,
120: last_updated_by fm_rout_dtl.last_updated_by%type ,
121: last_update_date fm_rout_dtl.last_update_date%type ,

Line 118: creation_date fm_rout_dtl.creation_date%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 ,
118: creation_date fm_rout_dtl.creation_date%type ,
119: created_by fm_rout_dtl.created_by%type ,
120: last_updated_by fm_rout_dtl.last_updated_by%type ,
121: last_update_date fm_rout_dtl.last_update_date%type ,
122: last_update_login fm_rout_dtl.last_update_login%type ,

Line 119: created_by fm_rout_dtl.created_by%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 ,
118: creation_date fm_rout_dtl.creation_date%type ,
119: created_by fm_rout_dtl.created_by%type ,
120: last_updated_by fm_rout_dtl.last_updated_by%type ,
121: last_update_date fm_rout_dtl.last_update_date%type ,
122: last_update_login fm_rout_dtl.last_update_login%type ,
123: attribute_category fm_rout_dtl.attribute_category%type ,

Line 120: last_updated_by fm_rout_dtl.last_updated_by%type ,

116: capacity_uom cr_rsrc_dtl.capacity_um%type ,
117: text_code fm_rout_dtl.text_code%type ,
118: creation_date fm_rout_dtl.creation_date%type ,
119: created_by fm_rout_dtl.created_by%type ,
120: last_updated_by fm_rout_dtl.last_updated_by%type ,
121: last_update_date fm_rout_dtl.last_update_date%type ,
122: last_update_login fm_rout_dtl.last_update_login%type ,
123: attribute_category fm_rout_dtl.attribute_category%type ,
124: attribute1 fm_rout_dtl.attribute1%type ,

Line 121: last_update_date fm_rout_dtl.last_update_date%type ,

117: text_code fm_rout_dtl.text_code%type ,
118: creation_date fm_rout_dtl.creation_date%type ,
119: created_by fm_rout_dtl.created_by%type ,
120: last_updated_by fm_rout_dtl.last_updated_by%type ,
121: last_update_date fm_rout_dtl.last_update_date%type ,
122: last_update_login fm_rout_dtl.last_update_login%type ,
123: attribute_category fm_rout_dtl.attribute_category%type ,
124: attribute1 fm_rout_dtl.attribute1%type ,
125: attribute2 fm_rout_dtl.attribute2%type ,

Line 122: last_update_login fm_rout_dtl.last_update_login%type ,

118: creation_date fm_rout_dtl.creation_date%type ,
119: created_by fm_rout_dtl.created_by%type ,
120: last_updated_by fm_rout_dtl.last_updated_by%type ,
121: last_update_date fm_rout_dtl.last_update_date%type ,
122: last_update_login fm_rout_dtl.last_update_login%type ,
123: attribute_category fm_rout_dtl.attribute_category%type ,
124: attribute1 fm_rout_dtl.attribute1%type ,
125: attribute2 fm_rout_dtl.attribute2%type ,
126: attribute3 fm_rout_dtl.attribute3%type ,

Line 123: attribute_category fm_rout_dtl.attribute_category%type ,

119: created_by fm_rout_dtl.created_by%type ,
120: last_updated_by fm_rout_dtl.last_updated_by%type ,
121: last_update_date fm_rout_dtl.last_update_date%type ,
122: last_update_login fm_rout_dtl.last_update_login%type ,
123: attribute_category fm_rout_dtl.attribute_category%type ,
124: attribute1 fm_rout_dtl.attribute1%type ,
125: attribute2 fm_rout_dtl.attribute2%type ,
126: attribute3 fm_rout_dtl.attribute3%type ,
127: attribute4 fm_rout_dtl.attribute4%type ,

Line 124: attribute1 fm_rout_dtl.attribute1%type ,

120: last_updated_by fm_rout_dtl.last_updated_by%type ,
121: last_update_date fm_rout_dtl.last_update_date%type ,
122: last_update_login fm_rout_dtl.last_update_login%type ,
123: attribute_category fm_rout_dtl.attribute_category%type ,
124: attribute1 fm_rout_dtl.attribute1%type ,
125: attribute2 fm_rout_dtl.attribute2%type ,
126: attribute3 fm_rout_dtl.attribute3%type ,
127: attribute4 fm_rout_dtl.attribute4%type ,
128: attribute5 fm_rout_dtl.attribute5%type ,

Line 125: attribute2 fm_rout_dtl.attribute2%type ,

121: last_update_date fm_rout_dtl.last_update_date%type ,
122: last_update_login fm_rout_dtl.last_update_login%type ,
123: attribute_category fm_rout_dtl.attribute_category%type ,
124: attribute1 fm_rout_dtl.attribute1%type ,
125: attribute2 fm_rout_dtl.attribute2%type ,
126: attribute3 fm_rout_dtl.attribute3%type ,
127: attribute4 fm_rout_dtl.attribute4%type ,
128: attribute5 fm_rout_dtl.attribute5%type ,
129: attribute6 fm_rout_dtl.attribute6%type ,

Line 126: attribute3 fm_rout_dtl.attribute3%type ,

122: last_update_login fm_rout_dtl.last_update_login%type ,
123: attribute_category fm_rout_dtl.attribute_category%type ,
124: attribute1 fm_rout_dtl.attribute1%type ,
125: attribute2 fm_rout_dtl.attribute2%type ,
126: attribute3 fm_rout_dtl.attribute3%type ,
127: attribute4 fm_rout_dtl.attribute4%type ,
128: attribute5 fm_rout_dtl.attribute5%type ,
129: attribute6 fm_rout_dtl.attribute6%type ,
130: attribute7 fm_rout_dtl.attribute7%type ,

Line 127: attribute4 fm_rout_dtl.attribute4%type ,

123: attribute_category fm_rout_dtl.attribute_category%type ,
124: attribute1 fm_rout_dtl.attribute1%type ,
125: attribute2 fm_rout_dtl.attribute2%type ,
126: attribute3 fm_rout_dtl.attribute3%type ,
127: attribute4 fm_rout_dtl.attribute4%type ,
128: attribute5 fm_rout_dtl.attribute5%type ,
129: attribute6 fm_rout_dtl.attribute6%type ,
130: attribute7 fm_rout_dtl.attribute7%type ,
131: attribute8 fm_rout_dtl.attribute8%type ,

Line 128: attribute5 fm_rout_dtl.attribute5%type ,

124: attribute1 fm_rout_dtl.attribute1%type ,
125: attribute2 fm_rout_dtl.attribute2%type ,
126: attribute3 fm_rout_dtl.attribute3%type ,
127: attribute4 fm_rout_dtl.attribute4%type ,
128: attribute5 fm_rout_dtl.attribute5%type ,
129: attribute6 fm_rout_dtl.attribute6%type ,
130: attribute7 fm_rout_dtl.attribute7%type ,
131: attribute8 fm_rout_dtl.attribute8%type ,
132: attribute9 fm_rout_dtl.attribute9%type ,

Line 129: attribute6 fm_rout_dtl.attribute6%type ,

125: attribute2 fm_rout_dtl.attribute2%type ,
126: attribute3 fm_rout_dtl.attribute3%type ,
127: attribute4 fm_rout_dtl.attribute4%type ,
128: attribute5 fm_rout_dtl.attribute5%type ,
129: attribute6 fm_rout_dtl.attribute6%type ,
130: attribute7 fm_rout_dtl.attribute7%type ,
131: attribute8 fm_rout_dtl.attribute8%type ,
132: attribute9 fm_rout_dtl.attribute9%type ,
133: attribute10 fm_rout_dtl.attribute10%type ,

Line 130: attribute7 fm_rout_dtl.attribute7%type ,

126: attribute3 fm_rout_dtl.attribute3%type ,
127: attribute4 fm_rout_dtl.attribute4%type ,
128: attribute5 fm_rout_dtl.attribute5%type ,
129: attribute6 fm_rout_dtl.attribute6%type ,
130: attribute7 fm_rout_dtl.attribute7%type ,
131: attribute8 fm_rout_dtl.attribute8%type ,
132: attribute9 fm_rout_dtl.attribute9%type ,
133: attribute10 fm_rout_dtl.attribute10%type ,
134: attribute11 fm_rout_dtl.attribute11%type ,

Line 131: attribute8 fm_rout_dtl.attribute8%type ,

127: attribute4 fm_rout_dtl.attribute4%type ,
128: attribute5 fm_rout_dtl.attribute5%type ,
129: attribute6 fm_rout_dtl.attribute6%type ,
130: attribute7 fm_rout_dtl.attribute7%type ,
131: attribute8 fm_rout_dtl.attribute8%type ,
132: attribute9 fm_rout_dtl.attribute9%type ,
133: attribute10 fm_rout_dtl.attribute10%type ,
134: attribute11 fm_rout_dtl.attribute11%type ,
135: attribute12 fm_rout_dtl.attribute12%type ,

Line 132: attribute9 fm_rout_dtl.attribute9%type ,

128: attribute5 fm_rout_dtl.attribute5%type ,
129: attribute6 fm_rout_dtl.attribute6%type ,
130: attribute7 fm_rout_dtl.attribute7%type ,
131: attribute8 fm_rout_dtl.attribute8%type ,
132: attribute9 fm_rout_dtl.attribute9%type ,
133: attribute10 fm_rout_dtl.attribute10%type ,
134: attribute11 fm_rout_dtl.attribute11%type ,
135: attribute12 fm_rout_dtl.attribute12%type ,
136: attribute13 fm_rout_dtl.attribute13%type ,

Line 133: attribute10 fm_rout_dtl.attribute10%type ,

129: attribute6 fm_rout_dtl.attribute6%type ,
130: attribute7 fm_rout_dtl.attribute7%type ,
131: attribute8 fm_rout_dtl.attribute8%type ,
132: attribute9 fm_rout_dtl.attribute9%type ,
133: attribute10 fm_rout_dtl.attribute10%type ,
134: attribute11 fm_rout_dtl.attribute11%type ,
135: attribute12 fm_rout_dtl.attribute12%type ,
136: attribute13 fm_rout_dtl.attribute13%type ,
137: attribute14 fm_rout_dtl.attribute14%type ,

Line 134: attribute11 fm_rout_dtl.attribute11%type ,

130: attribute7 fm_rout_dtl.attribute7%type ,
131: attribute8 fm_rout_dtl.attribute8%type ,
132: attribute9 fm_rout_dtl.attribute9%type ,
133: attribute10 fm_rout_dtl.attribute10%type ,
134: attribute11 fm_rout_dtl.attribute11%type ,
135: attribute12 fm_rout_dtl.attribute12%type ,
136: attribute13 fm_rout_dtl.attribute13%type ,
137: attribute14 fm_rout_dtl.attribute14%type ,
138: attribute15 fm_rout_dtl.attribute15%type ,

Line 135: attribute12 fm_rout_dtl.attribute12%type ,

131: attribute8 fm_rout_dtl.attribute8%type ,
132: attribute9 fm_rout_dtl.attribute9%type ,
133: attribute10 fm_rout_dtl.attribute10%type ,
134: attribute11 fm_rout_dtl.attribute11%type ,
135: attribute12 fm_rout_dtl.attribute12%type ,
136: attribute13 fm_rout_dtl.attribute13%type ,
137: attribute14 fm_rout_dtl.attribute14%type ,
138: attribute15 fm_rout_dtl.attribute15%type ,
139: attribute16 fm_rout_dtl.attribute16%type ,

Line 136: attribute13 fm_rout_dtl.attribute13%type ,

132: attribute9 fm_rout_dtl.attribute9%type ,
133: attribute10 fm_rout_dtl.attribute10%type ,
134: attribute11 fm_rout_dtl.attribute11%type ,
135: attribute12 fm_rout_dtl.attribute12%type ,
136: attribute13 fm_rout_dtl.attribute13%type ,
137: attribute14 fm_rout_dtl.attribute14%type ,
138: attribute15 fm_rout_dtl.attribute15%type ,
139: attribute16 fm_rout_dtl.attribute16%type ,
140: attribute17 fm_rout_dtl.attribute17%type ,

Line 137: attribute14 fm_rout_dtl.attribute14%type ,

133: attribute10 fm_rout_dtl.attribute10%type ,
134: attribute11 fm_rout_dtl.attribute11%type ,
135: attribute12 fm_rout_dtl.attribute12%type ,
136: attribute13 fm_rout_dtl.attribute13%type ,
137: attribute14 fm_rout_dtl.attribute14%type ,
138: attribute15 fm_rout_dtl.attribute15%type ,
139: attribute16 fm_rout_dtl.attribute16%type ,
140: attribute17 fm_rout_dtl.attribute17%type ,
141: attribute18 fm_rout_dtl.attribute18%type ,

Line 138: attribute15 fm_rout_dtl.attribute15%type ,

134: attribute11 fm_rout_dtl.attribute11%type ,
135: attribute12 fm_rout_dtl.attribute12%type ,
136: attribute13 fm_rout_dtl.attribute13%type ,
137: attribute14 fm_rout_dtl.attribute14%type ,
138: attribute15 fm_rout_dtl.attribute15%type ,
139: attribute16 fm_rout_dtl.attribute16%type ,
140: attribute17 fm_rout_dtl.attribute17%type ,
141: attribute18 fm_rout_dtl.attribute18%type ,
142: attribute19 fm_rout_dtl.attribute19%type ,

Line 139: attribute16 fm_rout_dtl.attribute16%type ,

135: attribute12 fm_rout_dtl.attribute12%type ,
136: attribute13 fm_rout_dtl.attribute13%type ,
137: attribute14 fm_rout_dtl.attribute14%type ,
138: attribute15 fm_rout_dtl.attribute15%type ,
139: attribute16 fm_rout_dtl.attribute16%type ,
140: attribute17 fm_rout_dtl.attribute17%type ,
141: attribute18 fm_rout_dtl.attribute18%type ,
142: attribute19 fm_rout_dtl.attribute19%type ,
143: attribute20 fm_rout_dtl.attribute20%type ,

Line 140: attribute17 fm_rout_dtl.attribute17%type ,

136: attribute13 fm_rout_dtl.attribute13%type ,
137: attribute14 fm_rout_dtl.attribute14%type ,
138: attribute15 fm_rout_dtl.attribute15%type ,
139: attribute16 fm_rout_dtl.attribute16%type ,
140: attribute17 fm_rout_dtl.attribute17%type ,
141: attribute18 fm_rout_dtl.attribute18%type ,
142: attribute19 fm_rout_dtl.attribute19%type ,
143: attribute20 fm_rout_dtl.attribute20%type ,
144: attribute21 fm_rout_dtl.attribute21%type ,

Line 141: attribute18 fm_rout_dtl.attribute18%type ,

137: attribute14 fm_rout_dtl.attribute14%type ,
138: attribute15 fm_rout_dtl.attribute15%type ,
139: attribute16 fm_rout_dtl.attribute16%type ,
140: attribute17 fm_rout_dtl.attribute17%type ,
141: attribute18 fm_rout_dtl.attribute18%type ,
142: attribute19 fm_rout_dtl.attribute19%type ,
143: attribute20 fm_rout_dtl.attribute20%type ,
144: attribute21 fm_rout_dtl.attribute21%type ,
145: attribute22 fm_rout_dtl.attribute22%type ,

Line 142: attribute19 fm_rout_dtl.attribute19%type ,

138: attribute15 fm_rout_dtl.attribute15%type ,
139: attribute16 fm_rout_dtl.attribute16%type ,
140: attribute17 fm_rout_dtl.attribute17%type ,
141: attribute18 fm_rout_dtl.attribute18%type ,
142: attribute19 fm_rout_dtl.attribute19%type ,
143: attribute20 fm_rout_dtl.attribute20%type ,
144: attribute21 fm_rout_dtl.attribute21%type ,
145: attribute22 fm_rout_dtl.attribute22%type ,
146: attribute23 fm_rout_dtl.attribute23%type ,

Line 143: attribute20 fm_rout_dtl.attribute20%type ,

139: attribute16 fm_rout_dtl.attribute16%type ,
140: attribute17 fm_rout_dtl.attribute17%type ,
141: attribute18 fm_rout_dtl.attribute18%type ,
142: attribute19 fm_rout_dtl.attribute19%type ,
143: attribute20 fm_rout_dtl.attribute20%type ,
144: attribute21 fm_rout_dtl.attribute21%type ,
145: attribute22 fm_rout_dtl.attribute22%type ,
146: attribute23 fm_rout_dtl.attribute23%type ,
147: attribute24 fm_rout_dtl.attribute24%type ,

Line 144: attribute21 fm_rout_dtl.attribute21%type ,

140: attribute17 fm_rout_dtl.attribute17%type ,
141: attribute18 fm_rout_dtl.attribute18%type ,
142: attribute19 fm_rout_dtl.attribute19%type ,
143: attribute20 fm_rout_dtl.attribute20%type ,
144: attribute21 fm_rout_dtl.attribute21%type ,
145: attribute22 fm_rout_dtl.attribute22%type ,
146: attribute23 fm_rout_dtl.attribute23%type ,
147: attribute24 fm_rout_dtl.attribute24%type ,
148: attribute25 fm_rout_dtl.attribute25%type ,

Line 145: attribute22 fm_rout_dtl.attribute22%type ,

141: attribute18 fm_rout_dtl.attribute18%type ,
142: attribute19 fm_rout_dtl.attribute19%type ,
143: attribute20 fm_rout_dtl.attribute20%type ,
144: attribute21 fm_rout_dtl.attribute21%type ,
145: attribute22 fm_rout_dtl.attribute22%type ,
146: attribute23 fm_rout_dtl.attribute23%type ,
147: attribute24 fm_rout_dtl.attribute24%type ,
148: attribute25 fm_rout_dtl.attribute25%type ,
149: attribute26 fm_rout_dtl.attribute26%type ,

Line 146: attribute23 fm_rout_dtl.attribute23%type ,

142: attribute19 fm_rout_dtl.attribute19%type ,
143: attribute20 fm_rout_dtl.attribute20%type ,
144: attribute21 fm_rout_dtl.attribute21%type ,
145: attribute22 fm_rout_dtl.attribute22%type ,
146: attribute23 fm_rout_dtl.attribute23%type ,
147: attribute24 fm_rout_dtl.attribute24%type ,
148: attribute25 fm_rout_dtl.attribute25%type ,
149: attribute26 fm_rout_dtl.attribute26%type ,
150: attribute27 fm_rout_dtl.attribute27%type ,

Line 147: attribute24 fm_rout_dtl.attribute24%type ,

143: attribute20 fm_rout_dtl.attribute20%type ,
144: attribute21 fm_rout_dtl.attribute21%type ,
145: attribute22 fm_rout_dtl.attribute22%type ,
146: attribute23 fm_rout_dtl.attribute23%type ,
147: attribute24 fm_rout_dtl.attribute24%type ,
148: attribute25 fm_rout_dtl.attribute25%type ,
149: attribute26 fm_rout_dtl.attribute26%type ,
150: attribute27 fm_rout_dtl.attribute27%type ,
151: attribute28 fm_rout_dtl.attribute28%type ,

Line 148: attribute25 fm_rout_dtl.attribute25%type ,

144: attribute21 fm_rout_dtl.attribute21%type ,
145: attribute22 fm_rout_dtl.attribute22%type ,
146: attribute23 fm_rout_dtl.attribute23%type ,
147: attribute24 fm_rout_dtl.attribute24%type ,
148: attribute25 fm_rout_dtl.attribute25%type ,
149: attribute26 fm_rout_dtl.attribute26%type ,
150: attribute27 fm_rout_dtl.attribute27%type ,
151: attribute28 fm_rout_dtl.attribute28%type ,
152: attribute29 fm_rout_dtl.attribute29%type ,

Line 149: attribute26 fm_rout_dtl.attribute26%type ,

145: attribute22 fm_rout_dtl.attribute22%type ,
146: attribute23 fm_rout_dtl.attribute23%type ,
147: attribute24 fm_rout_dtl.attribute24%type ,
148: attribute25 fm_rout_dtl.attribute25%type ,
149: attribute26 fm_rout_dtl.attribute26%type ,
150: attribute27 fm_rout_dtl.attribute27%type ,
151: attribute28 fm_rout_dtl.attribute28%type ,
152: attribute29 fm_rout_dtl.attribute29%type ,
153: attribute30 fm_rout_dtl.attribute30%type

Line 150: attribute27 fm_rout_dtl.attribute27%type ,

146: attribute23 fm_rout_dtl.attribute23%type ,
147: attribute24 fm_rout_dtl.attribute24%type ,
148: attribute25 fm_rout_dtl.attribute25%type ,
149: attribute26 fm_rout_dtl.attribute26%type ,
150: attribute27 fm_rout_dtl.attribute27%type ,
151: attribute28 fm_rout_dtl.attribute28%type ,
152: attribute29 fm_rout_dtl.attribute29%type ,
153: attribute30 fm_rout_dtl.attribute30%type
154: );

Line 151: attribute28 fm_rout_dtl.attribute28%type ,

147: attribute24 fm_rout_dtl.attribute24%type ,
148: attribute25 fm_rout_dtl.attribute25%type ,
149: attribute26 fm_rout_dtl.attribute26%type ,
150: attribute27 fm_rout_dtl.attribute27%type ,
151: attribute28 fm_rout_dtl.attribute28%type ,
152: attribute29 fm_rout_dtl.attribute29%type ,
153: attribute30 fm_rout_dtl.attribute30%type
154: );
155:

Line 152: attribute29 fm_rout_dtl.attribute29%type ,

148: attribute25 fm_rout_dtl.attribute25%type ,
149: attribute26 fm_rout_dtl.attribute26%type ,
150: attribute27 fm_rout_dtl.attribute27%type ,
151: attribute28 fm_rout_dtl.attribute28%type ,
152: attribute29 fm_rout_dtl.attribute29%type ,
153: attribute30 fm_rout_dtl.attribute30%type
154: );
155:
156: TYPE routing_step_tbl IS TABLE OF routing_step_out

Line 153: attribute30 fm_rout_dtl.attribute30%type

149: attribute26 fm_rout_dtl.attribute26%type ,
150: attribute27 fm_rout_dtl.attribute27%type ,
151: attribute28 fm_rout_dtl.attribute28%type ,
152: attribute29 fm_rout_dtl.attribute29%type ,
153: attribute30 fm_rout_dtl.attribute30%type
154: );
155:
156: TYPE routing_step_tbl IS TABLE OF routing_step_out
157: INDEX BY BINARY_INTEGER;

Line 161: routingstep_id fm_rout_dtl.routingstep_id%type ,

157: INDEX BY BINARY_INTEGER;
158:
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 ,

Line 162: routingstep_no fm_rout_dtl.routingstep_no%type ,

158:
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 ,

Line 230: routingstep_id fm_rout_dtl.routingstep_id%type ,

226:
227: TYPE oprn_resc_rec IS RECORD
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 ,

Line 231: routingstep_no fm_rout_dtl.routingstep_no%type ,

227: TYPE oprn_resc_rec IS RECORD
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 ,

Line 312: routingstep_id fm_rout_dtl.routingstep_id%type ,

308:
309: TYPE recp_resc_proc_param_rec IS RECORD
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 ,

Line 313: routingstep_no fm_rout_dtl.routingstep_no%type ,

309: TYPE recp_resc_proc_param_rec IS RECORD
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 ,