DBA Data[Home] [Help]

APPS.WSH_UTIL_VALIDATE dependencies on MTL_ITEM_UOMS_VIEW

Line 2025: FROM mtl_item_uoms_view

2021: x_return_status OUT NOCOPY VARCHAR2)
2022: IS
2023: CURSOR check_order_uom IS
2024: SELECT uom_code
2025: FROM mtl_item_uoms_view
2026: WHERE organization_id = p_organization_id AND
2027: inventory_item_id = p_inventory_item_id AND
2028: uom_code = x_uom_code
2029: UNION ALL

Line 2031: FROM mtl_item_uoms_view

2027: inventory_item_id = p_inventory_item_id AND
2028: uom_code = x_uom_code
2029: UNION ALL
2030: SELECT uom_code
2031: FROM mtl_item_uoms_view
2032: WHERE organization_id = p_organization_id AND
2033: inventory_item_id = p_inventory_item_id AND
2034: unit_of_measure = p_unit_of_measure;
2035: --