DBA Data[Home] [Help]

APPS.INV_ROI_INTEGRATION_GRP dependencies on RCV_TRANSACTIONS_INTERFACE

Line 609: FROM rcv_transactions_interface

605: IF p_rti_id IS NOT NULL THEN
606: print_debug('Get transaction details ' , 1);
607: SELECT transaction_type, destination_type_code, auto_transact_code, parent_transaction_id
608: INTO l_transaction_type, l_destination_type_code, l_auto_transact_code, l_parent_transaction_id
609: FROM rcv_transactions_interface
610: WHERE interface_transaction_id = p_rti_id;
611: END IF;
612:
613: IF l_parent_transaction_id IS NOT NULL OR l_parent_transaction_id <> -1 THEN

Line 803: FROM RCV_TRANSACTIONS_INTERFACE

799:
800: ------------------fetching PARENT_TRANSACTION_ID
801: SELECT PARENT_TRANSACTION_ID
802: INTO l_parent_trx_id
803: FROM RCV_TRANSACTIONS_INTERFACE
804: WHERE INTERFACE_TRANSACTION_ID = p_rti_id;
805:
806: IF l_parent_trx_id IS NULL THEN
807: IF g_debug = 1 THEN