DBA Data[Home] [Help]

APPS.INV_MGD_MVT_STATS_PVT dependencies on RCV_TRANSACTIONS

Line 2877: FROM rcv_transactions

2873: AND transaction_date BETWEEN TRUNC(p_start_date -1)
2874: AND TRUNC(p_end_date +1)
2875: AND rcv_transaction_id
2876: IN (SELECT parent_transaction_id
2877: FROM rcv_transactions
2878: WHERE mvt_stat_status = 'NEW'
2879: AND transaction_type = 'CORRECT')
2880: ORDER BY mtl_stats.movement_id;
2881: