[Home] [Help]
6: g_pkg_name CONSTANT VARCHAR2(30) := 'WMS_Task_Dispatch_put_away';
7:
8: /* FP-J Lot/Serial Support Enhancement
9: * Record type to store information for one serial number. This is used for
10: * inserting MTL_SERIAL_NUMBERS for the serial numbers in the LPN
11: */
12: TYPE msn_attribute_rec_tp IS RECORD(
13: serial_number mtl_serial_numbers.serial_number%TYPE
14: , to_serial_number mtl_serial_numbers.serial_number%TYPE
9: * Record type to store information for one serial number. This is used for
10: * inserting MTL_SERIAL_NUMBERS for the serial numbers in the LPN
11: */
12: TYPE msn_attribute_rec_tp IS RECORD(
13: serial_number mtl_serial_numbers.serial_number%TYPE
14: , to_serial_number mtl_serial_numbers.serial_number%TYPE
15: , vendor_serial_number mtl_serial_numbers.vendor_serial_number%TYPE
16: , vendor_lot_number mtl_serial_numbers.vendor_lot_number%TYPE
17: , parent_serial_number mtl_serial_numbers.parent_serial_number%TYPE
10: * inserting MTL_SERIAL_NUMBERS for the serial numbers in the LPN
11: */
12: TYPE msn_attribute_rec_tp IS RECORD(
13: serial_number mtl_serial_numbers.serial_number%TYPE
14: , to_serial_number mtl_serial_numbers.serial_number%TYPE
15: , vendor_serial_number mtl_serial_numbers.vendor_serial_number%TYPE
16: , vendor_lot_number mtl_serial_numbers.vendor_lot_number%TYPE
17: , parent_serial_number mtl_serial_numbers.parent_serial_number%TYPE
18: , origination_date mtl_serial_numbers.origination_date%TYPE
11: */
12: TYPE msn_attribute_rec_tp IS RECORD(
13: serial_number mtl_serial_numbers.serial_number%TYPE
14: , to_serial_number mtl_serial_numbers.serial_number%TYPE
15: , vendor_serial_number mtl_serial_numbers.vendor_serial_number%TYPE
16: , vendor_lot_number mtl_serial_numbers.vendor_lot_number%TYPE
17: , parent_serial_number mtl_serial_numbers.parent_serial_number%TYPE
18: , origination_date mtl_serial_numbers.origination_date%TYPE
19: , end_item_unit_number mtl_serial_numbers.end_item_unit_number%TYPE
12: TYPE msn_attribute_rec_tp IS RECORD(
13: serial_number mtl_serial_numbers.serial_number%TYPE
14: , to_serial_number mtl_serial_numbers.serial_number%TYPE
15: , vendor_serial_number mtl_serial_numbers.vendor_serial_number%TYPE
16: , vendor_lot_number mtl_serial_numbers.vendor_lot_number%TYPE
17: , parent_serial_number mtl_serial_numbers.parent_serial_number%TYPE
18: , origination_date mtl_serial_numbers.origination_date%TYPE
19: , end_item_unit_number mtl_serial_numbers.end_item_unit_number%TYPE
20: , territory_code mtl_serial_numbers.territory_code%TYPE
13: serial_number mtl_serial_numbers.serial_number%TYPE
14: , to_serial_number mtl_serial_numbers.serial_number%TYPE
15: , vendor_serial_number mtl_serial_numbers.vendor_serial_number%TYPE
16: , vendor_lot_number mtl_serial_numbers.vendor_lot_number%TYPE
17: , parent_serial_number mtl_serial_numbers.parent_serial_number%TYPE
18: , origination_date mtl_serial_numbers.origination_date%TYPE
19: , end_item_unit_number mtl_serial_numbers.end_item_unit_number%TYPE
20: , territory_code mtl_serial_numbers.territory_code%TYPE
21: , time_since_new mtl_serial_numbers.time_since_new%TYPE
14: , to_serial_number mtl_serial_numbers.serial_number%TYPE
15: , vendor_serial_number mtl_serial_numbers.vendor_serial_number%TYPE
16: , vendor_lot_number mtl_serial_numbers.vendor_lot_number%TYPE
17: , parent_serial_number mtl_serial_numbers.parent_serial_number%TYPE
18: , origination_date mtl_serial_numbers.origination_date%TYPE
19: , end_item_unit_number mtl_serial_numbers.end_item_unit_number%TYPE
20: , territory_code mtl_serial_numbers.territory_code%TYPE
21: , time_since_new mtl_serial_numbers.time_since_new%TYPE
22: , cycles_since_new mtl_serial_numbers.cycles_since_new%TYPE
15: , vendor_serial_number mtl_serial_numbers.vendor_serial_number%TYPE
16: , vendor_lot_number mtl_serial_numbers.vendor_lot_number%TYPE
17: , parent_serial_number mtl_serial_numbers.parent_serial_number%TYPE
18: , origination_date mtl_serial_numbers.origination_date%TYPE
19: , end_item_unit_number mtl_serial_numbers.end_item_unit_number%TYPE
20: , territory_code mtl_serial_numbers.territory_code%TYPE
21: , time_since_new mtl_serial_numbers.time_since_new%TYPE
22: , cycles_since_new mtl_serial_numbers.cycles_since_new%TYPE
23: , time_since_overhaul mtl_serial_numbers.time_since_overhaul%TYPE
16: , vendor_lot_number mtl_serial_numbers.vendor_lot_number%TYPE
17: , parent_serial_number mtl_serial_numbers.parent_serial_number%TYPE
18: , origination_date mtl_serial_numbers.origination_date%TYPE
19: , end_item_unit_number mtl_serial_numbers.end_item_unit_number%TYPE
20: , territory_code mtl_serial_numbers.territory_code%TYPE
21: , time_since_new mtl_serial_numbers.time_since_new%TYPE
22: , cycles_since_new mtl_serial_numbers.cycles_since_new%TYPE
23: , time_since_overhaul mtl_serial_numbers.time_since_overhaul%TYPE
24: , cycles_since_overhaul mtl_serial_numbers.cycles_since_overhaul%TYPE
17: , parent_serial_number mtl_serial_numbers.parent_serial_number%TYPE
18: , origination_date mtl_serial_numbers.origination_date%TYPE
19: , end_item_unit_number mtl_serial_numbers.end_item_unit_number%TYPE
20: , territory_code mtl_serial_numbers.territory_code%TYPE
21: , time_since_new mtl_serial_numbers.time_since_new%TYPE
22: , cycles_since_new mtl_serial_numbers.cycles_since_new%TYPE
23: , time_since_overhaul mtl_serial_numbers.time_since_overhaul%TYPE
24: , cycles_since_overhaul mtl_serial_numbers.cycles_since_overhaul%TYPE
25: , time_since_repair mtl_serial_numbers.time_since_repair%TYPE
18: , origination_date mtl_serial_numbers.origination_date%TYPE
19: , end_item_unit_number mtl_serial_numbers.end_item_unit_number%TYPE
20: , territory_code mtl_serial_numbers.territory_code%TYPE
21: , time_since_new mtl_serial_numbers.time_since_new%TYPE
22: , cycles_since_new mtl_serial_numbers.cycles_since_new%TYPE
23: , time_since_overhaul mtl_serial_numbers.time_since_overhaul%TYPE
24: , cycles_since_overhaul mtl_serial_numbers.cycles_since_overhaul%TYPE
25: , time_since_repair mtl_serial_numbers.time_since_repair%TYPE
26: , cycles_since_repair mtl_serial_numbers.cycles_since_repair%TYPE
19: , end_item_unit_number mtl_serial_numbers.end_item_unit_number%TYPE
20: , territory_code mtl_serial_numbers.territory_code%TYPE
21: , time_since_new mtl_serial_numbers.time_since_new%TYPE
22: , cycles_since_new mtl_serial_numbers.cycles_since_new%TYPE
23: , time_since_overhaul mtl_serial_numbers.time_since_overhaul%TYPE
24: , cycles_since_overhaul mtl_serial_numbers.cycles_since_overhaul%TYPE
25: , time_since_repair mtl_serial_numbers.time_since_repair%TYPE
26: , cycles_since_repair mtl_serial_numbers.cycles_since_repair%TYPE
27: , time_since_visit mtl_serial_numbers.time_since_visit%TYPE
20: , territory_code mtl_serial_numbers.territory_code%TYPE
21: , time_since_new mtl_serial_numbers.time_since_new%TYPE
22: , cycles_since_new mtl_serial_numbers.cycles_since_new%TYPE
23: , time_since_overhaul mtl_serial_numbers.time_since_overhaul%TYPE
24: , cycles_since_overhaul mtl_serial_numbers.cycles_since_overhaul%TYPE
25: , time_since_repair mtl_serial_numbers.time_since_repair%TYPE
26: , cycles_since_repair mtl_serial_numbers.cycles_since_repair%TYPE
27: , time_since_visit mtl_serial_numbers.time_since_visit%TYPE
28: , cycles_since_visit mtl_serial_numbers.cycles_since_visit%TYPE
21: , time_since_new mtl_serial_numbers.time_since_new%TYPE
22: , cycles_since_new mtl_serial_numbers.cycles_since_new%TYPE
23: , time_since_overhaul mtl_serial_numbers.time_since_overhaul%TYPE
24: , cycles_since_overhaul mtl_serial_numbers.cycles_since_overhaul%TYPE
25: , time_since_repair mtl_serial_numbers.time_since_repair%TYPE
26: , cycles_since_repair mtl_serial_numbers.cycles_since_repair%TYPE
27: , time_since_visit mtl_serial_numbers.time_since_visit%TYPE
28: , cycles_since_visit mtl_serial_numbers.cycles_since_visit%TYPE
29: , time_since_mark mtl_serial_numbers.time_since_mark%TYPE
22: , cycles_since_new mtl_serial_numbers.cycles_since_new%TYPE
23: , time_since_overhaul mtl_serial_numbers.time_since_overhaul%TYPE
24: , cycles_since_overhaul mtl_serial_numbers.cycles_since_overhaul%TYPE
25: , time_since_repair mtl_serial_numbers.time_since_repair%TYPE
26: , cycles_since_repair mtl_serial_numbers.cycles_since_repair%TYPE
27: , time_since_visit mtl_serial_numbers.time_since_visit%TYPE
28: , cycles_since_visit mtl_serial_numbers.cycles_since_visit%TYPE
29: , time_since_mark mtl_serial_numbers.time_since_mark%TYPE
30: , cycles_since_mark mtl_serial_numbers.cycles_since_mark%TYPE
23: , time_since_overhaul mtl_serial_numbers.time_since_overhaul%TYPE
24: , cycles_since_overhaul mtl_serial_numbers.cycles_since_overhaul%TYPE
25: , time_since_repair mtl_serial_numbers.time_since_repair%TYPE
26: , cycles_since_repair mtl_serial_numbers.cycles_since_repair%TYPE
27: , time_since_visit mtl_serial_numbers.time_since_visit%TYPE
28: , cycles_since_visit mtl_serial_numbers.cycles_since_visit%TYPE
29: , time_since_mark mtl_serial_numbers.time_since_mark%TYPE
30: , cycles_since_mark mtl_serial_numbers.cycles_since_mark%TYPE
31: , number_of_repairs mtl_serial_numbers.number_of_repairs%TYPE
24: , cycles_since_overhaul mtl_serial_numbers.cycles_since_overhaul%TYPE
25: , time_since_repair mtl_serial_numbers.time_since_repair%TYPE
26: , cycles_since_repair mtl_serial_numbers.cycles_since_repair%TYPE
27: , time_since_visit mtl_serial_numbers.time_since_visit%TYPE
28: , cycles_since_visit mtl_serial_numbers.cycles_since_visit%TYPE
29: , time_since_mark mtl_serial_numbers.time_since_mark%TYPE
30: , cycles_since_mark mtl_serial_numbers.cycles_since_mark%TYPE
31: , number_of_repairs mtl_serial_numbers.number_of_repairs%TYPE
32: , serial_attribute_category mtl_serial_numbers.serial_attribute_category%TYPE
25: , time_since_repair mtl_serial_numbers.time_since_repair%TYPE
26: , cycles_since_repair mtl_serial_numbers.cycles_since_repair%TYPE
27: , time_since_visit mtl_serial_numbers.time_since_visit%TYPE
28: , cycles_since_visit mtl_serial_numbers.cycles_since_visit%TYPE
29: , time_since_mark mtl_serial_numbers.time_since_mark%TYPE
30: , cycles_since_mark mtl_serial_numbers.cycles_since_mark%TYPE
31: , number_of_repairs mtl_serial_numbers.number_of_repairs%TYPE
32: , serial_attribute_category mtl_serial_numbers.serial_attribute_category%TYPE
33: , c_attribute1 mtl_serial_numbers.c_attribute1%TYPE
26: , cycles_since_repair mtl_serial_numbers.cycles_since_repair%TYPE
27: , time_since_visit mtl_serial_numbers.time_since_visit%TYPE
28: , cycles_since_visit mtl_serial_numbers.cycles_since_visit%TYPE
29: , time_since_mark mtl_serial_numbers.time_since_mark%TYPE
30: , cycles_since_mark mtl_serial_numbers.cycles_since_mark%TYPE
31: , number_of_repairs mtl_serial_numbers.number_of_repairs%TYPE
32: , serial_attribute_category mtl_serial_numbers.serial_attribute_category%TYPE
33: , c_attribute1 mtl_serial_numbers.c_attribute1%TYPE
34: , c_attribute2 mtl_serial_numbers.c_attribute2%TYPE
27: , time_since_visit mtl_serial_numbers.time_since_visit%TYPE
28: , cycles_since_visit mtl_serial_numbers.cycles_since_visit%TYPE
29: , time_since_mark mtl_serial_numbers.time_since_mark%TYPE
30: , cycles_since_mark mtl_serial_numbers.cycles_since_mark%TYPE
31: , number_of_repairs mtl_serial_numbers.number_of_repairs%TYPE
32: , serial_attribute_category mtl_serial_numbers.serial_attribute_category%TYPE
33: , c_attribute1 mtl_serial_numbers.c_attribute1%TYPE
34: , c_attribute2 mtl_serial_numbers.c_attribute2%TYPE
35: , c_attribute3 mtl_serial_numbers.c_attribute3%TYPE
28: , cycles_since_visit mtl_serial_numbers.cycles_since_visit%TYPE
29: , time_since_mark mtl_serial_numbers.time_since_mark%TYPE
30: , cycles_since_mark mtl_serial_numbers.cycles_since_mark%TYPE
31: , number_of_repairs mtl_serial_numbers.number_of_repairs%TYPE
32: , serial_attribute_category mtl_serial_numbers.serial_attribute_category%TYPE
33: , c_attribute1 mtl_serial_numbers.c_attribute1%TYPE
34: , c_attribute2 mtl_serial_numbers.c_attribute2%TYPE
35: , c_attribute3 mtl_serial_numbers.c_attribute3%TYPE
36: , c_attribute4 mtl_serial_numbers.c_attribute4%TYPE
29: , time_since_mark mtl_serial_numbers.time_since_mark%TYPE
30: , cycles_since_mark mtl_serial_numbers.cycles_since_mark%TYPE
31: , number_of_repairs mtl_serial_numbers.number_of_repairs%TYPE
32: , serial_attribute_category mtl_serial_numbers.serial_attribute_category%TYPE
33: , c_attribute1 mtl_serial_numbers.c_attribute1%TYPE
34: , c_attribute2 mtl_serial_numbers.c_attribute2%TYPE
35: , c_attribute3 mtl_serial_numbers.c_attribute3%TYPE
36: , c_attribute4 mtl_serial_numbers.c_attribute4%TYPE
37: , c_attribute5 mtl_serial_numbers.c_attribute5%TYPE
30: , cycles_since_mark mtl_serial_numbers.cycles_since_mark%TYPE
31: , number_of_repairs mtl_serial_numbers.number_of_repairs%TYPE
32: , serial_attribute_category mtl_serial_numbers.serial_attribute_category%TYPE
33: , c_attribute1 mtl_serial_numbers.c_attribute1%TYPE
34: , c_attribute2 mtl_serial_numbers.c_attribute2%TYPE
35: , c_attribute3 mtl_serial_numbers.c_attribute3%TYPE
36: , c_attribute4 mtl_serial_numbers.c_attribute4%TYPE
37: , c_attribute5 mtl_serial_numbers.c_attribute5%TYPE
38: , c_attribute6 mtl_serial_numbers.c_attribute6%TYPE
31: , number_of_repairs mtl_serial_numbers.number_of_repairs%TYPE
32: , serial_attribute_category mtl_serial_numbers.serial_attribute_category%TYPE
33: , c_attribute1 mtl_serial_numbers.c_attribute1%TYPE
34: , c_attribute2 mtl_serial_numbers.c_attribute2%TYPE
35: , c_attribute3 mtl_serial_numbers.c_attribute3%TYPE
36: , c_attribute4 mtl_serial_numbers.c_attribute4%TYPE
37: , c_attribute5 mtl_serial_numbers.c_attribute5%TYPE
38: , c_attribute6 mtl_serial_numbers.c_attribute6%TYPE
39: , c_attribute7 mtl_serial_numbers.c_attribute7%TYPE
32: , serial_attribute_category mtl_serial_numbers.serial_attribute_category%TYPE
33: , c_attribute1 mtl_serial_numbers.c_attribute1%TYPE
34: , c_attribute2 mtl_serial_numbers.c_attribute2%TYPE
35: , c_attribute3 mtl_serial_numbers.c_attribute3%TYPE
36: , c_attribute4 mtl_serial_numbers.c_attribute4%TYPE
37: , c_attribute5 mtl_serial_numbers.c_attribute5%TYPE
38: , c_attribute6 mtl_serial_numbers.c_attribute6%TYPE
39: , c_attribute7 mtl_serial_numbers.c_attribute7%TYPE
40: , c_attribute8 mtl_serial_numbers.c_attribute8%TYPE
33: , c_attribute1 mtl_serial_numbers.c_attribute1%TYPE
34: , c_attribute2 mtl_serial_numbers.c_attribute2%TYPE
35: , c_attribute3 mtl_serial_numbers.c_attribute3%TYPE
36: , c_attribute4 mtl_serial_numbers.c_attribute4%TYPE
37: , c_attribute5 mtl_serial_numbers.c_attribute5%TYPE
38: , c_attribute6 mtl_serial_numbers.c_attribute6%TYPE
39: , c_attribute7 mtl_serial_numbers.c_attribute7%TYPE
40: , c_attribute8 mtl_serial_numbers.c_attribute8%TYPE
41: , c_attribute9 mtl_serial_numbers.c_attribute9%TYPE
34: , c_attribute2 mtl_serial_numbers.c_attribute2%TYPE
35: , c_attribute3 mtl_serial_numbers.c_attribute3%TYPE
36: , c_attribute4 mtl_serial_numbers.c_attribute4%TYPE
37: , c_attribute5 mtl_serial_numbers.c_attribute5%TYPE
38: , c_attribute6 mtl_serial_numbers.c_attribute6%TYPE
39: , c_attribute7 mtl_serial_numbers.c_attribute7%TYPE
40: , c_attribute8 mtl_serial_numbers.c_attribute8%TYPE
41: , c_attribute9 mtl_serial_numbers.c_attribute9%TYPE
42: , c_attribute10 mtl_serial_numbers.c_attribute10%TYPE
35: , c_attribute3 mtl_serial_numbers.c_attribute3%TYPE
36: , c_attribute4 mtl_serial_numbers.c_attribute4%TYPE
37: , c_attribute5 mtl_serial_numbers.c_attribute5%TYPE
38: , c_attribute6 mtl_serial_numbers.c_attribute6%TYPE
39: , c_attribute7 mtl_serial_numbers.c_attribute7%TYPE
40: , c_attribute8 mtl_serial_numbers.c_attribute8%TYPE
41: , c_attribute9 mtl_serial_numbers.c_attribute9%TYPE
42: , c_attribute10 mtl_serial_numbers.c_attribute10%TYPE
43: , c_attribute11 mtl_serial_numbers.c_attribute11%TYPE
36: , c_attribute4 mtl_serial_numbers.c_attribute4%TYPE
37: , c_attribute5 mtl_serial_numbers.c_attribute5%TYPE
38: , c_attribute6 mtl_serial_numbers.c_attribute6%TYPE
39: , c_attribute7 mtl_serial_numbers.c_attribute7%TYPE
40: , c_attribute8 mtl_serial_numbers.c_attribute8%TYPE
41: , c_attribute9 mtl_serial_numbers.c_attribute9%TYPE
42: , c_attribute10 mtl_serial_numbers.c_attribute10%TYPE
43: , c_attribute11 mtl_serial_numbers.c_attribute11%TYPE
44: , c_attribute12 mtl_serial_numbers.c_attribute12%TYPE
37: , c_attribute5 mtl_serial_numbers.c_attribute5%TYPE
38: , c_attribute6 mtl_serial_numbers.c_attribute6%TYPE
39: , c_attribute7 mtl_serial_numbers.c_attribute7%TYPE
40: , c_attribute8 mtl_serial_numbers.c_attribute8%TYPE
41: , c_attribute9 mtl_serial_numbers.c_attribute9%TYPE
42: , c_attribute10 mtl_serial_numbers.c_attribute10%TYPE
43: , c_attribute11 mtl_serial_numbers.c_attribute11%TYPE
44: , c_attribute12 mtl_serial_numbers.c_attribute12%TYPE
45: , c_attribute13 mtl_serial_numbers.c_attribute13%TYPE
38: , c_attribute6 mtl_serial_numbers.c_attribute6%TYPE
39: , c_attribute7 mtl_serial_numbers.c_attribute7%TYPE
40: , c_attribute8 mtl_serial_numbers.c_attribute8%TYPE
41: , c_attribute9 mtl_serial_numbers.c_attribute9%TYPE
42: , c_attribute10 mtl_serial_numbers.c_attribute10%TYPE
43: , c_attribute11 mtl_serial_numbers.c_attribute11%TYPE
44: , c_attribute12 mtl_serial_numbers.c_attribute12%TYPE
45: , c_attribute13 mtl_serial_numbers.c_attribute13%TYPE
46: , c_attribute14 mtl_serial_numbers.c_attribute14%TYPE
39: , c_attribute7 mtl_serial_numbers.c_attribute7%TYPE
40: , c_attribute8 mtl_serial_numbers.c_attribute8%TYPE
41: , c_attribute9 mtl_serial_numbers.c_attribute9%TYPE
42: , c_attribute10 mtl_serial_numbers.c_attribute10%TYPE
43: , c_attribute11 mtl_serial_numbers.c_attribute11%TYPE
44: , c_attribute12 mtl_serial_numbers.c_attribute12%TYPE
45: , c_attribute13 mtl_serial_numbers.c_attribute13%TYPE
46: , c_attribute14 mtl_serial_numbers.c_attribute14%TYPE
47: , c_attribute15 mtl_serial_numbers.c_attribute15%TYPE
40: , c_attribute8 mtl_serial_numbers.c_attribute8%TYPE
41: , c_attribute9 mtl_serial_numbers.c_attribute9%TYPE
42: , c_attribute10 mtl_serial_numbers.c_attribute10%TYPE
43: , c_attribute11 mtl_serial_numbers.c_attribute11%TYPE
44: , c_attribute12 mtl_serial_numbers.c_attribute12%TYPE
45: , c_attribute13 mtl_serial_numbers.c_attribute13%TYPE
46: , c_attribute14 mtl_serial_numbers.c_attribute14%TYPE
47: , c_attribute15 mtl_serial_numbers.c_attribute15%TYPE
48: , c_attribute16 mtl_serial_numbers.c_attribute16%TYPE
41: , c_attribute9 mtl_serial_numbers.c_attribute9%TYPE
42: , c_attribute10 mtl_serial_numbers.c_attribute10%TYPE
43: , c_attribute11 mtl_serial_numbers.c_attribute11%TYPE
44: , c_attribute12 mtl_serial_numbers.c_attribute12%TYPE
45: , c_attribute13 mtl_serial_numbers.c_attribute13%TYPE
46: , c_attribute14 mtl_serial_numbers.c_attribute14%TYPE
47: , c_attribute15 mtl_serial_numbers.c_attribute15%TYPE
48: , c_attribute16 mtl_serial_numbers.c_attribute16%TYPE
49: , c_attribute17 mtl_serial_numbers.c_attribute17%TYPE
42: , c_attribute10 mtl_serial_numbers.c_attribute10%TYPE
43: , c_attribute11 mtl_serial_numbers.c_attribute11%TYPE
44: , c_attribute12 mtl_serial_numbers.c_attribute12%TYPE
45: , c_attribute13 mtl_serial_numbers.c_attribute13%TYPE
46: , c_attribute14 mtl_serial_numbers.c_attribute14%TYPE
47: , c_attribute15 mtl_serial_numbers.c_attribute15%TYPE
48: , c_attribute16 mtl_serial_numbers.c_attribute16%TYPE
49: , c_attribute17 mtl_serial_numbers.c_attribute17%TYPE
50: , c_attribute18 mtl_serial_numbers.c_attribute18%TYPE
43: , c_attribute11 mtl_serial_numbers.c_attribute11%TYPE
44: , c_attribute12 mtl_serial_numbers.c_attribute12%TYPE
45: , c_attribute13 mtl_serial_numbers.c_attribute13%TYPE
46: , c_attribute14 mtl_serial_numbers.c_attribute14%TYPE
47: , c_attribute15 mtl_serial_numbers.c_attribute15%TYPE
48: , c_attribute16 mtl_serial_numbers.c_attribute16%TYPE
49: , c_attribute17 mtl_serial_numbers.c_attribute17%TYPE
50: , c_attribute18 mtl_serial_numbers.c_attribute18%TYPE
51: , c_attribute19 mtl_serial_numbers.c_attribute19%TYPE
44: , c_attribute12 mtl_serial_numbers.c_attribute12%TYPE
45: , c_attribute13 mtl_serial_numbers.c_attribute13%TYPE
46: , c_attribute14 mtl_serial_numbers.c_attribute14%TYPE
47: , c_attribute15 mtl_serial_numbers.c_attribute15%TYPE
48: , c_attribute16 mtl_serial_numbers.c_attribute16%TYPE
49: , c_attribute17 mtl_serial_numbers.c_attribute17%TYPE
50: , c_attribute18 mtl_serial_numbers.c_attribute18%TYPE
51: , c_attribute19 mtl_serial_numbers.c_attribute19%TYPE
52: , c_attribute20 mtl_serial_numbers.c_attribute20%TYPE
45: , c_attribute13 mtl_serial_numbers.c_attribute13%TYPE
46: , c_attribute14 mtl_serial_numbers.c_attribute14%TYPE
47: , c_attribute15 mtl_serial_numbers.c_attribute15%TYPE
48: , c_attribute16 mtl_serial_numbers.c_attribute16%TYPE
49: , c_attribute17 mtl_serial_numbers.c_attribute17%TYPE
50: , c_attribute18 mtl_serial_numbers.c_attribute18%TYPE
51: , c_attribute19 mtl_serial_numbers.c_attribute19%TYPE
52: , c_attribute20 mtl_serial_numbers.c_attribute20%TYPE
53: , d_attribute1 mtl_serial_numbers.d_attribute1%TYPE
46: , c_attribute14 mtl_serial_numbers.c_attribute14%TYPE
47: , c_attribute15 mtl_serial_numbers.c_attribute15%TYPE
48: , c_attribute16 mtl_serial_numbers.c_attribute16%TYPE
49: , c_attribute17 mtl_serial_numbers.c_attribute17%TYPE
50: , c_attribute18 mtl_serial_numbers.c_attribute18%TYPE
51: , c_attribute19 mtl_serial_numbers.c_attribute19%TYPE
52: , c_attribute20 mtl_serial_numbers.c_attribute20%TYPE
53: , d_attribute1 mtl_serial_numbers.d_attribute1%TYPE
54: , d_attribute2 mtl_serial_numbers.d_attribute2%TYPE
47: , c_attribute15 mtl_serial_numbers.c_attribute15%TYPE
48: , c_attribute16 mtl_serial_numbers.c_attribute16%TYPE
49: , c_attribute17 mtl_serial_numbers.c_attribute17%TYPE
50: , c_attribute18 mtl_serial_numbers.c_attribute18%TYPE
51: , c_attribute19 mtl_serial_numbers.c_attribute19%TYPE
52: , c_attribute20 mtl_serial_numbers.c_attribute20%TYPE
53: , d_attribute1 mtl_serial_numbers.d_attribute1%TYPE
54: , d_attribute2 mtl_serial_numbers.d_attribute2%TYPE
55: , d_attribute3 mtl_serial_numbers.d_attribute3%TYPE
48: , c_attribute16 mtl_serial_numbers.c_attribute16%TYPE
49: , c_attribute17 mtl_serial_numbers.c_attribute17%TYPE
50: , c_attribute18 mtl_serial_numbers.c_attribute18%TYPE
51: , c_attribute19 mtl_serial_numbers.c_attribute19%TYPE
52: , c_attribute20 mtl_serial_numbers.c_attribute20%TYPE
53: , d_attribute1 mtl_serial_numbers.d_attribute1%TYPE
54: , d_attribute2 mtl_serial_numbers.d_attribute2%TYPE
55: , d_attribute3 mtl_serial_numbers.d_attribute3%TYPE
56: , d_attribute4 mtl_serial_numbers.d_attribute4%TYPE
49: , c_attribute17 mtl_serial_numbers.c_attribute17%TYPE
50: , c_attribute18 mtl_serial_numbers.c_attribute18%TYPE
51: , c_attribute19 mtl_serial_numbers.c_attribute19%TYPE
52: , c_attribute20 mtl_serial_numbers.c_attribute20%TYPE
53: , d_attribute1 mtl_serial_numbers.d_attribute1%TYPE
54: , d_attribute2 mtl_serial_numbers.d_attribute2%TYPE
55: , d_attribute3 mtl_serial_numbers.d_attribute3%TYPE
56: , d_attribute4 mtl_serial_numbers.d_attribute4%TYPE
57: , d_attribute5 mtl_serial_numbers.d_attribute5%TYPE
50: , c_attribute18 mtl_serial_numbers.c_attribute18%TYPE
51: , c_attribute19 mtl_serial_numbers.c_attribute19%TYPE
52: , c_attribute20 mtl_serial_numbers.c_attribute20%TYPE
53: , d_attribute1 mtl_serial_numbers.d_attribute1%TYPE
54: , d_attribute2 mtl_serial_numbers.d_attribute2%TYPE
55: , d_attribute3 mtl_serial_numbers.d_attribute3%TYPE
56: , d_attribute4 mtl_serial_numbers.d_attribute4%TYPE
57: , d_attribute5 mtl_serial_numbers.d_attribute5%TYPE
58: , d_attribute6 mtl_serial_numbers.d_attribute6%TYPE
51: , c_attribute19 mtl_serial_numbers.c_attribute19%TYPE
52: , c_attribute20 mtl_serial_numbers.c_attribute20%TYPE
53: , d_attribute1 mtl_serial_numbers.d_attribute1%TYPE
54: , d_attribute2 mtl_serial_numbers.d_attribute2%TYPE
55: , d_attribute3 mtl_serial_numbers.d_attribute3%TYPE
56: , d_attribute4 mtl_serial_numbers.d_attribute4%TYPE
57: , d_attribute5 mtl_serial_numbers.d_attribute5%TYPE
58: , d_attribute6 mtl_serial_numbers.d_attribute6%TYPE
59: , d_attribute7 mtl_serial_numbers.d_attribute7%TYPE
52: , c_attribute20 mtl_serial_numbers.c_attribute20%TYPE
53: , d_attribute1 mtl_serial_numbers.d_attribute1%TYPE
54: , d_attribute2 mtl_serial_numbers.d_attribute2%TYPE
55: , d_attribute3 mtl_serial_numbers.d_attribute3%TYPE
56: , d_attribute4 mtl_serial_numbers.d_attribute4%TYPE
57: , d_attribute5 mtl_serial_numbers.d_attribute5%TYPE
58: , d_attribute6 mtl_serial_numbers.d_attribute6%TYPE
59: , d_attribute7 mtl_serial_numbers.d_attribute7%TYPE
60: , d_attribute8 mtl_serial_numbers.d_attribute8%TYPE
53: , d_attribute1 mtl_serial_numbers.d_attribute1%TYPE
54: , d_attribute2 mtl_serial_numbers.d_attribute2%TYPE
55: , d_attribute3 mtl_serial_numbers.d_attribute3%TYPE
56: , d_attribute4 mtl_serial_numbers.d_attribute4%TYPE
57: , d_attribute5 mtl_serial_numbers.d_attribute5%TYPE
58: , d_attribute6 mtl_serial_numbers.d_attribute6%TYPE
59: , d_attribute7 mtl_serial_numbers.d_attribute7%TYPE
60: , d_attribute8 mtl_serial_numbers.d_attribute8%TYPE
61: , d_attribute9 mtl_serial_numbers.d_attribute9%TYPE
54: , d_attribute2 mtl_serial_numbers.d_attribute2%TYPE
55: , d_attribute3 mtl_serial_numbers.d_attribute3%TYPE
56: , d_attribute4 mtl_serial_numbers.d_attribute4%TYPE
57: , d_attribute5 mtl_serial_numbers.d_attribute5%TYPE
58: , d_attribute6 mtl_serial_numbers.d_attribute6%TYPE
59: , d_attribute7 mtl_serial_numbers.d_attribute7%TYPE
60: , d_attribute8 mtl_serial_numbers.d_attribute8%TYPE
61: , d_attribute9 mtl_serial_numbers.d_attribute9%TYPE
62: , d_attribute10 mtl_serial_numbers.d_attribute10%TYPE
55: , d_attribute3 mtl_serial_numbers.d_attribute3%TYPE
56: , d_attribute4 mtl_serial_numbers.d_attribute4%TYPE
57: , d_attribute5 mtl_serial_numbers.d_attribute5%TYPE
58: , d_attribute6 mtl_serial_numbers.d_attribute6%TYPE
59: , d_attribute7 mtl_serial_numbers.d_attribute7%TYPE
60: , d_attribute8 mtl_serial_numbers.d_attribute8%TYPE
61: , d_attribute9 mtl_serial_numbers.d_attribute9%TYPE
62: , d_attribute10 mtl_serial_numbers.d_attribute10%TYPE
63: , n_attribute1 mtl_serial_numbers.n_attribute1%TYPE
56: , d_attribute4 mtl_serial_numbers.d_attribute4%TYPE
57: , d_attribute5 mtl_serial_numbers.d_attribute5%TYPE
58: , d_attribute6 mtl_serial_numbers.d_attribute6%TYPE
59: , d_attribute7 mtl_serial_numbers.d_attribute7%TYPE
60: , d_attribute8 mtl_serial_numbers.d_attribute8%TYPE
61: , d_attribute9 mtl_serial_numbers.d_attribute9%TYPE
62: , d_attribute10 mtl_serial_numbers.d_attribute10%TYPE
63: , n_attribute1 mtl_serial_numbers.n_attribute1%TYPE
64: , n_attribute2 mtl_serial_numbers.n_attribute2%TYPE
57: , d_attribute5 mtl_serial_numbers.d_attribute5%TYPE
58: , d_attribute6 mtl_serial_numbers.d_attribute6%TYPE
59: , d_attribute7 mtl_serial_numbers.d_attribute7%TYPE
60: , d_attribute8 mtl_serial_numbers.d_attribute8%TYPE
61: , d_attribute9 mtl_serial_numbers.d_attribute9%TYPE
62: , d_attribute10 mtl_serial_numbers.d_attribute10%TYPE
63: , n_attribute1 mtl_serial_numbers.n_attribute1%TYPE
64: , n_attribute2 mtl_serial_numbers.n_attribute2%TYPE
65: , n_attribute3 mtl_serial_numbers.n_attribute3%TYPE
58: , d_attribute6 mtl_serial_numbers.d_attribute6%TYPE
59: , d_attribute7 mtl_serial_numbers.d_attribute7%TYPE
60: , d_attribute8 mtl_serial_numbers.d_attribute8%TYPE
61: , d_attribute9 mtl_serial_numbers.d_attribute9%TYPE
62: , d_attribute10 mtl_serial_numbers.d_attribute10%TYPE
63: , n_attribute1 mtl_serial_numbers.n_attribute1%TYPE
64: , n_attribute2 mtl_serial_numbers.n_attribute2%TYPE
65: , n_attribute3 mtl_serial_numbers.n_attribute3%TYPE
66: , n_attribute4 mtl_serial_numbers.n_attribute4%TYPE
59: , d_attribute7 mtl_serial_numbers.d_attribute7%TYPE
60: , d_attribute8 mtl_serial_numbers.d_attribute8%TYPE
61: , d_attribute9 mtl_serial_numbers.d_attribute9%TYPE
62: , d_attribute10 mtl_serial_numbers.d_attribute10%TYPE
63: , n_attribute1 mtl_serial_numbers.n_attribute1%TYPE
64: , n_attribute2 mtl_serial_numbers.n_attribute2%TYPE
65: , n_attribute3 mtl_serial_numbers.n_attribute3%TYPE
66: , n_attribute4 mtl_serial_numbers.n_attribute4%TYPE
67: , n_attribute5 mtl_serial_numbers.n_attribute5%TYPE
60: , d_attribute8 mtl_serial_numbers.d_attribute8%TYPE
61: , d_attribute9 mtl_serial_numbers.d_attribute9%TYPE
62: , d_attribute10 mtl_serial_numbers.d_attribute10%TYPE
63: , n_attribute1 mtl_serial_numbers.n_attribute1%TYPE
64: , n_attribute2 mtl_serial_numbers.n_attribute2%TYPE
65: , n_attribute3 mtl_serial_numbers.n_attribute3%TYPE
66: , n_attribute4 mtl_serial_numbers.n_attribute4%TYPE
67: , n_attribute5 mtl_serial_numbers.n_attribute5%TYPE
68: , n_attribute6 mtl_serial_numbers.n_attribute6%TYPE
61: , d_attribute9 mtl_serial_numbers.d_attribute9%TYPE
62: , d_attribute10 mtl_serial_numbers.d_attribute10%TYPE
63: , n_attribute1 mtl_serial_numbers.n_attribute1%TYPE
64: , n_attribute2 mtl_serial_numbers.n_attribute2%TYPE
65: , n_attribute3 mtl_serial_numbers.n_attribute3%TYPE
66: , n_attribute4 mtl_serial_numbers.n_attribute4%TYPE
67: , n_attribute5 mtl_serial_numbers.n_attribute5%TYPE
68: , n_attribute6 mtl_serial_numbers.n_attribute6%TYPE
69: , n_attribute7 mtl_serial_numbers.n_attribute7%TYPE
62: , d_attribute10 mtl_serial_numbers.d_attribute10%TYPE
63: , n_attribute1 mtl_serial_numbers.n_attribute1%TYPE
64: , n_attribute2 mtl_serial_numbers.n_attribute2%TYPE
65: , n_attribute3 mtl_serial_numbers.n_attribute3%TYPE
66: , n_attribute4 mtl_serial_numbers.n_attribute4%TYPE
67: , n_attribute5 mtl_serial_numbers.n_attribute5%TYPE
68: , n_attribute6 mtl_serial_numbers.n_attribute6%TYPE
69: , n_attribute7 mtl_serial_numbers.n_attribute7%TYPE
70: , n_attribute8 mtl_serial_numbers.n_attribute8%TYPE
63: , n_attribute1 mtl_serial_numbers.n_attribute1%TYPE
64: , n_attribute2 mtl_serial_numbers.n_attribute2%TYPE
65: , n_attribute3 mtl_serial_numbers.n_attribute3%TYPE
66: , n_attribute4 mtl_serial_numbers.n_attribute4%TYPE
67: , n_attribute5 mtl_serial_numbers.n_attribute5%TYPE
68: , n_attribute6 mtl_serial_numbers.n_attribute6%TYPE
69: , n_attribute7 mtl_serial_numbers.n_attribute7%TYPE
70: , n_attribute8 mtl_serial_numbers.n_attribute8%TYPE
71: , n_attribute9 mtl_serial_numbers.n_attribute9%TYPE
64: , n_attribute2 mtl_serial_numbers.n_attribute2%TYPE
65: , n_attribute3 mtl_serial_numbers.n_attribute3%TYPE
66: , n_attribute4 mtl_serial_numbers.n_attribute4%TYPE
67: , n_attribute5 mtl_serial_numbers.n_attribute5%TYPE
68: , n_attribute6 mtl_serial_numbers.n_attribute6%TYPE
69: , n_attribute7 mtl_serial_numbers.n_attribute7%TYPE
70: , n_attribute8 mtl_serial_numbers.n_attribute8%TYPE
71: , n_attribute9 mtl_serial_numbers.n_attribute9%TYPE
72: , n_attribute10 mtl_serial_numbers.n_attribute10%TYPE
65: , n_attribute3 mtl_serial_numbers.n_attribute3%TYPE
66: , n_attribute4 mtl_serial_numbers.n_attribute4%TYPE
67: , n_attribute5 mtl_serial_numbers.n_attribute5%TYPE
68: , n_attribute6 mtl_serial_numbers.n_attribute6%TYPE
69: , n_attribute7 mtl_serial_numbers.n_attribute7%TYPE
70: , n_attribute8 mtl_serial_numbers.n_attribute8%TYPE
71: , n_attribute9 mtl_serial_numbers.n_attribute9%TYPE
72: , n_attribute10 mtl_serial_numbers.n_attribute10%TYPE
73: );
66: , n_attribute4 mtl_serial_numbers.n_attribute4%TYPE
67: , n_attribute5 mtl_serial_numbers.n_attribute5%TYPE
68: , n_attribute6 mtl_serial_numbers.n_attribute6%TYPE
69: , n_attribute7 mtl_serial_numbers.n_attribute7%TYPE
70: , n_attribute8 mtl_serial_numbers.n_attribute8%TYPE
71: , n_attribute9 mtl_serial_numbers.n_attribute9%TYPE
72: , n_attribute10 mtl_serial_numbers.n_attribute10%TYPE
73: );
74:
67: , n_attribute5 mtl_serial_numbers.n_attribute5%TYPE
68: , n_attribute6 mtl_serial_numbers.n_attribute6%TYPE
69: , n_attribute7 mtl_serial_numbers.n_attribute7%TYPE
70: , n_attribute8 mtl_serial_numbers.n_attribute8%TYPE
71: , n_attribute9 mtl_serial_numbers.n_attribute9%TYPE
72: , n_attribute10 mtl_serial_numbers.n_attribute10%TYPE
73: );
74:
75:
68: , n_attribute6 mtl_serial_numbers.n_attribute6%TYPE
69: , n_attribute7 mtl_serial_numbers.n_attribute7%TYPE
70: , n_attribute8 mtl_serial_numbers.n_attribute8%TYPE
71: , n_attribute9 mtl_serial_numbers.n_attribute9%TYPE
72: , n_attribute10 mtl_serial_numbers.n_attribute10%TYPE
73: );
74:
75:
76: -- Constants and types declaration
2431: CLOSE suggestions_csr;
2432: END IF;
2433: END suggestions_pub;
2434:
2435: /* Local function to insert record in MTL_SERIAL_NUMBERS_TEMP given
2436: * a record type containing the information of one serial number (including
2437: * attributes). This procedure is called from complete_putaway to create
2438: * as many MSNT records for the serial numbers within the LPN for the quantity
2439: * confirmed
2444: , p_serial_atts IN msn_attribute_rec_tp
2445: , p_user_id IN NUMBER
2446: , p_to_serial_number IN VARCHAR2 DEFAULT NULL) RETURN BOOLEAN IS
2447: BEGIN
2448: INSERT INTO mtl_serial_numbers_temp
2449: (
2450: transaction_temp_id
2451: , last_update_date
2452: , last_updated_by
2766: WHEN OTHERS THEN
2767: RETURN FALSE;
2768: END insert_dup_mtlt;
2769:
2770: /* Local function to insert records in MTL_SERIAL_NUMBERS_TEMP
2771: * from the original MSNT record(s). These records are needed by
2772: * the receiving transaction manager for the deliver transaction
2773: */
2774: FUNCTION insert_dup_msnt (
2774: FUNCTION insert_dup_msnt (
2775: p_orig_temp_id IN NUMBER
2776: , p_new_temp_id IN NUMBER) RETURN BOOLEAN IS
2777: BEGIN
2778: INSERT INTO mtl_serial_numbers_temp
2779: (
2780: transaction_temp_id
2781: , last_update_date
2782: , last_updated_by
2907: , n_attribute7
2908: , n_attribute8
2909: , n_attribute9
2910: , n_attribute10
2911: FROM mtl_serial_numbers_temp
2912: WHERE transaction_temp_id = p_orig_temp_id);
2913: RETURN TRUE;
2914: EXCEPTION
2915: WHEN OTHERS THEN
3008: RETURN FALSE;
3009: END insert_mtli_helper;
3010:
3011: /* FP-J Lot/Serial Support Enhancement
3012: * Helper routine to create MTL_SERIAL_NUMBERS_INTERFACE records
3013: * for the serials corresponding to the dropped quantity
3014: * Called for a receiving LPN when INV and PO patch levels are J or higher
3015: */
3016: FUNCTION insert_msni_helper(
3036:
3037: --Get the serial status
3038: SELECT status_id
3039: INTO l_serial_status_id
3040: FROM mtl_serial_numbers
3041: WHERE serial_number = p_serial_number
3042: AND inventory_item_id = p_item_id;
3043:
3044: --Call the insert_msni API
3241: -- Added for Bug 6356147
3242: l_flow_schedule VARCHAR2(1);
3243:
3244: --Bug #2966531 - Fetch serial attributes in addition to serial number
3245: --from MTL_SERIAL_NUMBERS for the LPN item combination
3246: CURSOR ser_csr IS
3247: SELECT serial_number
3248: , serial_number to_serial_number
3249: , vendor_serial_number
3303: , n_attribute7
3304: , n_attribute8
3305: , n_attribute9
3306: , n_attribute10
3307: FROM mtl_serial_numbers
3308: WHERE lpn_id = p_lpn_id
3309: AND inventory_item_id = p_item_id
3310: AND NVL(revision, '#%^') = NVL(p_rev, '#%^')
3311: AND NVL(lot_number, -999) = NVL(p_lot, -999)
3404: n_attribute7 ,
3405: n_attribute8 ,
3406: n_attribute9 ,
3407: n_attribute10
3408: FROM mtl_serial_numbers
3409: WHERE lpn_id = p_lpn_id
3410: AND inventory_item_id = p_item_id
3411: AND NVL(revision, '#%^') = NVL(p_rev, '#%^')
3412: AND NVL(lot_number, -999) = NVL(p_lot, -999)
3513: , n_attribute7
3514: , n_attribute8
3515: , n_attribute9
3516: , n_attribute10
3517: FROM mtl_serial_numbers msn
3518: WHERE msn.lpn_id = p_lpn_id
3519: AND msn.inventory_item_id = p_item_id
3520: AND ((p_rev IS NOT NULL AND msn.revision = p_rev)
3521: OR (p_rev IS NULL AND msn.revision IS NULL))
3594: , n_attribute7
3595: , n_attribute8
3596: , n_attribute9
3597: , n_attribute10
3598: FROM mtl_serial_numbers_interface msni
3599: -- Bug# 3281512 - Performance Fixes
3600: -- Since this cursor is only used for receiving, the product code
3601: -- will always be 'RCV'. This is needed in order to use the index.
3602: WHERE msni.product_code = 'RCV'
3976: --4049874
3977: IF l_serial_code = 6 THEN
3978: SELECT count(1)
3979: INTO l_is_msni_req
3980: FROM mtl_serial_numbers
3981: WHERE inventory_item_id = p_item_id
3982: AND lpn_id = p_lpn_id
3983: AND current_status = 7
3984: AND current_organization_id = p_org_id;
4164: -- ER 7307189 changes start
4165:
4166: SELECT COUNT(msn.group_mark_id)
4167: INTO res_count
4168: FROM mtl_serial_numbers msn ,
4169: mtl_reservations mr
4170: WHERE mr.lpn_id =msn.lpn_id
4171: AND msn.group_mark_id=mr.reservation_id
4172: AND msn.lpn_id = p_lpn_id;
4327: END IF; --END IF check transaction_source_type = 5clear scr
4328: END IF; --END IF p_entire_lpn = 'N'
4329:
4330: /*
4331: * Do not update MTL_SERIAL_NUMBERS from here if the LPN Resides in
4332: * Receiving and WMS and PO patch levels are J or higher
4333: * For other LPN contexts and if patch levels are lower than J,
4334: * continue with the updates
4335: */
4343: mydebug('complete_putaway: INV/WIP LPN. Update MSN.');
4344: END IF;
4345:
4346: -- Update MSN's group_mark_id
4347: UPDATE mtl_serial_numbers
4348: SET group_mark_id = p_temp_id
4349: WHERE serial_number = l_serial
4350: AND inventory_item_id = p_item_id
4351: AND lot_number = p_lot;
4353: -- Bug 2458540
4354: -- Update the Serial Status to 4 before calling Receiving Transaction
4355: -- Processor for RMA serial At SALES ORDER ISSUE STANDARD RECEIPT CASE
4356: IF (l_serial_code = 6 AND l_ref = 'ORDER_LINE_ID') THEN
4357: UPDATE mtl_serial_numbers
4358: SET current_status = 4
4359: , previous_status = current_status
4360: WHERE serial_number = l_serial
4361: AND inventory_item_id = p_item_id
4395: -- ER 7307189 changes start
4396:
4397: SELECT COUNT(msn.group_mark_id)
4398: INTO res_count
4399: FROM mtl_serial_numbers msn ,
4400: mtl_reservations mr
4401: WHERE mr.lpn_id =msn.lpn_id
4402: AND msn.group_mark_id=mr.reservation_id
4403: AND msn.lpn_id = p_lpn_id;
4545: /* Bug 5213359-Added the following check */
4546:
4547: SELECT count(transaction_temp_id)
4548: INTO l_exist_msnt
4549: FROM mtl_serial_numbers_temp
4550: WHERE transaction_temp_id = p_temp_id
4551: AND fm_serial_number = l_serial ;
4552:
4553: mydebug('complete_putaway In patchset J, checking for msnt l_exist_msnt:'|| l_exist_msnt);
4573: END IF; --END IF l_transaction_source_type_id = 5
4574: END IF; --END IF p_entire_lpn = 'N'
4575:
4576: /*
4577: * Do not update MTL_SERIAL_NUMBERS from here if the LPN Resides in
4578: * Receiving and WMS and PO patch levels are J or higher
4579: * For other LPN contexts and if patch levels are lower than J,
4580: * continue with the updates
4581: */
4589: mydebug('complete_putaway: INV/WIP LPN. ');
4590: END IF;
4591:
4592: -- Update MSN's group_mark_id
4593: UPDATE mtl_serial_numbers
4594: SET group_mark_id = p_temp_id
4595: WHERE serial_number = l_serial
4596: AND inventory_item_id = p_item_id;
4597:
4598: -- Bug 2458540
4599: -- Update the Serial Status to 4 before calling Receiving Transaction
4600: -- Processor for RMA serial At SALES ORDER ISSUE STANDARD RECEIPT CASE
4601: IF (l_serial_code = 6 AND l_ref = 'ORDER_LINE_ID') THEN
4602: UPDATE mtl_serial_numbers
4603: SET current_status = 4
4604: , previous_status = current_status
4605: WHERE serial_number = l_serial
4606: AND inventory_item_id = p_item_id;
6296: WHERE transaction_temp_id = l_temp_id;
6297:
6298: -- Delete lot and serial records
6299: BEGIN
6300: DELETE mtl_serial_numbers_temp
6301: WHERE transaction_temp_id = (SELECT serial_transaction_temp_id
6302: FROM mtl_transaction_lots_temp
6303: WHERE transaction_temp_id = l_temp_id);
6304: EXCEPTION
6314: NULL;
6315: END;
6316:
6317: BEGIN
6318: DELETE mtl_serial_numbers_temp
6319: WHERE transaction_temp_id = l_temp_id;
6320: EXCEPTION
6321: WHEN NO_DATA_FOUND THEN
6322: NULL;
6416:
6417: IF p_delete_mmtt_flag = 'Y' THEN
6418: -- Delete lot and serial records
6419: BEGIN
6420: DELETE mtl_serial_numbers_temp
6421: WHERE transaction_temp_id IN
6422: (SELECT serial_transaction_temp_id
6423: FROM mtl_transaction_lots_temp
6424: WHERE transaction_temp_id = l_temp_id);
6437: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6438: END;
6439:
6440: BEGIN
6441: DELETE mtl_serial_numbers_temp
6442: WHERE transaction_temp_id = l_temp_id;
6443: EXCEPTION
6444: WHEN OTHERS THEN
6445: mydebug('archive_task: Error deleting MSNT: ' || sqlerrm);
6523: -- Add cursor to get the serial number(s) for a given MSNT record.
6524: -- SQL compiler complains of a Hash Join otherwise.
6525: CURSOR c_serial_number(v_transaction_temp_id NUMBER) IS
6526: SELECT fm_serial_number
6527: FROM mtl_serial_numbers_temp
6528: WHERE transaction_temp_id = v_transaction_temp_id;
6529: l_fm_serial_number NUMBER;
6530:
6531: BEGIN
6662: LOOP
6663: FETCH c_serial_number INTO l_fm_serial_number;
6664: EXIT WHEN c_serial_number%NOTFOUND;
6665:
6666: UPDATE mtl_serial_numbers
6667: SET group_mark_id = NULL
6668: WHERE serial_number = l_fm_serial_number
6669: AND inventory_item_id = l_item_id
6670: AND current_organization_id = l_org_id;
6686: LOOP
6687: FETCH c_serial_number INTO l_fm_serial_number;
6688: EXIT WHEN c_serial_number%NOTFOUND;
6689:
6690: UPDATE mtl_serial_numbers
6691: SET group_mark_id = NULL
6692: WHERE serial_number = l_fm_serial_number
6693: AND inventory_item_id = l_item_id
6694: AND current_organization_id = l_org_id;
6717: LOOP
6718: FETCH c_serial_number INTO l_fm_serial_number;
6719: EXIT WHEN c_serial_number%NOTFOUND;
6720:
6721: UPDATE mtl_serial_numbers
6722: SET current_status = 5,
6723: previous_status = NULL
6724: WHERE serial_number = l_fm_serial_number
6725: AND inventory_item_id = l_item_id
6747: LOOP
6748: FETCH c_serial_number INTO l_fm_serial_number;
6749: EXIT WHEN c_serial_number%NOTFOUND;
6750:
6751: UPDATE mtl_serial_numbers
6752: SET current_status = 5,
6753: previous_status = NULL
6754: WHERE serial_number = l_fm_serial_number
6755: AND inventory_item_id = l_item_id
7131: WHERE transaction_temp_id = l_temp_id;
7132:
7133: CURSOR ser_csr IS
7134: SELECT serial_number
7135: FROM mtl_serial_numbers
7136: WHERE lpn_id = l_lpn_id
7137: AND inventory_item_id = l_item_id
7138: AND current_organization_id = l_org_id
7139: AND NVL(lot_number, -999) = NVL(l_lot_number, -999);
8679: AND lpn_id = p_lpn_id;
8680:
8681: CURSOR l_serial_cursor IS
8682: SELECT serial_number
8683: FROM mtl_serial_numbers
8684: WHERE inventory_item_id = l_item_id
8685: AND current_organization_id = p_organization_id
8686: AND lpn_id = p_lpn_id;
8687: