SELECT feupb.application_ID,
feupb.descriptive_flexfield_code,
feupb.flexfield_usage_code,
feupb.category_code,
feupb.page_code,
feupt.name,
feupb.sequence_number,
feupb.mds_document_name
FROM FND_EF_UI_PAGES_B feupb,
FND_EF_UI_PAGES_tl feupt
WHERE feupt.descriptive_flexfield_code = 'DOO_FULFILL_LINES_ADD_INFO'
AND feupt.APPLICATION_ID = feupb.APPLICATION_ID
AND feupt.DESCRIPTIVE_FLEXFIELD_CODE = feupb.DESCRIPTIVE_FLEXFIELD_CODE
AND feupt.FLEXFIELD_USAGE_CODE = feupb.FLEXFIELD_USAGE_CODE
AND feupt.CATEGORY_CODE = feupb.CATEGORY_CODE
AND feupt.PAGE_CODE = feupb.PAGE_CODE
AND feupt.language = 'US'
ORDER BY feupb.descriptive_flexfield_code,
feupb.flexfield_usage_code,
feupb.category_code,
feupb.page_code,
feupb.sequence_number;