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.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