[Home] [Help]
View: GL_ALOC_INP_V
Product: | GMF - Process Manufacturing Financials |
Description: | View to enable master-detail relationship on Allocation Maintenance form |
Implementation/DBA Data: |
APPS.GL_ALOC_INP_V
|
View Text
SELECT DISTINCT MST.LEGAL_ENTITY_ID
, INP.CALENDAR_CODE
, INP.PERIOD_CODE
, INP.ALLOC_ID
, MST.ALLOC_CODE
, INP.ACCOUNT_KEY_TYPE
, GLE.LEGAL_ENTITY_NAME
FROM GL_ALOC_MST MST
, GL_ALOC_INP INP
, GMF_LEGAL_ENTITIES_VW2 GLE
WHERE MST.ALLOC_ID = INP.ALLOC_ID
AND GLE.LEGAL_ENTITY_ID = MST.LEGAL_ENTITY_ID
Columns
Name |
LEGAL_ENTITY_ID |
CALENDAR_CODE |
PERIOD_CODE |
ALLOC_ID |
ALLOC_CODE |
ACCOUNT_KEY_TYPE |
LEGAL_ENTITY_NAME |