Hi,

Here is the view I have in Oracle 10g

CREATE VIEW BCA.EIMS_BY_PART
(
  PREFIX,
  BASE,
  SUFFIX,
  DESTINATION,
  EXTERIOR_COLOR,
  INTERIOR_COLOR,
  PART_NUMBER
)
AS
  select eim.prefix, eim.base, eim.suffix, eim.destination, cc.exterior_color, cc.interior_color, part.PART_NUMBER from eim
  inner join eim_reference on eim_reference.eim_id = eim.id
  inner join broadcast_code bc on bc.eim_reference_id = eim_reference.id
  inner join color_combination cc on cc.eim_reference_id = eim_reference.id and ((cc.exterior_color = bc.exterior_color and bc.interior_color is null) or (cc.interior_color = bc.interior_color and bc.exterior_color is null) or (bc.exterior_color is null and bc.interior_color is null))
  inner join part_reference on part_reference.id = bc.part_reference_id
  inner join part on part.id = part_reference.part_id;

For that, I have generated a TypedView in LLBLGenPro.

The problem is when I try to create a Predicate like this: PartFields == "9999999999", fails saying:

ORA-00904: "BCA"."PART"."PART_NUMBER": invalid indentifier

Is it an error of the view or a bug in LLBL? Thanks!

The problem is when I try to create a Predicate like this: PartFields ==

Here PartFields is an entity field collection, not an entity field. Anyway, when using typedviews you have to use the typedView fields collection: **_YourTypedViewName_Fields.PartNumber == "9999999999"**