DBA Data[Home] [Help]

APPS.OE_RMA_RECEIVING dependencies on RCV_TRANSACTIONS

Line 415: FROM rcv_transactions

411: --set the actual shipment date on the RMA line
412:
413: SELECT MAX(transaction_date)
414: INTO l_line_tbl(1).actual_shipment_date
415: FROM rcv_transactions
416: WHERE transaction_type = 'RECEIVE'
417: AND oe_order_line_id = l_line_tbl(1).line_id;
418:
419: IF l_line_tbl(1).actual_shipment_date IS NULL THEN

Line 1049: FROM rcv_transactions

1045: -- We will need to look at UNORDERED transaction to figure out
1046: -- the actual shipment date.
1047: SELECT MAX(transaction_date)
1048: INTO l_line_tbl(1).actual_shipment_date
1049: FROM rcv_transactions
1050: WHERE transaction_type = 'UNORDERED'
1051: AND oe_order_line_id = l_line_tbl(1).line_id;
1052:
1053: IF l_line_tbl(1).actual_shipment_date IS NULL THEN