I need to restrict record in the BIP report query using Lookup value — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!