APPS.OE_VALIDATE_LINE dependencies on MTL_ITEM_UOMS_VIEW

Line 6351: FROM mtl_item_uoms_view

6347: ELSE -- not ato related, validate item, uom combination
6348: /*1544265*/
6349: /*SELECT count(*)
6350: INTO l_uom_count
6351: FROM mtl_item_uoms_view
6352: WHERE inventory_item_id = p_line_rec.inventory_item_id
6353: AND uom_code = p_line_rec.order_quantity_uom
6354: AND organization_id = nvl(p_line_rec.ship_from_org_id,
6355: OE_Sys_Parameters.VALUE_WNPS('MASTER_ORGANIZATION_ID'));

Line 7997: FROM mtl_item_uoms_view

7993: IF p_line_rec.ship_from_org_id = FND_API.G_MISS_NUM or p_line_rec.ship_from_org_id is NULL
7994: THEN
7995: SELECT uom_code
7996: INTO l_uom
7997: FROM mtl_item_uoms_view
7998: WHERE inventory_item_id = p_line_rec.inventory_item_id
7999: and uom_code=p_line_rec.service_period
8000: AND organization_id = l_mast_org_id
8001: and rownum=1;

Line 8006: FROM mtl_item_uoms_view

8002:
8003: ELSE
8004: SELECT uom_code
8005: INTO l_uom
8006: FROM mtl_item_uoms_view
8007: WHERE inventory_item_id = p_line_rec.inventory_item_id
8008: and uom_code=p_line_rec.service_period
8009: AND organization_id = p_line_rec.ship_from_org_id
8010: and rownum=1;