I need to restrict record in the BIP report query using Lookup value
There is a requirement from the business that certain item numbers should not be picked in the report query, so they have provided a lookup where the restricted item numbers are maintained, i have defined in the report query to restrict records in where condition but somehow those are still appearing in the report, see below condition, let me know if i have missed or i have to redesign the code thanks in advance'
where items.item_number NOT IN (SELECT MEANING FROM fnd_lookup_values
where LOOKUP_TYPE='XX_EDI_ITEM_EXCLUSION'
AND LANGUAGE='US'
AND MEANING = items.item_number