DBA Data[Home] [Help]

APPS.INV_MGD_MVT_STATS_PVT dependencies on RCV_TRANSACTIONS

Line 2837: FROM rcv_transactions

2833: AND transaction_date BETWEEN TRUNC(p_start_date -1)
2834: AND TRUNC(p_end_date +1)
2835: AND rcv_transaction_id
2836: IN (SELECT parent_transaction_id
2837: FROM rcv_transactions
2838: WHERE mvt_stat_status = 'NEW'
2839: AND transaction_type = 'CORRECT')
2840: ORDER BY mtl_stats.movement_id;
2841: