APPS.WIP_MOVE_VALIDATOR dependencies on MTL_UOM_CONVERSIONS_VIEW

Line 1659: FROM mtl_uom_conversions_view mucv

1655: UPDATE wip_move_txn_interface wmti
1656: SET wmti.primary_quantity =
1657: (SELECT ROUND(wmti.transaction_quantity * mucv.conversion_rate,
1658: WIP_CONSTANTS.INV_MAX_PRECISION)
1659: FROM mtl_uom_conversions_view mucv
1660: WHERE mucv.organization_id = wmti.organization_id
1661: AND mucv.inventory_item_id = wmti.primary_item_id
1662: AND mucv.uom_code = wmti.transaction_uom)
1663: WHERE wmti.group_id = g_group_id

Line 1749: mtl_uom_conversions_view mucv

1745: wmti.program_application_id,
1746: wmti.program_id,
1747: wmti.program_update_date
1748: FROM wip_move_txn_interface wmti,
1749: mtl_uom_conversions_view mucv
1750: WHERE mucv.organization_id = wmti.organization_id
1751: AND mucv.inventory_item_id = wmti.primary_item_id
1752: AND mucv.uom_code = wmti.transaction_uom
1753: AND wmti.group_id = g_group_id

Line 1987: FROM mtl_uom_conversions_view mucv

1983: UPDATE wip_move_txn_interface wmti
1984: SET wmti.overcompletion_primary_qty =
1985: (SELECT ROUND(wmti.overcompletion_transaction_qty *
1986: mucv.conversion_rate, WIP_CONSTANTS.INV_MAX_PRECISION)
1987: FROM mtl_uom_conversions_view mucv
1988: WHERE mucv.organization_id = wmti.organization_id
1989: AND mucv.inventory_item_id = wmti.primary_item_id
1990: AND mucv.uom_code = wmti.transaction_uom)
1991: WHERE wmti.group_id = g_group_id

Line 2076: mtl_uom_conversions_view mucv

2072: wmti.program_application_id,
2073: wmti.program_id,
2074: wmti.program_update_date
2075: FROM wip_move_txn_interface wmti,
2076: mtl_uom_conversions_view mucv
2077: WHERE mucv.organization_id = wmti.organization_id
2078: AND mucv.inventory_item_id = wmti.primary_item_id
2079: AND mucv.uom_code = wmti.transaction_uom
2080: AND wmti.group_id = g_group_id