DBA Data[Home] [Help]

APPS.AMV_STOCK_PVT dependencies on AMV_STOCK_PRICE

Line 524: , amv_stock_price amsp

520: , amst.stock_desc
521: , amsp.stock_price
522: , amsp.change
523: from amv_stocks amst
524: , amv_stock_price amsp
525: where amst.stock_ric = amsp.stock_ric(+)
526: and amst.stock_id = l_stock_id
527: order by amsp.time_stamp desc;
528:

Line 767: , amv_stock_price amsp

763: , amst.stock_desc
764: , amsp.stock_price
765: , amsp.change
766: from amv_stocks amst
767: , amv_stock_price amsp
768: where amst.stock_symbol = l_stock_symbol
769: and amst.stock_ric = amsp.stock_ric(+)
770: order by amsp.time_stamp desc;
771: --