DBA Data[Home] [Help]

APPS.WIP_MOVE_VALIDATOR dependencies on MTL_ITEM_UOMS_VIEW

Line 1420: FROM mtl_item_uoms_view miuv

1416: AND wmti.process_phase = WIP_CONSTANTS.MOVE_VAL
1417: AND wmti.process_status = WIP_CONSTANTS.RUNNING
1418: AND NOT EXISTS
1419: (SELECT 'X'
1420: FROM mtl_item_uoms_view miuv
1421: WHERE miuv.organization_id = wmti.organization_id
1422: AND miuv.inventory_item_id = wmti.primary_item_id
1423: AND miuv.uom_code = wmti.transaction_uom)
1424: RETURNING wmti.transaction_id BULK COLLECT INTO enums;