DBA Data[Home] [Help]

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 )