APPS.WMS_TXNRSN_ACTIONS_PUB dependencies on MTL_SERIAL_NUMBERS

Line 512: FROM mtl_serial_numbers_temp msnt

508: CURSOR c_fm_to_serial_number IS
509: SELECT
510: msnt.fm_serial_number,
511: msnt.to_serial_number
512: FROM mtl_serial_numbers_temp msnt
513: WHERE msnt.transaction_temp_id = p_mmtt_id;
514:
515: CURSOR c_fm_to_lot_serial_number IS
516: SELECT

Line 520: mtl_serial_numbers_temp msnt,

516: SELECT
517: msnt.fm_serial_number,
518: msnt.to_serial_number
519: FROM
520: mtl_serial_numbers_temp msnt,
521: mtl_transaction_lots_temp mtlt
522: WHERE mtlt.transaction_temp_id = p_mmtt_id
523: AND msnt.transaction_temp_id = mtlt.serial_transaction_temp_id;
524:

Line 781: ,mtl_serial_numbers_temp msnt

777: begin
778: select count(*)
779: into l_msnt_cnt
780: from mtl_transaction_lots_temp mtlt
781: ,mtl_serial_numbers_temp msnt
782: where mtlt.transaction_temp_id = l_mmtt_id
783: and mtlt.serial_transaction_temp_id = msnt.transaction_temp_id;
784:
785: mdebug('l_msnt_cnt:'||l_msnt_cnt);

Line 798: from mtl_serial_numbers_temp msnt

794: if l_serial_control_code NOT IN (1,6) then -- serial controlled
795: begin
796: select count(*)
797: into l_msnt_cnt
798: from mtl_serial_numbers_temp msnt
799: where transaction_temp_id = l_mmtt_id;
800:
801: mdebug('l_msnt_cnt:'||l_msnt_cnt);
802: exception

Line 841: UPDATE mtl_serial_numbers

837: EXIT WHEN c_fm_to_lot_serial_number%NOTFOUND;
838:
839: mdebug('within loop before update msn for from serial_number:'||l_fm_serial_number);
840:
841: UPDATE mtl_serial_numbers
842: SET group_mark_id = NULL
843: WHERE inventory_item_id = l_item_id
844: AND current_organization_id = l_organization_id
845: AND serial_number BETWEEN l_fm_serial_number AND l_to_serial_number;

Line 854: DELETE FROM mtl_serial_numbers_temp msnt

850: CLOSE c_fm_to_lot_serial_number;
851:
852: mdebug('before delete msnt');
853:
854: DELETE FROM mtl_serial_numbers_temp msnt
855: WHERE msnt.transaction_temp_id IN
856: (SELECT mtlt.serial_transaction_temp_id
857: FROM mtl_transaction_lots_temp mtlt
858: WHERE mtlt.transaction_temp_id = l_mmtt_id);

Line 891: UPDATE mtl_serial_numbers

887: FETCH c_fm_to_serial_number
888: INTO l_fm_serial_number,l_to_serial_number;
889: EXIT WHEN c_fm_to_serial_number%NOTFOUND;
890:
891: UPDATE mtl_serial_numbers
892: SET group_mark_id = NULL
893: WHERE inventory_item_id = l_item_id
894: AND current_organization_id = l_organization_id
895: AND serial_number BETWEEN l_fm_serial_number AND l_to_serial_number;

Line 900: DELETE FROM mtl_serial_numbers_temp msnt

896:
897: END LOOP;
898: CLOSE c_fm_to_serial_number;
899:
900: DELETE FROM mtl_serial_numbers_temp msnt
901: WHERE msnt.transaction_temp_id = l_mmtt_id;
902:
903: END IF;
904: