View: GL_ALOC_EXP_V

Product:	GMF - Process Manufacturing Financials
Description:	View to enable master-detail relationship on Expenses to Allocate form
Implementation/DBA Data:	APPS.GL_ALOC_EXP_V

View Text

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

Columns