APPS.OPI_DBI_WIP_SCRAP_INCR_PKG dependencies on MTL_MATERIAL_TRANSACTIONS

Line 470: (SELECT /*+ leading(log) index(mmt, MTL_MATERIAL_TRANSACTIONS_U1) use_nl(log mmt) */

466: s_user_id,
467: s_user_id,
468: s_login_id
469: FROM mtl_system_items_b msi,
470: (SELECT /*+ leading(log) index(mmt, MTL_MATERIAL_TRANSACTIONS_U1) use_nl(log mmt) */
471: mmt.organization_id,
472: mmt.inventory_item_id,
473: trunc (mmt.transaction_date) trx_date,
474: mmt.primary_quantity mmt_quantity,

Line 476: FROM mtl_material_transactions mmt,

472: mmt.inventory_item_id,
473: trunc (mmt.transaction_date) trx_date,
474: mmt.primary_quantity mmt_quantity,
475: -1 * sum (nvl (mta.base_transaction_value, 0)) mta_value
476: FROM mtl_material_transactions mmt,
477: mtl_transaction_accounts mta,
478: wip_entities we,
479: wip_discrete_jobs wdj,
480: opi_dbi_run_log_curr log