Friday, 21 August 2015

How to find Natural Account Segment in a Query

SELECT   APPLICATION_COLUMN_NAME
  FROM   FND_SEGMENT_ATTRIBUTE_VALUES
 WHERE       APPLICATION_ID = 101
         AND ID_FLEX_CODE = 'GL#'
         AND SEGMENT_ATTRIBUTE_TYPE = 'GL_ACCOUNT'
         AND ATTRIBUTE_VALUE = 'Y'









 

No comments:

Post a Comment