APPS.OPI_DBI_INV_VALUE_INCR_PKG dependencies on OPI_DBI_CONVERSION_RATES

Line 1231: (SELECT /*+ index (rate OPI_DBI_CONVERSION_RATES_N2) */

1227: END IF;
1228:
1229: MERGE INTO OPI_DBI_INV_VALUE_F base
1230: USING
1231: (SELECT /*+ index (rate OPI_DBI_CONVERSION_RATES_N2) */
1232: NULL operating_unit,
1233: s.organization_id,
1234: s.subinventory_code,
1235: s.inventory_item_id,

Line 1342: from opi_dbi_conversion_rates

1338: organization_id,
1339: transaction_date,
1340: conversion_rate,
1341: sec_conversion_rate
1342: from opi_dbi_conversion_rates
1343: ) rate
1344: where s.organization_id = rate.organization_id
1345: and s.transaction_date = rate.transaction_date
1346: ) stg