[Home] [Help]
View: GL_CONSOLIDATION_AUDIT_V
View Text
SELECT /* $HEADER: GLGVWREG.LDT 120.29.12020000.1 2012/06/27 14:57:54 APPLDEV SHIP $ */ DISTINCT C.CONSOLIDATION_ID CONSOLIDATION_ID
, C.NAME CONSOLIDATION_NAME
, CA.TO_PERIOD_NAME PERIOD_NAME
, PS.PERIOD_YEAR PERIOD_YEAR
, PS.PERIOD_NUM PERIOD_NUM
FROM GL_CONSOLIDATION C
, GL_CONSOLIDATION_AUDIT CA
, GL_PERIOD_STATUSES PS
WHERE C.CONSOLIDATION_ID = CA.CONSOLIDATION_ID
AND PS.APPLICATION_ID = 101
AND PS.LEDGER_ID = C.TO_LEDGER_ID
AND PS.PERIOD_NAME = CA.TO_PERIOD_NAME
Columns
Name |
CONSOLIDATION_ID |
CONSOLIDATION_NAME |
PERIOD_NAME |
PERIOD_YEAR |
PERIOD_NUM |