Friday, 21 August 2015

How to find CoA name and description


SELECT   ID_FLEX_NUM,
                 ID_FLEX_STRUCTURE_CODE,
                 ID_FLEX_STRUCTURE_NAME,
                 DESCRIPTION
  FROM   FND_ID_FLEX_STRUCTURES_VL
 WHERE   ID_FLEX_CODE = 'GL#' AND CREATED_BY <> 1;

No comments:

Post a Comment