APPS.INV_ROI_INTEGRATION_GRP dependencies on RCV_TRANSACTIONS

Line 196: FROM rcv_transactions

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

Line 573: FROM rcv_transactions_interface

569: IF p_rti_id IS NOT NULL THEN
570: print_debug('Get transaction details ' , 1);
571: SELECT transaction_type, destination_type_code, auto_transact_code, parent_transaction_id
572: INTO l_transaction_type, l_destination_type_code, l_auto_transact_code, l_parent_transaction_id
573: FROM rcv_transactions_interface
574: WHERE interface_transaction_id = p_rti_id;
575: END IF;
576:
577: IF l_parent_transaction_id IS NOT NULL OR l_parent_transaction_id <> -1 THEN

Line 581: FROM rcv_transactions WHERE transaction_id = l_parent_transaction_id;

577: IF l_parent_transaction_id IS NOT NULL OR l_parent_transaction_id <> -1 THEN
578: print_debug('Get parent transaction details ' , 1);
579: SELECT transaction_type, destination_type_code
580: INTO l_parent_transaction_type, l_parent_destination_type_code
581: FROM rcv_transactions WHERE transaction_id = l_parent_transaction_id;
582: END IF;
583:
584: IF ( (l_transaction_type = 'DELIVER' AND l_destination_type_code = 'INVENTORY') OR
585: (l_transaction_type = 'RECEIVE' AND l_auto_transact_code = 'DELIVER' AND l_destination_type_code = 'INVENTORY') OR

Line 767: FROM RCV_TRANSACTIONS_INTERFACE

763:
764: ------------------fetching PARENT_TRANSACTION_ID
765: SELECT PARENT_TRANSACTION_ID
766: INTO l_parent_trx_id
767: FROM RCV_TRANSACTIONS_INTERFACE
768: WHERE INTERFACE_TRANSACTION_ID = p_rti_id;
769:
770: IF l_parent_trx_id IS NULL THEN
771: IF g_debug = 1 THEN