APPS.INV_ROI_INTEGRATION_GRP dependencies on RCV_TRANSACTIONS

Line 200: FROM rcv_transactions

196: fetching the earlier received quantity for that lot.*/
197: /*
198: CURSOR Cr_rcv_qty IS
199: SELECT primary_quantity , primary_unit_of_measure
200: FROM rcv_transactions
201: WHERE transaction_id = l_parent_trx_id ;
202: /*
203: AND transaction_type 'DELIVER'
204: AND source_document_code IN ('PO','RMA')

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 617: FROM rcv_transactions WHERE transaction_id = l_parent_transaction_id;

613: IF l_parent_transaction_id IS NOT NULL OR l_parent_transaction_id <> -1 THEN
614: print_debug('Get parent transaction details ' , 1);
615: SELECT transaction_type, destination_type_code
616: INTO l_parent_transaction_type, l_parent_destination_type_code
617: FROM rcv_transactions WHERE transaction_id = l_parent_transaction_id;
618: END IF;
619:
620: IF ( (l_transaction_type = 'DELIVER' AND l_destination_type_code = 'INVENTORY') OR
621: (l_transaction_type = 'RECEIVE' AND l_auto_transact_code = 'DELIVER' AND l_destination_type_code = 'INVENTORY') OR

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