This query is used to list all form personalization by passing form function name:
SELECT
FUNCTION_NAME,
FORM_NAME,
ID,
CREATED_BY,
CREATION_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATE_LOGIN,
SEQUENCE,
RULE_KEY,
DESCRIPTION,
RULE_TYPE,
ENABLED,
TRIGGER_EVENT,
TRIGGER_OBJECT,
CONDITION,
FIRE_IN_ENTER_QUERY
FROM FND_FORM_CUSTOM_RULES
WHERE ( (function_name = 'PO_POXPOEPO' AND rule_type = 'A')
OR (form_name = 'POXPOEPO' AND rule_type = 'F'))
AND rule_key IS NULL
ORDER BY sequence
SELECT
FUNCTION_NAME,
FORM_NAME,
ID,
CREATED_BY,
CREATION_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATE_LOGIN,
SEQUENCE,
RULE_KEY,
DESCRIPTION,
RULE_TYPE,
ENABLED,
TRIGGER_EVENT,
TRIGGER_OBJECT,
CONDITION,
FIRE_IN_ENTER_QUERY
FROM FND_FORM_CUSTOM_RULES
WHERE ( (function_name = 'PO_POXPOEPO' AND rule_type = 'A')
OR (form_name = 'POXPOEPO' AND rule_type = 'F'))
AND rule_key IS NULL
ORDER BY sequence
No comments:
Post a Comment