DBA Data[Home] [Help]

APPS.INV_MO_LINE_DETAIL_UTIL dependencies on INV_SERIAL_NUMBER_PUB

Line 2807: SELECT SUM(inv_serial_number_pub.get_serial_diff(msnt.fm_serial_number, msnt.to_serial_number))

2803: ) IS
2804: l_procedure_name VARCHAR2(30) := 'GET_SERIAL_QUANTITY';
2805:
2806: CURSOR serial_records IS
2807: SELECT SUM(inv_serial_number_pub.get_serial_diff(msnt.fm_serial_number, msnt.to_serial_number))
2808: FROM mtl_serial_numbers_temp msnt
2809: WHERE msnt.transaction_temp_id = p_transaction_temp_id;
2810:
2811: l_serial_quantity NUMBER := 0;