Friday, 10 July 2015

How to find how many and what DFF (Descriptive Flex Field) are enabled in the Oracle APPS R12

SELECT APPLICATION_TABLE_NAME,TITLE ,FORM_CONTEXT_PROMPT
FROM FND_DESCRIPTIVE_FLEXS_VL
WHERE FREEZE_FLEX_DEFINITION_FLAG='Y'
AND LAST_UPDATED_BY NOT IN (-1,1,2,0,120,121);

No comments:

Post a Comment