APPS.OE_RMA_RECEIVING dependencies on RCV_TRANSACTIONS

Line 381: FROM rcv_transactions

377: --set the actual shipment date on the RMA line
378:
379: SELECT MAX(transaction_date)
380: INTO l_line_tbl(1).actual_shipment_date
381: FROM rcv_transactions
382: WHERE transaction_type = 'RECEIVE'
383: AND oe_order_line_id = l_line_tbl(1).line_id;
384:
385: IF l_line_tbl(1).actual_shipment_date IS NULL THEN

Line 993: FROM rcv_transactions

989: -- We will need to look at UNORDERED transaction to figure out
990: -- the actual shipment date.
991: SELECT MAX(transaction_date)
992: INTO l_line_tbl(1).actual_shipment_date
993: FROM rcv_transactions
994: WHERE transaction_type = 'UNORDERED'
995: AND oe_order_line_id = l_line_tbl(1).line_id;
996:
997: IF l_line_tbl(1).actual_shipment_date IS NULL THEN