499: s_user_id,
500: s_user_id,
501: s_login_id
502: FROM mtl_system_items_b msi,
503: (SELECT /*+ leading(log) use_nl(log mmt) index(log, OPI_DBI_RUN_LOG_CURR_N1) index(mmt, mtl_material_transactions_u1) */
504: mmt.organization_id,
505: mmt.inventory_item_id,
506: trunc (mmt.transaction_date) trx_date,
507: mmt.primary_quantity mmt_quantity,
505: mmt.inventory_item_id,
506: trunc (mmt.transaction_date) trx_date,
507: mmt.primary_quantity mmt_quantity,
508: -1 * sum (nvl (mta.base_transaction_value, 0)) mta_value
509: FROM mtl_material_transactions mmt,
510: mtl_transaction_accounts mta,
511: wip_entities we,
512: wip_discrete_jobs wdj,
513: opi_dbi_run_log_curr log