OTBI Query not working with where clause in BI publisher

Summary: OTBI Query not working with where clause in BI publisher

We have query which works in BI Publisher with no where clause but when added with where clause the where clause is not effecitve and we don't see desired records.

Content (required):

SET VARIABLE PREFERRED_CURRENCY='User Preferred Currency 1';

SELECT

  "Workforce Management - Work Relationship Real Time"."Job"."Job Code" "Job Code",

  "Workforce Management - Work Relationship Real Time"."Job"."PER_JOBS_DFF_INTERNAL_CONTROL_v" "Internal Control",

  "Workforce Management - Work Relationship Real Time"."Work Relationship Details"."Enterprise Hire Date" "Hire Date",

  "Workforce Management - Work Relationship Real Time"."Worker"."Assignment Category" "Assignment Category",