VIEW: APPS.GL_ALOC_EXP_V

Source

View Text - Preformatted

SELECT distinct mst.legal_Entity_id, mst.alloc_id, mst.alloc_code, gle.legal_entity_name FROM gl_aloc_exp exp , gl_aloc_mst mst, gmf_legal_entities_vw2 gle WHERE exp.alloc_id = mst.alloc_id and gle.legal_entity_id = mst.legal_entity_id

View Text - HTML Formatted

SELECT DISTINCT MST.LEGAL_ENTITY_ID
, MST.ALLOC_ID
, MST.ALLOC_CODE
, GLE.LEGAL_ENTITY_NAME
FROM GL_ALOC_EXP EXP
, GL_ALOC_MST MST
, GMF_LEGAL_ENTITIES_VW2 GLE
WHERE EXP.ALLOC_ID = MST.ALLOC_ID
AND GLE.LEGAL_ENTITY_ID = MST.LEGAL_ENTITY_ID