DBA Data[Home] [Help]

APPS.OPI_DBI_WIP_SCRAP_INCR_PKG dependencies on MTL_SYSTEM_ITEMS_B

Line 469: FROM mtl_system_items_b msi,

465: sysdate,
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,