eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WSM_LOTATTR_PVT dependencies on MTL_LOT_NUMBERS

Line 16: FROM mtl_lot_numbers

12: BEGIN
13: x_err_code:=0;
14: SELECT 'Y'
15: INTO x_lot_exists
16: FROM mtl_lot_numbers
17: WHERE organization_id = p_org_id
18: AND inventory_item_id = p_inventory_item_id
19: AND lot_number = p_lot_number;
20:

Line 64: x_context_code MTL_LOT_NUMBERS.LOT_ATTRIBUTE_CATEGORY%TYPE:=NULL;

60: p_src_lot_number IN VARCHAR2 DEFAULT NULL,
61: p_src_inv_item_id IN NUMBER DEFAULT NULL) is
62:
63: l_wms_installed BOOLEAN:=FALSE;
64: x_context_code MTL_LOT_NUMBERS.LOT_ATTRIBUTE_CATEGORY%TYPE:=NULL;
65: x_src_context_code MTL_LOT_NUMBERS.LOT_ATTRIBUTE_CATEGORY%TYPE:=NULL;
66: l_copy_from_src BOOLEAN:=FALSE;
67: l_intf_rec_found BOOLEAN:=FALSE;
68: l_inv_attr_required BOOLEAN:=FALSE;

Line 65: x_src_context_code MTL_LOT_NUMBERS.LOT_ATTRIBUTE_CATEGORY%TYPE:=NULL;

61: p_src_inv_item_id IN NUMBER DEFAULT NULL) is
62:
63: l_wms_installed BOOLEAN:=FALSE;
64: x_context_code MTL_LOT_NUMBERS.LOT_ATTRIBUTE_CATEGORY%TYPE:=NULL;
65: x_src_context_code MTL_LOT_NUMBERS.LOT_ATTRIBUTE_CATEGORY%TYPE:=NULL;
66: l_copy_from_src BOOLEAN:=FALSE;
67: l_intf_rec_found BOOLEAN:=FALSE;
68: l_inv_attr_required BOOLEAN:=FALSE;
69: l_wms_attr_required BOOLEAN:=FALSE;

Line 74: l_description mtl_lot_numbers.description%TYPE:=NULL;

70: l_call_inv_lotapi BOOLEAN:=FALSE;
71:
72: l_lot_attribute_category varchar2(30):=NULL;
73: l_attribute_category varchar2(30):=NULL;
74: l_description mtl_lot_numbers.description%TYPE:=NULL;
75: l_invattr_tbl inv_lot_api_pub.char_tbl;
76: l_Cattr_tbl inv_lot_api_pub.char_tbl;
77: l_Nattr_tbl inv_lot_api_pub.number_tbl;
78: l_Dattr_tbl inv_lot_api_pub.date_tbl;

Line 80: l_grade_code mtl_lot_numbers.grade_code%TYPE:=NULL;

76: l_Cattr_tbl inv_lot_api_pub.char_tbl;
77: l_Nattr_tbl inv_lot_api_pub.number_tbl;
78: l_Dattr_tbl inv_lot_api_pub.date_tbl;
79:
80: l_grade_code mtl_lot_numbers.grade_code%TYPE:=NULL;
81: l_origination_date DATE:=NULL;
82: l_date_code mtl_lot_numbers.date_code%TYPE:=NULL;
83: l_change_date DATE:=NULL;
84: l_age NUMBER:=NULL;

Line 82: l_date_code mtl_lot_numbers.date_code%TYPE:=NULL;

78: l_Dattr_tbl inv_lot_api_pub.date_tbl;
79:
80: l_grade_code mtl_lot_numbers.grade_code%TYPE:=NULL;
81: l_origination_date DATE:=NULL;
82: l_date_code mtl_lot_numbers.date_code%TYPE:=NULL;
83: l_change_date DATE:=NULL;
84: l_age NUMBER:=NULL;
85: l_retest_date DATE:=NULL;
86: l_maturity_date DATE:=NULL;

