View: GL_CONSOLIDATION_AUDIT_V

Product:	GL - General Ledger
Description:
Implementation/DBA Data:	APPS.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