Select c.*
  From Apps.Fnd_Descriptive_Flexs_Vl    a,
       Apps.Fnd_Descr_Flex_Contexts_Vl  b,
       Apps.Fnd_Descr_Flex_Col_Usage_Vl c
 Where Title = 'Receiving Transactions'
   And a.Descriptive_Flexfield_Name = b.Descriptive_Flexfield_Name
   And b.Descriptive_Flex_Context_Code = 'Global Data Elements'
   And c.Descriptive_Flexfield_Name = b.Descriptive_Flexfield_Name
   And b.Descriptive_Flex_Context_Code = c.Descriptive_Flex_Context_Code

  Select d.Application_Short_Name,
         b.Application_Table_Name,
         b.Descriptive_Flexfield_Name,
         a.Descriptive_Flex_Context_Code,
         a.Application_Column_Name,
         a.End_User_Column_Name,
         a.Form_Left_Prompt,
         a.Description,
         c.Flex_Value_Set_Name
          From Fnd_Descr_Flex_Col_Usage_Vl a,
         Fnd_Descriptive_Flexs       b,
         Fnd_Flex_Value_Sets         c,
         Fnd_Application             d
         Where a.Application_Id = d.Application_Id
           And a.Descriptive_Flexfield_Name = b.Descriptive_Flexfield_Name
           And a.Flex_Value_Set_Id = c.Flex_Value_Set_Id
           And d.Application_Short_Name In ('OFA', 'PA')
           And a.Created_By <> 1
           And b.Application_Table_Name <> 'FND_SRS_MASTER'
         Order By 1, 2