Line 88: l_color mtl_lot_numbers.color%TYPE:=NULL;

84: l_age NUMBER:=NULL;
85: l_retest_date DATE:=NULL;
86: l_maturity_date DATE:=NULL;
87: l_item_size NUMBER:=NULL;
88: l_color mtl_lot_numbers.color%TYPE:=NULL;
89: l_volume NUMBER:=NULL;
90: l_volume_uom mtl_lot_numbers.volume_uom%TYPE:=NULL;
91: l_place_of_origin mtl_lot_numbers.place_of_origin%TYPE:=NULL;
92: l_best_by_date DATE:=NULL;

Line 90: l_volume_uom mtl_lot_numbers.volume_uom%TYPE:=NULL;

86: l_maturity_date DATE:=NULL;
87: l_item_size NUMBER:=NULL;
88: l_color mtl_lot_numbers.color%TYPE:=NULL;
89: l_volume NUMBER:=NULL;
90: l_volume_uom mtl_lot_numbers.volume_uom%TYPE:=NULL;
91: l_place_of_origin mtl_lot_numbers.place_of_origin%TYPE:=NULL;
92: l_best_by_date DATE:=NULL;
93: l_length NUMBER:=NULL;
94: l_length_uom mtl_lot_numbers.volume_uom%TYPE:=NULL;

Line 91: l_place_of_origin mtl_lot_numbers.place_of_origin%TYPE:=NULL;

87: l_item_size NUMBER:=NULL;
88: l_color mtl_lot_numbers.color%TYPE:=NULL;
89: l_volume NUMBER:=NULL;
90: l_volume_uom mtl_lot_numbers.volume_uom%TYPE:=NULL;
91: l_place_of_origin mtl_lot_numbers.place_of_origin%TYPE:=NULL;
92: l_best_by_date DATE:=NULL;
93: l_length NUMBER:=NULL;
94: l_length_uom mtl_lot_numbers.volume_uom%TYPE:=NULL;
95: l_recycled_content NUMBER:=NULL;

Line 94: l_length_uom mtl_lot_numbers.volume_uom%TYPE:=NULL;

90: l_volume_uom mtl_lot_numbers.volume_uom%TYPE:=NULL;
91: l_place_of_origin mtl_lot_numbers.place_of_origin%TYPE:=NULL;
92: l_best_by_date DATE:=NULL;
93: l_length NUMBER:=NULL;
94: l_length_uom mtl_lot_numbers.volume_uom%TYPE:=NULL;
95: l_recycled_content NUMBER:=NULL;
96: l_thickness NUMBER:=NULL;
97: l_thickness_uom mtl_lot_numbers.volume_uom%TYPE:=NULL;
98: l_width NUMBER:=NULL;

Line 97: l_thickness_uom mtl_lot_numbers.volume_uom%TYPE:=NULL;

93: l_length NUMBER:=NULL;
94: l_length_uom mtl_lot_numbers.volume_uom%TYPE:=NULL;
95: l_recycled_content NUMBER:=NULL;
96: l_thickness NUMBER:=NULL;
97: l_thickness_uom mtl_lot_numbers.volume_uom%TYPE:=NULL;
98: l_width NUMBER:=NULL;
99: l_width_uom mtl_lot_numbers.volume_uom%TYPE:=NULL;
100: l_vendor_id NUMBER:=NULL;
101: l_vendor_name mtl_lot_numbers.vendor_name%TYPE:=NULL;

Line 99: l_width_uom mtl_lot_numbers.volume_uom%TYPE:=NULL;

