DBA Data[Home] [Help]

APPS.WSH_DELIVERY_VALIDATIONS dependencies on MTL_SERIAL_NUMBERS_TEMP

Line 2816: from MTL_SERIAL_NUMBERS_TEMP

2812:
2813: /************************MATERIAL STATUS CONTROL ********/
2814: CURSOR C_GET_SERIAL (l_transaction_temp_id NUMBER) IS
2815: SELECT fm_serial_number,nvl(to_serial_number,fm_serial_number)
2816: from MTL_SERIAL_NUMBERS_TEMP
2817: where transaction_temp_id = l_transaction_temp_id;
2818:
2819: l_prefix VARCHAR2(10);
2820: l_result BOOLEAN;