SELECT distinct a.legal_entity_id, b.legal_entity_name from gmf_ledger_valuation_methods a, gmf_legal_entities b WHERE a.legal_entity_id = b.legal_entity_id order by b.legal_entity_name
View Text - HTML Formatted
SELECT DISTINCT A.LEGAL_ENTITY_ID , B.LEGAL_ENTITY_NAME FROM GMF_LEDGER_VALUATION_METHODS A , GMF_LEGAL_ENTITIES B WHERE A.LEGAL_ENTITY_ID = B.LEGAL_ENTITY_ID ORDER BY B.LEGAL_ENTITY_NAME