95: l_recycled_content NUMBER:=NULL;
96: l_thickness NUMBER:=NULL;
97: l_thickness_uom mtl_lot_numbers.volume_uom%TYPE:=NULL;
98: l_width NUMBER:=NULL;
99: l_width_uom mtl_lot_numbers.volume_uom%TYPE:=NULL;
100: l_vendor_id NUMBER:=NULL;
101: l_vendor_name mtl_lot_numbers.vendor_name%TYPE:=NULL;
102: l_territory_code mtl_lot_numbers.territory_code%TYPE:=NULL;
103: l_supplier_lot_number mtl_lot_numbers.supplier_lot_number%TYPE:=NULL;

Line 101: l_vendor_name mtl_lot_numbers.vendor_name%TYPE:=NULL;

97: l_thickness_uom mtl_lot_numbers.volume_uom%TYPE:=NULL;
98: l_width NUMBER:=NULL;
99: l_width_uom mtl_lot_numbers.volume_uom%TYPE:=NULL;
100: l_vendor_id NUMBER:=NULL;
101: l_vendor_name mtl_lot_numbers.vendor_name%TYPE:=NULL;
102: l_territory_code mtl_lot_numbers.territory_code%TYPE:=NULL;
103: l_supplier_lot_number mtl_lot_numbers.supplier_lot_number%TYPE:=NULL;
104: l_curl_wrinkle_fold mtl_lot_numbers.supplier_lot_number%TYPE:=NULL;
105: l_status_id number;

Line 102: l_territory_code mtl_lot_numbers.territory_code%TYPE:=NULL;

98: l_width NUMBER:=NULL;
99: l_width_uom mtl_lot_numbers.volume_uom%TYPE:=NULL;
100: l_vendor_id NUMBER:=NULL;
101: l_vendor_name mtl_lot_numbers.vendor_name%TYPE:=NULL;
102: l_territory_code mtl_lot_numbers.territory_code%TYPE:=NULL;
103: l_supplier_lot_number mtl_lot_numbers.supplier_lot_number%TYPE:=NULL;
104: l_curl_wrinkle_fold mtl_lot_numbers.supplier_lot_number%TYPE:=NULL;
105: l_status_id number;
106:

Line 103: l_supplier_lot_number mtl_lot_numbers.supplier_lot_number%TYPE:=NULL;

99: l_width_uom mtl_lot_numbers.volume_uom%TYPE:=NULL;
100: l_vendor_id NUMBER:=NULL;
101: l_vendor_name mtl_lot_numbers.vendor_name%TYPE:=NULL;
102: l_territory_code mtl_lot_numbers.territory_code%TYPE:=NULL;
103: l_supplier_lot_number mtl_lot_numbers.supplier_lot_number%TYPE:=NULL;
104: l_curl_wrinkle_fold mtl_lot_numbers.supplier_lot_number%TYPE:=NULL;
105: l_status_id number;
106:
107: -- Source lot variables

Line 104: l_curl_wrinkle_fold mtl_lot_numbers.supplier_lot_number%TYPE:=NULL;

100: l_vendor_id NUMBER:=NULL;
101: l_vendor_name mtl_lot_numbers.vendor_name%TYPE:=NULL;
102: l_territory_code mtl_lot_numbers.territory_code%TYPE:=NULL;
103: l_supplier_lot_number mtl_lot_numbers.supplier_lot_number%TYPE:=NULL;
104: l_curl_wrinkle_fold mtl_lot_numbers.supplier_lot_number%TYPE:=NULL;
105: l_status_id number;
106:
107: -- Source lot variables
108: l_Sinvattr_tbl inv_lot_api_pub.char_tbl;

Line 113: l_Sgrade_code mtl_lot_numbers.grade_code%TYPE:=NULL;

109: l_SCattr_tbl inv_lot_api_pub.char_tbl;
110: l_SNattr_tbl inv_lot_api_pub.number_tbl;
111: l_SDattr_tbl inv_lot_api_pub.date_tbl;
112:
113: l_Sgrade_code mtl_lot_numbers.grade_code%TYPE:=NULL;
114: l_Sorigination_date DATE:=NULL;
115: l_Sdate_code mtl_lot_numbers.date_code%TYPE:=NULL;
116: l_Schange_date DATE:=NULL;
117: l_Sage NUMBER:=NULL;

