APPS.CSE_PO_RECEIPT_INTO_PROJECT dependencies on RCV_TRANSACTIONS

Line 72: FROM rcv_transactions

68: BEGIN
69:
70: SELECT interface_transaction_id
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;

Line 577: FROM rcv_transactions rt,

573: pla.item_id item_id,
574: pla.item_revision item_revision,
575: to_char(pla.line_num) po_line_number,
576: pha.segment1 po_number
577: FROM rcv_transactions rt,
578: po_distributions_all pda,
579: po_line_locations_all plla,
580: po_lines_all pla,
581: po_headers_all pha

Line 726: UPDATE rcv_transactions

722: 'SET pa_addition_flag = ''Y'''||
723: 'WHERE rcv_transaction_id = :rcv_txn_id ';
724: BEGIN
725: execute immediate l_sql_stmt using p_rcv_transaction_id;
726: UPDATE rcv_transactions
727: SET pa_addition_flag = 'Y'
728: WHERE transaction_id = p_rcv_transaction_id;
729: EXCEPTION
730: WHEN others THEN

Line 731: UPDATE rcv_transactions

727: SET pa_addition_flag = 'Y'
728: WHERE transaction_id = p_rcv_transaction_id;
729: EXCEPTION
730: WHEN others THEN
731: UPDATE rcv_transactions
732: SET pa_addition_flag = 'Y'
733: WHERE transaction_id = p_rcv_transaction_id;
734: END;
735: