APPS.OPI_DBI_INV_VALUE_INCR_PKG dependencies on MTL_SYSTEM_ITEMS_B

Line 1009: mtl_system_items_b msi

1005: wta.organization_id,
1006: we.primary_item_id,
1007: wta.transaction_date
1008: ) wip_activity,
1009: mtl_system_items_b msi
1010: WHERE msi.organization_id = wip_activity.organization_id
1011: AND wip_activity.inventory_item_id = msi.inventory_item_id
1012: GROUP BY
1013: wip_activity.organization_id,

Line 1121: mtl_system_items_b msi

1117: gmdtl.organization_id,
1118: gmdtl.inventory_item_id,
1119: trunc (gtv.transaction_date)
1120: ) wip_activity,
1121: mtl_system_items_b msi
1122: WHERE msi.organization_id = wip_activity.organization_id
1123: AND wip_activity.inventory_item_id = msi.inventory_item_id
1124: GROUP BY
1125: wip_activity.organization_id,

Line 1252: (SELECT /*+ index (msi MTL_SYSTEM_ITEMS_B_U1) */

1248: s.INTRANSIT_VALUE_B_DRAFT,
1249: s.WIP_VALUE_B_DRAFT,
1250: source
1251: FROM
1252: (SELECT /*+ index (msi MTL_SYSTEM_ITEMS_B_U1) */
1253: activity.organization_id,
1254: activity.subinventory_code,
1255: activity.inventory_item_id,
1256: activity.transaction_date,