APPS.INV_LOT_TRX_VALIDATION_PVT dependencies on MTL_SERIAL_NUMBERS

Line 284: FROM mtl_serial_numbers_interface

280: CURSOR msni_csr (p_serial_transaction_temp_id IN NUMBER)
281: IS
282: SELECT fm_serial_number
283: , NVL (to_serial_number, fm_serial_number) to_serial_number
284: FROM mtl_serial_numbers_interface
285: WHERE transaction_interface_id = p_serial_transaction_temp_id;
286:
287: l_ser_csr msni_csr%ROWTYPE;
288:

Line 298: FROM mtl_serial_numbers

294: )
295: IS
296: SELECT group_mark_id
297: , status_id
298: FROM mtl_serial_numbers
299: WHERE serial_number = p_serial_number
300: AND current_organization_id = p_organization_id
301: AND inventory_item_id = p_inventory_item_id;
302:

Line 317: FROM mtl_serial_numbers

313: )
314: IS
315: SELECT group_mark_id
316: , status_id
317: FROM mtl_serial_numbers
318: WHERE serial_number = p_serial_number
319: AND current_organization_id = p_organization_id
320: AND inventory_item_id = p_inventory_item_id
321: AND lot_number = p_lot_number

Line 347: FROM mtl_serial_numbers

343: IS
344: SELECT serial_number
345: , status_id
346: , group_mark_id
347: FROM mtl_serial_numbers
348: WHERE lot_number = p_lot_number
349: AND current_organization_id = p_organization_id
350: AND inventory_item_id = p_inventory_item_id
351: AND current_subinventory_code = p_subinventory_code

Line 1120: *mtl_Serial_numbers table.

1116: l_st_ser_group_mark_id_tbl.EXTEND (1);
1117: l_st_ser_group_mark_id_tbl (l_st_ser_index) := l_ser_msn_csr.group_mark_id;
1118: /*Resulting serial array is also populated using the source record.
1119: *as the resulting item, lot combination may not be present in the
1120: *mtl_Serial_numbers table.
1121: */
1122: l_rs_ser_index := l_rs_ser_index + 1;
1123: l_rs_ser_number_tbl (l_ser_msn_csr.serial_number) := l_ser_msn_csr.serial_number;
1124: l_rs_ser_parent_lot_tbl (l_ser_msn_csr.serial_number) := l_lot_csr.lot_number;