Line 115: l_Sdate_code mtl_lot_numbers.date_code%TYPE:=NULL;

111: l_SDattr_tbl inv_lot_api_pub.date_tbl;
112:
113: l_Sgrade_code mtl_lot_numbers.grade_code%TYPE:=NULL;
114: l_Sorigination_date DATE:=NULL;
115: l_Sdate_code mtl_lot_numbers.date_code%TYPE:=NULL;
116: l_Schange_date DATE:=NULL;
117: l_Sage NUMBER:=NULL;
118: l_Sretest_date DATE:=NULL;
119: l_Smaturity_date DATE:=NULL;

Line 121: l_Scolor mtl_lot_numbers.color%TYPE:=NULL;

117: l_Sage NUMBER:=NULL;
118: l_Sretest_date DATE:=NULL;
119: l_Smaturity_date DATE:=NULL;
120: l_Sitem_size NUMBER:=NULL;
121: l_Scolor mtl_lot_numbers.color%TYPE:=NULL;
122: l_Svolume NUMBER:=NULL;
123: l_Svolume_uom mtl_lot_numbers.volume_uom%TYPE:=NULL;
124: l_Splace_of_origin mtl_lot_numbers.place_of_origin%TYPE:=NULL;
125: l_Sbest_by_date DATE:=NULL;

Line 123: l_Svolume_uom mtl_lot_numbers.volume_uom%TYPE:=NULL;

119: l_Smaturity_date DATE:=NULL;
120: l_Sitem_size NUMBER:=NULL;
121: l_Scolor mtl_lot_numbers.color%TYPE:=NULL;
122: l_Svolume NUMBER:=NULL;
123: l_Svolume_uom mtl_lot_numbers.volume_uom%TYPE:=NULL;
124: l_Splace_of_origin mtl_lot_numbers.place_of_origin%TYPE:=NULL;
125: l_Sbest_by_date DATE:=NULL;
126: l_Slength NUMBER:=NULL;
127: l_Slength_uom mtl_lot_numbers.volume_uom%TYPE:=NULL;

Line 124: l_Splace_of_origin mtl_lot_numbers.place_of_origin%TYPE:=NULL;

120: l_Sitem_size NUMBER:=NULL;
121: l_Scolor mtl_lot_numbers.color%TYPE:=NULL;
122: l_Svolume NUMBER:=NULL;
123: l_Svolume_uom mtl_lot_numbers.volume_uom%TYPE:=NULL;
124: l_Splace_of_origin mtl_lot_numbers.place_of_origin%TYPE:=NULL;
125: l_Sbest_by_date DATE:=NULL;
126: l_Slength NUMBER:=NULL;
127: l_Slength_uom mtl_lot_numbers.volume_uom%TYPE:=NULL;
128: l_Srecycled_content NUMBER:=NULL;

Line 127: l_Slength_uom mtl_lot_numbers.volume_uom%TYPE:=NULL;

123: l_Svolume_uom mtl_lot_numbers.volume_uom%TYPE:=NULL;
124: l_Splace_of_origin mtl_lot_numbers.place_of_origin%TYPE:=NULL;
125: l_Sbest_by_date DATE:=NULL;
126: l_Slength NUMBER:=NULL;
127: l_Slength_uom mtl_lot_numbers.volume_uom%TYPE:=NULL;
128: l_Srecycled_content NUMBER:=NULL;
129: l_Sthickness NUMBER:=NULL;
130: l_Sthickness_uom mtl_lot_numbers.volume_uom%TYPE:=NULL;
131: l_Swidth NUMBER:=NULL;

Line 130: l_Sthickness_uom mtl_lot_numbers.volume_uom%TYPE:=NULL;

126: l_Slength NUMBER:=NULL;
127: l_Slength_uom mtl_lot_numbers.volume_uom%TYPE:=NULL;
128: l_Srecycled_content NUMBER:=NULL;
129: l_Sthickness NUMBER:=NULL;
130: l_Sthickness_uom mtl_lot_numbers.volume_uom%TYPE:=NULL;
131: l_Swidth NUMBER:=NULL;
132: l_Swidth_uom mtl_lot_numbers.volume_uom%TYPE:=NULL;
133: l_Svendor_id NUMBER:=NULL;
134: l_Svendor_name mtl_lot_numbers.vendor_name%TYPE:=NULL;

Line 132: l_Swidth_uom mtl_lot_numbers.volume_uom%TYPE:=NULL;

128: l_Srecycled_content NUMBER:=NULL;
129: l_Sthickness NUMBER:=NULL;
130: l_Sthickness_uom mtl_lot_numbers.volume_uom%TYPE:=NULL;
131: l_Swidth NUMBER:=NULL;
132: l_Swidth_uom mtl_lot_numbers.volume_uom%TYPE:=NULL;
133: l_Svendor_id NUMBER:=NULL;
134: l_Svendor_name mtl_lot_numbers.vendor_name%TYPE:=NULL;
135: l_Sterritory_code mtl_lot_numbers.territory_code%TYPE:=NULL;
136: l_Ssupplier_lot_number mtl_lot_numbers.supplier_lot_number%TYPE:=NULL;

Line 134: l_Svendor_name mtl_lot_numbers.vendor_name%TYPE:=NULL;

130: l_Sthickness_uom mtl_lot_numbers.volume_uom%TYPE:=NULL;
131: l_Swidth NUMBER:=NULL;
132: l_Swidth_uom mtl_lot_numbers.volume_uom%TYPE:=NULL;
133: l_Svendor_id NUMBER:=NULL;
134: l_Svendor_name mtl_lot_numbers.vendor_name%TYPE:=NULL;
135: l_Sterritory_code mtl_lot_numbers.territory_code%TYPE:=NULL;
136: l_Ssupplier_lot_number mtl_lot_numbers.supplier_lot_number%TYPE:=NULL;
137: l_Scurl_wrinkle_fold mtl_lot_numbers.supplier_lot_number%TYPE:=NULL;
138:

Line 135: l_Sterritory_code mtl_lot_numbers.territory_code%TYPE:=NULL;

131: l_Swidth NUMBER:=NULL;
132: l_Swidth_uom mtl_lot_numbers.volume_uom%TYPE:=NULL;
133: l_Svendor_id NUMBER:=NULL;
134: l_Svendor_name mtl_lot_numbers.vendor_name%TYPE:=NULL;
135: l_Sterritory_code mtl_lot_numbers.territory_code%TYPE:=NULL;
136: l_Ssupplier_lot_number mtl_lot_numbers.supplier_lot_number%TYPE:=NULL;
137: l_Scurl_wrinkle_fold mtl_lot_numbers.supplier_lot_number%TYPE:=NULL;
138:
139: x_lot_exists VARCHAR2(1):='N';

Line 136: l_Ssupplier_lot_number mtl_lot_numbers.supplier_lot_number%TYPE:=NULL;

132: l_Swidth_uom mtl_lot_numbers.volume_uom%TYPE:=NULL;
133: l_Svendor_id NUMBER:=NULL;
134: l_Svendor_name mtl_lot_numbers.vendor_name%TYPE:=NULL;
135: l_Sterritory_code mtl_lot_numbers.territory_code%TYPE:=NULL;
136: l_Ssupplier_lot_number mtl_lot_numbers.supplier_lot_number%TYPE:=NULL;
137: l_Scurl_wrinkle_fold mtl_lot_numbers.supplier_lot_number%TYPE:=NULL;
138:
139: x_lot_exists VARCHAR2(1):='N';
140: x_src_lot_exists VARCHAR2(1):='N';

