APPS.OPI_EDW_INV_DAILY_STAT_F_SZ dependencies on MTL_TRANSACTION_ACCOUNTS
Line 206: MTL_TRANSACTION_ACCOUNTS mta
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)
210: AND mmt.primary_quantity >0 )