APPS.INV_LABEL_PVT8 dependencies on WSH_SERIAL_NUMBERS

Line 1391: CURSOR c_wsh_serial_numbers(p_delivery_detail_id number)

1387: WHERE oeoh.header_id = p_header_id;
1388:
1389: -- Bug 9261874, Cursor defined to fetch serial information from WSN or MSNT or WDD
1390:
1391: CURSOR c_wsh_serial_numbers(p_delivery_detail_id number)
1392: IS
1393: SELECT FM_SERIAL_NUMBER
1394: , TO_SERIAL_NUMBER
1395: FROM wsh_serial_numbers

Line 1395: FROM wsh_serial_numbers

1391: CURSOR c_wsh_serial_numbers(p_delivery_detail_id number)
1392: IS
1393: SELECT FM_SERIAL_NUMBER
1394: , TO_SERIAL_NUMBER
1395: FROM wsh_serial_numbers
1396: WHERE delivery_detail_id = p_delivery_detail_id
1397:
1398: UNION
1399:

Line 2406: FOR v_wsh_serial_numbers IN c_wsh_serial_numbers(l_wdd_id_list(i))

2402: -- loop started to stack all the serials.
2403: --Bug9462735, added loop for consolidated wdd record
2404: FOR i IN 1..l_consolidation_counter LOOP
2405:
2406: FOR v_wsh_serial_numbers IN c_wsh_serial_numbers(l_wdd_id_list(i))
2407: LOOP
2408:
2409: l_fm_serial_number := v_wsh_serial_numbers.FM_SERIAL_NUMBER ;
2410: l_to_serial_number := v_wsh_serial_numbers.TO_SERIAL_NUMBER ;

Line 2409: l_fm_serial_number := v_wsh_serial_numbers.FM_SERIAL_NUMBER ;

2405:
2406: FOR v_wsh_serial_numbers IN c_wsh_serial_numbers(l_wdd_id_list(i))
2407: LOOP
2408:
2409: l_fm_serial_number := v_wsh_serial_numbers.FM_SERIAL_NUMBER ;
2410: l_to_serial_number := v_wsh_serial_numbers.TO_SERIAL_NUMBER ;
2411:
2412: IF (l_debug = 1) THEN
2413: trace('l_fm_serial_number, l_to_serial_number' ||l_fm_serial_number || ', ' || l_to_serial_number);

Line 2410: l_to_serial_number := v_wsh_serial_numbers.TO_SERIAL_NUMBER ;

2406: FOR v_wsh_serial_numbers IN c_wsh_serial_numbers(l_wdd_id_list(i))
2407: LOOP
2408:
2409: l_fm_serial_number := v_wsh_serial_numbers.FM_SERIAL_NUMBER ;
2410: l_to_serial_number := v_wsh_serial_numbers.TO_SERIAL_NUMBER ;
2411:
2412: IF (l_debug = 1) THEN
2413: trace('l_fm_serial_number, l_to_serial_number' ||l_fm_serial_number || ', ' || l_to_serial_number);
2414: END IF;