Line 137: l_Scurl_wrinkle_fold mtl_lot_numbers.supplier_lot_number%TYPE:=NULL;

133: l_Svendor_id NUMBER:=NULL;
134: l_Svendor_name mtl_lot_numbers.vendor_name%TYPE:=NULL;
135: l_Sterritory_code mtl_lot_numbers.territory_code%TYPE:=NULL;
136: l_Ssupplier_lot_number mtl_lot_numbers.supplier_lot_number%TYPE:=NULL;
137: l_Scurl_wrinkle_fold mtl_lot_numbers.supplier_lot_number%TYPE:=NULL;
138:
139: x_lot_exists VARCHAR2(1):='N';
140: x_src_lot_exists VARCHAR2(1):='N';
141: l_mtli_txn_id NUMBER;

Line 164: l_temp_description mtl_lot_numbers.description%type:=null;

160: l_temp_Cattr_tbl inv_lot_api_pub.char_tbl;
161: l_temp_Nattr_tbl inv_lot_api_pub.number_tbl;
162: l_temp_Dattr_tbl inv_lot_api_pub.date_tbl;
163:
164: l_temp_description mtl_lot_numbers.description%type:=null;
165: l_temp_grade_code mtl_lot_numbers.grade_code%type:=null;
166: l_temp_origination_date date:=null;
167: l_temp_date_code mtl_lot_numbers.date_code%type:=null;
168: l_temp_change_date date:=null;

Line 165: l_temp_grade_code mtl_lot_numbers.grade_code%type:=null;

161: l_temp_Nattr_tbl inv_lot_api_pub.number_tbl;
162: l_temp_Dattr_tbl inv_lot_api_pub.date_tbl;
163:
164: l_temp_description mtl_lot_numbers.description%type:=null;
165: l_temp_grade_code mtl_lot_numbers.grade_code%type:=null;
166: l_temp_origination_date date:=null;
167: l_temp_date_code mtl_lot_numbers.date_code%type:=null;
168: l_temp_change_date date:=null;
169: l_temp_age number:=null;

Line 167: l_temp_date_code mtl_lot_numbers.date_code%type:=null;

163:
164: l_temp_description mtl_lot_numbers.description%type:=null;
165: l_temp_grade_code mtl_lot_numbers.grade_code%type:=null;
166: l_temp_origination_date date:=null;
167: l_temp_date_code mtl_lot_numbers.date_code%type:=null;
168: l_temp_change_date date:=null;
169: l_temp_age number:=null;
170: l_temp_retest_date date:=null;
171: l_temp_maturity_date date:=null;

Line 173: l_temp_color mtl_lot_numbers.color%type:=null;

169: l_temp_age number:=null;
170: l_temp_retest_date date:=null;
171: l_temp_maturity_date date:=null;
172: l_temp_item_size number:=null;
173: l_temp_color mtl_lot_numbers.color%type:=null;
174: l_temp_volume number:=null;
175: l_temp_volume_uom mtl_lot_numbers.volume_uom%type:=null;
176: l_temp_place_of_origin mtl_lot_numbers.place_of_origin%type:=null;
177: l_temp_best_by_date date:=null;

Line 175: l_temp_volume_uom mtl_lot_numbers.volume_uom%type:=null;

171: l_temp_maturity_date date:=null;
172: l_temp_item_size number:=null;
173: l_temp_color mtl_lot_numbers.color%type:=null;
174: l_temp_volume number:=null;
175: l_temp_volume_uom mtl_lot_numbers.volume_uom%type:=null;
176: l_temp_place_of_origin mtl_lot_numbers.place_of_origin%type:=null;
177: l_temp_best_by_date date:=null;
178: l_temp_length number:=null;
179: l_temp_length_uom mtl_lot_numbers.volume_uom%type:=null;

Line 176: l_temp_place_of_origin mtl_lot_numbers.place_of_origin%type:=null;

