SELECT DESCRIPTIVE_FLEXFIELD_CODE,
FEUPTF.FLEXFIELD_USAGE_CODE AS CATEGORY_CODE,
FEUPTF.PAGE_CODE,
FEUPTF.CONTEXT_CODE,
FEUPTF.SEQUENCE_NUMBER
FROM FND_EF_UI_PAGE_TASK_FLOWS FEUPTF
WHERE DESCRIPTIVE_FLEXFIELD_CODE = :ip_flexfield_code
AND (
CONTEXT_CODE = :ip_context_code
OR COALESCE(:ip_context_code, NULL) IS NULL
)
ORDER BY FEUPTF.SEQUENCE_NUMBER;