View: GL_ALOC_BAS_V

Product:	GMF - Process Manufacturing Financials
Description:	View to enable master-detail relationship on Allocation Basis form
Implementation/DBA Data:	APPS.GL_ALOC_BAS_V

View Text

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

Columns