5 Replies Latest reply on Apr 16, 2015 1:33 PM by SyedHasan

    Need to pass the PROFILE options in SQL query

    SyedHasan
      SELECT ffvs.FLEX_VALUE_SET_NAME
      , ffvs.FLEX_VALUE_SET_ID
      , ffv.FLEX_VALUE_ID
      , ffv.FLEX_VALUE
      FROM fnd_flex_value_sets ffvs
      , fnd_flex_values ffv
      WHERE 1=1
      AND ffvs.FLEX_VALUE_SET_ID=ffv.FLEX_VALUE_SET_ID
      AND ffvs.FLEX_VALUE_SET_ID=1012493  -- SCHEME_GL_OPTION
      AND ffvs.FLEX_VALUE_SET_ID IN (select FLEX_VALUE_SET_ID from FND_FLEX_VALUE_RULE_LINES 
      where 
      FLEX_VALUE_RULE_ID 
      in 
      (select FLEX_VALUE_RULE_ID from FND_FLEX_VALUE_RULES where FLEX_VALUE_RULE_NAME='MDS ZA Option' ))
      

       

      I am trying to to run the particular SQL qyery for creating the VIEW.

       

      Concern:- It will pick all the columns of the values associated with all rules and GL account

       

      --> I want to filter out by running the or using the PROFILE option so that it returns for only one RESP_ID.

       

      Is it anyway to use in creating of view in the QUERY to pick the only one RESP_ID.

      flex.png

      Hope I made clear my issue.