172: l_temp_item_size number:=null;
173: l_temp_color mtl_lot_numbers.color%type:=null;
174: l_temp_volume number:=null;
175: l_temp_volume_uom mtl_lot_numbers.volume_uom%type:=null;
176: l_temp_place_of_origin mtl_lot_numbers.place_of_origin%type:=null;
177: l_temp_best_by_date date:=null;
178: l_temp_length number:=null;
179: l_temp_length_uom mtl_lot_numbers.volume_uom%type:=null;
180: l_temp_recycled_content number:=null;

Line 179: l_temp_length_uom mtl_lot_numbers.volume_uom%type:=null;

175: l_temp_volume_uom mtl_lot_numbers.volume_uom%type:=null;
176: l_temp_place_of_origin mtl_lot_numbers.place_of_origin%type:=null;
177: l_temp_best_by_date date:=null;
178: l_temp_length number:=null;
179: l_temp_length_uom mtl_lot_numbers.volume_uom%type:=null;
180: l_temp_recycled_content number:=null;
181: l_temp_thickness number:=null;
182: l_temp_thickness_uom mtl_lot_numbers.volume_uom%type:=null;
183: l_temp_width number:=null;

Line 182: l_temp_thickness_uom mtl_lot_numbers.volume_uom%type:=null;

178: l_temp_length number:=null;
179: l_temp_length_uom mtl_lot_numbers.volume_uom%type:=null;
180: l_temp_recycled_content number:=null;
181: l_temp_thickness number:=null;
182: l_temp_thickness_uom mtl_lot_numbers.volume_uom%type:=null;
183: l_temp_width number:=null;
184: l_temp_width_uom mtl_lot_numbers.volume_uom%type:=null;
185: l_temp_vendor_id number:=null;
186: l_temp_vendor_name mtl_lot_numbers.vendor_name%type:=null;

Line 184: l_temp_width_uom mtl_lot_numbers.volume_uom%type:=null;

180: l_temp_recycled_content number:=null;
181: l_temp_thickness number:=null;
182: l_temp_thickness_uom mtl_lot_numbers.volume_uom%type:=null;
183: l_temp_width number:=null;
184: l_temp_width_uom mtl_lot_numbers.volume_uom%type:=null;
185: l_temp_vendor_id number:=null;
186: l_temp_vendor_name mtl_lot_numbers.vendor_name%type:=null;
187: l_temp_territory_code mtl_lot_numbers.territory_code%type:=null;
188: l_temp_supplier_lot_number mtl_lot_numbers.supplier_lot_number%type:=null;

Line 186: l_temp_vendor_name mtl_lot_numbers.vendor_name%type:=null;

182: l_temp_thickness_uom mtl_lot_numbers.volume_uom%type:=null;
183: l_temp_width number:=null;
184: l_temp_width_uom mtl_lot_numbers.volume_uom%type:=null;
185: l_temp_vendor_id number:=null;
186: l_temp_vendor_name mtl_lot_numbers.vendor_name%type:=null;
187: l_temp_territory_code mtl_lot_numbers.territory_code%type:=null;
188: l_temp_supplier_lot_number mtl_lot_numbers.supplier_lot_number%type:=null;
189: l_temp_curl_wrinkle_fold mtl_lot_numbers.supplier_lot_number%type:=null;
190:

Line 187: l_temp_territory_code mtl_lot_numbers.territory_code%type:=null;

183: l_temp_width number:=null;
184: l_temp_width_uom mtl_lot_numbers.volume_uom%type:=null;
185: l_temp_vendor_id number:=null;
186: l_temp_vendor_name mtl_lot_numbers.vendor_name%type:=null;
187: l_temp_territory_code mtl_lot_numbers.territory_code%type:=null;
188: l_temp_supplier_lot_number mtl_lot_numbers.supplier_lot_number%type:=null;
189: l_temp_curl_wrinkle_fold mtl_lot_numbers.supplier_lot_number%type:=null;
190:
191: -- Bug 5367283 the above variables are added

