VIEW: APPS.GL_ALL_PERIOD_NAME_VIEW

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'