[Home] [Help]
View: GL_CONSOLIDATION_AUDIT_V
View Text
SELECT /* $HEADER: GLGVWREG.LDT 120.16.12010000.5 2009/02/11 04:46:50 KMOTEPAL 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 |