Line 188: l_temp_supplier_lot_number mtl_lot_numbers.supplier_lot_number%type:=null;

184: l_temp_width_uom mtl_lot_numbers.volume_uom%type:=null;
185: l_temp_vendor_id number:=null;
186: l_temp_vendor_name mtl_lot_numbers.vendor_name%type:=null;
187: l_temp_territory_code mtl_lot_numbers.territory_code%type:=null;
188: l_temp_supplier_lot_number mtl_lot_numbers.supplier_lot_number%type:=null;
189: l_temp_curl_wrinkle_fold mtl_lot_numbers.supplier_lot_number%type:=null;
190:
191: -- Bug 5367283 the above variables are added
192:

Line 189: l_temp_curl_wrinkle_fold mtl_lot_numbers.supplier_lot_number%type:=null;

185: l_temp_vendor_id number:=null;
186: l_temp_vendor_name mtl_lot_numbers.vendor_name%type:=null;
187: l_temp_territory_code mtl_lot_numbers.territory_code%type:=null;
188: l_temp_supplier_lot_number mtl_lot_numbers.supplier_lot_number%type:=null;
189: l_temp_curl_wrinkle_fold mtl_lot_numbers.supplier_lot_number%type:=null;
190:
191: -- Bug 5367283 the above variables are added
192:
193: BEGIN

Line 298: from mtl_lot_numbers

294: 'Lot Attributes'); */
295: -- Added for bug 5463921.
296: select lot_attribute_category
297: into x_src_context_code
298: from mtl_lot_numbers
299: where lot_number=p_src_lot_number
300: and inventory_item_id=p_src_inv_item_id
301: and organization_id= p_org_id;
302:

Line 501: FROM mtl_lot_numbers

497: ,l_invattr_tbl(12)
498: ,l_invattr_tbl(13)
499: ,l_invattr_tbl(14)
500: ,l_invattr_tbl(15)
501: FROM mtl_lot_numbers
502: WHERE lot_number=nvl(p_src_lot_number,p_lot_number) /* modified for fixing bug 5126021 */
503: AND inventory_item_id=nvl(p_src_inv_item_id,p_inv_item_id) /* modified for fixing bug 5126021 */
504: AND organization_id=p_org_id;
505:

Line 688: FROM mtl_lot_numbers

684: ,l_invattr_tbl(12)
685: ,l_invattr_tbl(13)
686: ,l_invattr_tbl(14)
687: ,l_invattr_tbl(15)
688: FROM mtl_lot_numbers
689: WHERE lot_number=nvl(p_src_lot_number,p_lot_number)
690: AND inventory_item_id=nvl(p_src_inv_item_id,p_inv_item_id)
691: AND organization_id=p_org_id;
692:

Line 858: FROM mtl_lot_numbers

854: ,l_invattr_tbl(12)
855: ,l_invattr_tbl(13)
856: ,l_invattr_tbl(14)
857: ,l_invattr_tbl(15)
858: FROM mtl_lot_numbers
859: WHERE lot_number=nvl(p_src_lot_number,p_lot_number) -- modified for fixing bug 5126021
860: AND inventory_item_id=nvl(p_src_inv_item_id,p_inv_item_id) -- modified for fixing bug 5126021
861: AND organization_id=p_org_id;
862:

Line 1076: if inv_lot_sel_attr.is_enabled('MTL_LOT_NUMBERS',

1072: if inv_lot_sel_attr.is_enabled('Lot Attributes',
1073: p_org_id,p_inv_item_id) >= 2 THEN
1074: l_wms_attr_required:=TRUE;
1075: end if;
1076: if inv_lot_sel_attr.is_enabled('MTL_LOT_NUMBERS',
1077: p_org_id,p_inv_item_id) >= 2 THEN
1078: l_inv_attr_required:=TRUE;
1079: end if;
1080: if (l_wms_attr_required OR l_inv_attr_required) THEN