Get Form Personalization Details in oracle apps ( Oracle Applications ) from Database using this Query or Script.
Query to find Form Personalization details by passing form name
SELECT FFV.FORM_ID,
FFV.FORM_NAME,
FFV.USER_FORM_NAME,
FFV.DESCRIPTION FORM_DESCRIPTION,
FFCR.SEQUENCE,
FFCR.DESCRIPTION PERSONALIZATION_NAME
FROM FND_FORM_VL FFV, FND_FORM_CUSTOM_RULES FFCR
WHERE FFV.FORM_NAME = FFCR.FORM_NAME
AND FFV.FORM_NAME = 'POXRQERQ'
ORDER BY FFV.FORM_NAME, FFCR.SEQUENCE;
Query to find Form Personalization details by passing form name
SELECT FFV.FORM_ID,
FFV.FORM_NAME,
FFV.USER_FORM_NAME,
FFV.DESCRIPTION FORM_DESCRIPTION,
FFCR.SEQUENCE,
FFCR.DESCRIPTION PERSONALIZATION_NAME
FROM FND_FORM_VL FFV, FND_FORM_CUSTOM_RULES FFCR
WHERE FFV.FORM_NAME = FFCR.FORM_NAME
AND FFV.FORM_NAME = 'POXRQERQ'
ORDER BY FFV.FORM_NAME, FFCR.SEQUENCE;
No comments:
Post a Comment