[Home] [Help]
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
Name |
LEGAL_ENTITY_ID |
ALLOC_ID |
ALLOC_CODE |
ALLOC_METHOD |
LEGAL_ENTITY_NAME |