VIEW: APPS.GL_ALOC_BAS_V

Source

View Text - Preformatted

SELECT DISTINCT mst.legal_entity_id, bas.alloc_id, mst.alloc_code, bas.alloc_method , gle.legal_entity_name FROM gl_aloc_bas bas, gl_aloc_mst mst, gmf_legal_entities_vw2 gle WHERE bas.alloc_id = mst.alloc_id and gle.legal_entity_id = mst.legal_entity_id

View Text - HTML Formatted

SELECT DISTINCT MST.LEGAL_ENTITY_ID
, BAS.ALLOC_ID
, MST.ALLOC_CODE
, BAS.ALLOC_METHOD
, GLE.LEGAL_ENTITY_NAME
FROM GL_ALOC_BAS BAS
, GL_ALOC_MST MST
, GMF_LEGAL_ENTITIES_VW2 GLE
WHERE BAS.ALLOC_ID = MST.ALLOC_ID
AND GLE.LEGAL_ENTITY_ID = MST.LEGAL_ENTITY_ID