APPS.WMS_TXNRSN_ACTIONS_PUB dependencies on MTL_SERIAL_NUMBERS_TEMP

Line 527: FROM mtl_serial_numbers_temp msnt

523: CURSOR c_fm_to_serial_number IS
524: SELECT
525: msnt.fm_serial_number,
526: msnt.to_serial_number
527: FROM mtl_serial_numbers_temp msnt
528: WHERE msnt.transaction_temp_id = p_mmtt_id;
529:
530: CURSOR c_fm_to_lot_serial_number IS
531: SELECT

Line 535: mtl_serial_numbers_temp msnt,

531: SELECT
532: msnt.fm_serial_number,
533: msnt.to_serial_number
534: FROM
535: mtl_serial_numbers_temp msnt,
536: mtl_transaction_lots_temp mtlt
537: WHERE mtlt.transaction_temp_id = p_mmtt_id
538: AND msnt.transaction_temp_id = mtlt.serial_transaction_temp_id;
539:

Line 875: ,mtl_serial_numbers_temp msnt

871: BEGIN
872: SELECT COUNT(*)
873: INTO l_msnt_cnt
874: FROM mtl_transaction_lots_temp mtlt
875: ,mtl_serial_numbers_temp msnt
876: WHERE mtlt.transaction_temp_id = l_mmtt_id
877: AND mtlt.serial_transaction_temp_id = msnt.transaction_temp_id;
878:
879: mdebug('l_msnt_cnt:'||l_msnt_cnt);

Line 892: FROM mtl_serial_numbers_temp msnt

888: IF l_serial_control_code NOT IN (1,6) THEN --{serial controlled
889: BEGIN
890: SELECT COUNT(*)
891: INTO l_msnt_cnt
892: FROM mtl_serial_numbers_temp msnt
893: WHERE transaction_temp_id = l_mmtt_id;
894:
895: mdebug('l_msnt_cnt:'||l_msnt_cnt);
896: EXCEPTION

Line 941: DELETE FROM mtl_serial_numbers_temp msnt

937: CLOSE c_fm_to_lot_serial_number;
938:
939: mdebug('before delete msnt');
940:
941: DELETE FROM mtl_serial_numbers_temp msnt
942: WHERE msnt.transaction_temp_id IN
943: (SELECT mtlt.serial_transaction_temp_id
944: FROM mtl_transaction_lots_temp mtlt
945: WHERE mtlt.transaction_temp_id = l_mmtt_id);

Line 987: DELETE FROM mtl_serial_numbers_temp msnt

983:
984: END LOOP;
985: CLOSE c_fm_to_serial_number;
986:
987: DELETE FROM mtl_serial_numbers_temp msnt
988: WHERE msnt.transaction_temp_id = l_mmtt_id;
989:
990: END IF; --}
991:

Line 2132: SELECT 1 FROM MTL_SERIAL_NUMBERS_TEMP MSNT

2128: AND mmtt.parent_line_id IS NULL -- Bug# 5760606 - add condition so only non bulk tasks are considered
2129: -- without the condition curtail pick for bulk pick will fail since this cursor picks up child mmtt lines
2130: AND mmtt.item_lot_control_code = 1
2131: AND NOT EXISTS( /*Bug8304954-If no serial allocation, we should cleanup(only for non-lot case) */
2132: SELECT 1 FROM MTL_SERIAL_NUMBERS_TEMP MSNT
2133: WHERE MSNT.TRANSACTION_TEMP_ID= mmtt.transaction_temp_id --Should not have serials allocated.
2134: )
2135: AND NOT EXISTS (
2136: SELECT 1 FROM wms_dispatched_tasks