eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AMV_STOCK_PVT dependencies on AMV_VENDOR_KEYS

Line 1158: from amv_vendor_keys b

1154: from amv_stocks a
1155: where a.stock_id > p_start_index
1156: minus
1157: select b.stock_id
1158: from amv_vendor_keys b
1159: where b.vendor_id = p_vendor_id
1160: order by 1;
1161:
1162: CURSOR Get_StocksInfo_csr IS

Line 1326: select amv_vendor_keys_s.nextval

1322: l_miss_rec number := 0;
1323: l_object_version_number number := 1;
1324:
1325: CURSOR VendorKeyId_seq IS
1326: select amv_vendor_keys_s.nextval
1327: from dual;
1328: --
1329: BEGIN
1330: -- Standard begin of API savepoint

Line 1364: INSERT INTO amv_vendor_keys(

1360: FETCH VendorKeyId_seq INTO l_vendor_key_id;
1361: CLOSE VendorKeyId_seq;
1362:
1363: BEGIN
1364: INSERT INTO amv_vendor_keys(
1365: vendor_key_id,
1366: object_version_number,
1367: last_update_date,
1368: last_updated_by,

Line 1516: from amv_vendor_keys amvk

1512: l_symbols_array amv_char_varray_type;
1513:
1514: CURSOR Get_UserKeys_csr IS
1515: select distinct amvk.vendor_key
1516: from amv_vendor_keys amvk
1517: , amv_user_ticker amut
1518: where amut.stock_id = amvk.stock_id
1519: and amvk.vendor_id = p_vendor_id;
1520:

Line 1523: from amv_vendor_keys amvk

1519: and amvk.vendor_id = p_vendor_id;
1520:
1521: CURSOR Get_SymKeys_csr IS
1522: select amvk.vendor_key
1523: from amv_vendor_keys amvk
1524: , amv_stocks amst
1525: where amst.stock_symbol = l_stock_symbol
1526: and amst.stock_id = amvk.stock_id;
1527:

Line 1530: from amv_vendor_keys amvk

1526: and amst.stock_id = amvk.stock_id;
1527:
1528: CURSOR Get_AllKeys_csr IS
1529: select distinct amvk.vendor_key
1530: from amv_vendor_keys amvk
1531: where amvk.vendor_id = p_vendor_id;
1532: --
1533: BEGIN
1534: -- Standard begin of API savepoint

Line 1710: from amv_vendor_keys

1706: l_object_version_number number := 1;
1707:
1708: CURSOR Get_VendorKeyId_csr IS
1709: select vendor_key_id
1710: from amv_vendor_keys
1711: where vendor_id = p_vendor_id
1712: and vendor_key = l_key_id;
1713:
1714: CURSOR NewsId_seq IS

Line 1915: , amv_vendor_keys v

1911: , n.news_title
1912: , n.provider
1913: , n.date_time
1914: from amv_news n
1915: , amv_vendor_keys v
1916: where v.stock_id = p_stock_id
1917: and v.vendor_key_id = n.vendor_key_id
1918: order by n.date_time desc;
1919: