APPS.WIP_MOVE_VALIDATOR dependencies on MTL_UOM_CONVERSIONS_VIEW

Line 1727: FROM mtl_uom_conversions_view mucv

1723: UPDATE wip_move_txn_interface wmti
1724: SET wmti.primary_quantity =
1725: (SELECT ROUND(wmti.transaction_quantity * mucv.conversion_rate,
1726: WIP_CONSTANTS.INV_MAX_PRECISION)
1727: FROM mtl_uom_conversions_view mucv
1728: WHERE mucv.organization_id = wmti.organization_id
1729: AND mucv.inventory_item_id = wmti.primary_item_id
1730: AND mucv.uom_code = wmti.transaction_uom)
1731: WHERE wmti.group_id = g_group_id

Line 1817: mtl_uom_conversions_view mucv

1813: wmti.program_application_id,
1814: wmti.program_id,
1815: wmti.program_update_date
1816: FROM wip_move_txn_interface wmti,
1817: mtl_uom_conversions_view mucv
1818: WHERE mucv.organization_id = wmti.organization_id
1819: AND mucv.inventory_item_id = wmti.primary_item_id
1820: AND mucv.uom_code = wmti.transaction_uom
1821: AND wmti.group_id = g_group_id

Line 2055: FROM mtl_uom_conversions_view mucv

2051: UPDATE wip_move_txn_interface wmti
2052: SET wmti.overcompletion_primary_qty =
2053: (SELECT ROUND(wmti.overcompletion_transaction_qty *
2054: mucv.conversion_rate, WIP_CONSTANTS.INV_MAX_PRECISION)
2055: FROM mtl_uom_conversions_view mucv
2056: WHERE mucv.organization_id = wmti.organization_id
2057: AND mucv.inventory_item_id = wmti.primary_item_id
2058: AND mucv.uom_code = wmti.transaction_uom)
2059: WHERE wmti.group_id = g_group_id

Line 2144: mtl_uom_conversions_view mucv

2140: wmti.program_application_id,
2141: wmti.program_id,
2142: wmti.program_update_date
2143: FROM wip_move_txn_interface wmti,
2144: mtl_uom_conversions_view mucv
2145: WHERE mucv.organization_id = wmti.organization_id
2146: AND mucv.inventory_item_id = wmti.primary_item_id
2147: AND mucv.uom_code = wmti.transaction_uom
2148: AND wmti.group_id = g_group_id