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.OPI_EDW_INV_DAILY_STAT_F_SZ dependencies on MTL_MATERIAL_TRANSACTIONS

Line 11: FROM mtl_material_transactions mmt

7:
8:
9: CURSOR mmt_cnt_rows IS
10: SELECT count(*)
11: FROM mtl_material_transactions mmt
12: WHERE transaction_date >= p_from_date
13: AND transaction_date <= p_to_Date
14: GROUP BY trunc(mmt.TRANSACTION_DATE),mmt.ORGANIZATION_ID,mmt.INVENTORY_ITEM_ID,
15: mmt.COST_GROUP_ID,mmt.REVISION,mmt.SUBINVENTORY_CODE,mmt.locator_id;

Line 196: from mtl_material_transactions mmt

192: avg(nvl(vsize(mmt.INVENTORY_ITEM_ID||mmt.ORGANIZATION_ID),0)),
193: avg(nvl(vsize(mmt.ORGANIZATION_ID),0)),
194: avg(nvl(vsize(mmt.LOCATOR_ID||mmt.SUBINVENTORY_CODE||mmt.ORGANIZATION_ID),0)),
195: avg(nvl(vsize(sum(primary_quantity)),0))
196: from mtl_material_transactions mmt
197: where transaction_date between p_from_date and p_to_date
198: GROUP BY trunc(mmt.TRANSACTION_DATE),mmt.ORGANIZATION_ID,mmt.INVENTORY_ITEM_ID,
199: mmt.COST_GROUP_ID,mmt.REVISION,mmt.SUBINVENTORY_CODE,mmt.locator_id;
200:

Line 205: FROM MTL_MATERIAL_TRANSACTIONS mmt,

201:
202: cursor c_2 is
203: SELECT
204: avg(nvl(vsize(sum(mta.BASE_TRANSACTION_VALUE)),0))
205: FROM MTL_MATERIAL_TRANSACTIONS mmt,
206: MTL_TRANSACTION_ACCOUNTS mta
207: WHERE mmt.transaction_id = mta.transaction_id
208: AND mta.accounting_line_type = 1
209: AND ((mmt.transaction_action_id in (2,3,12)