DBA Data[Home] [Help]

APPS.WIP_MOVE_VALIDATOR dependencies on MTL_ITEM_UOMS_VIEW

Line 1352: FROM mtl_item_uoms_view miuv

1348: AND wmti.process_phase = WIP_CONSTANTS.MOVE_VAL
1349: AND wmti.process_status = WIP_CONSTANTS.RUNNING
1350: AND NOT EXISTS
1351: (SELECT 'X'
1352: FROM mtl_item_uoms_view miuv
1353: WHERE miuv.organization_id = wmti.organization_id
1354: AND miuv.inventory_item_id = wmti.primary_item_id
1355: AND miuv.uom_code = wmti.transaction_uom)
1356: RETURNING wmti.transaction_id BULK COLLECT INTO enums;