VIEW: APPS.GL_CONSOLIDATION_AUDIT_V

Source

View Text - Preformatted

SELECT /* $Header: glgvw.odf 120.39 2011/02/18 13:08:22 sommukhe 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

View Text - HTML Formatted

SELECT /* $HEADER: GLGVW.ODF 120.39 2011/02/18 13:08:22 SOMMUKHE 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