DBA Data[Home] [Help]

APPS.WSH_DELIVERY_VALIDATIONS dependencies on MTL_SERIAL_NUMBERS_TEMP

Line 2856: from MTL_SERIAL_NUMBERS_TEMP

2852:
2853: /************************MATERIAL STATUS CONTROL ********/
2854: CURSOR C_GET_SERIAL (l_transaction_temp_id NUMBER) IS
2855: SELECT fm_serial_number,nvl(to_serial_number,fm_serial_number)
2856: from MTL_SERIAL_NUMBERS_TEMP
2857: where transaction_temp_id = l_transaction_temp_id;
2858:
2859: l_prefix VARCHAR2(10);
2860: l_result BOOLEAN;