APPS.OE_VALIDATE_LINE dependencies on MTL_ITEM_UOMS_VIEW

Line 5979: FROM mtl_item_uoms_view

5975: ELSE -- not ato related, validate item, uom combination
5976: /*1544265*/
5977: /*SELECT count(*)
5978: INTO l_uom_count
5979: FROM mtl_item_uoms_view
5980: WHERE inventory_item_id = p_line_rec.inventory_item_id
5981: AND uom_code = p_line_rec.order_quantity_uom
5982: AND organization_id = nvl(p_line_rec.ship_from_org_id,
5983: OE_Sys_Parameters.VALUE_WNPS('MASTER_ORGANIZATION_ID'));

Line 7586: FROM mtl_item_uoms_view

7582: IF p_line_rec.ship_from_org_id = FND_API.G_MISS_NUM or p_line_rec.ship_from_org_id is NULL
7583: THEN
7584: SELECT uom_code
7585: INTO l_uom
7586: FROM mtl_item_uoms_view
7587: WHERE inventory_item_id = p_line_rec.inventory_item_id
7588: and uom_code=p_line_rec.service_period
7589: AND organization_id = l_mast_org_id
7590: and rownum=1;

Line 7595: FROM mtl_item_uoms_view

7591:
7592: ELSE
7593: SELECT uom_code
7594: INTO l_uom
7595: FROM mtl_item_uoms_view
7596: WHERE inventory_item_id = p_line_rec.inventory_item_id
7597: and uom_code=p_line_rec.service_period
7598: AND organization_id = p_line_rec.ship_from_org_id
7599: and rownum=1;