APPS.CSE_PO_RECEIPT_INTO_PROJECT dependencies on MTL_SERIAL_NUMBERS

Line 75: DELETE FROM mtl_serial_numbers_temp

71: INTO l_interface_transaction_id
72: FROM rcv_transactions
73: WHERE transaction_id = p_rcv_transaction_id;
74:
75: DELETE FROM mtl_serial_numbers_temp
76: WHERE transaction_temp_id = l_interface_transaction_id;
77:
78: DELETE FROM mtl_transaction_lots_temp
79: WHERE transaction_temp_id = l_interface_transaction_id;

Line 511: UPDATE mtl_serial_numbers

507: END IF;
508:
509: BEGIN
510: IF x_rcv_txn_tbl(i).serial_number IS NOT NULL THEN
511: UPDATE mtl_serial_numbers
512: SET current_status = 4,
513: last_txn_source_name = 'CSE_PO_RECEIPT',
514: last_txn_source_id = x_rcv_txn_tbl(i).rcv_transaction_id
515: WHERE inventory_item_id = x_rcv_txn_tbl(i).inventory_item_id

Line 593: mtl_serial_numbers msn

589: SELECT mtlt.lot_number lot_number,
590: msn.serial_number serial_number,
591: decode(mtlt.serial_transaction_temp_id,null,nvl(mtlt.transaction_quantity,p_quantity),1) quantity
592: FROM mtl_transaction_lots_temp mtlt,
593: mtl_serial_numbers msn
594: WHERE mtlt.transaction_temp_id = p_interface_transaction_id
595: AND msn.line_mark_id(+) = mtlt.serial_transaction_temp_id;
596:
597: CURSOR srl_cur(p_interface_transaction_id in number) IS

Line 599: FROM mtl_serial_numbers msn

595: AND msn.line_mark_id(+) = mtlt.serial_transaction_temp_id;
596:
597: CURSOR srl_cur(p_interface_transaction_id in number) IS
598: SELECT msn.serial_number serial_number
599: FROM mtl_serial_numbers msn
600: WHERE EXISTS (
601: SELECT 'x' FROM mtl_serial_numbers_temp msnt
602: WHERE msnt.transaction_temp_id = p_interface_transaction_id
603: AND msnt.transaction_temp_id = msn.line_mark_id) ;

Line 601: SELECT 'x' FROM mtl_serial_numbers_temp msnt

597: CURSOR srl_cur(p_interface_transaction_id in number) IS
598: SELECT msn.serial_number serial_number
599: FROM mtl_serial_numbers msn
600: WHERE EXISTS (
601: SELECT 'x' FROM mtl_serial_numbers_temp msnt
602: WHERE msnt.transaction_temp_id = p_interface_transaction_id
603: AND msnt.transaction_temp_id = msn.line_mark_id) ;
604:
605: BEGIN