View: GL_ALL_PERIOD_NAME_VIEW

Product:	GL - General Ledger
Description:
Implementation/DBA Data:	APPS.GL_ALL_PERIOD_NAME_VIEW

View Text

SELECT PERIOD_NAME
, PERIOD_NAME MEANING
, PERIOD_YEAR
, PERIOD_NUM
, CLOSING_STATUS
, LEDGER_ID
FROM GL_PERIOD_STATUSES
WHERE APPLICATION_ID = 101 UNION SELECT DESCRIPTION
, LOOKUP_CODE
, 9999
, 9999
, 'O'
, -1
FROM GL_LOOKUPS
WHERE LOOKUP_TYPE = 'LITERAL'
AND LOOKUP_CODE = 'ALL'

Columns