View: GL_SRS_GLRTB2_START_PERIOD

Product:	GL - General Ledger
Description:	Review period names
Implementation/DBA Data:	APPS.GL_SRS_GLRTB2_START_PERIOD

View Text

SELECT 'A' ACTUAL_FLAG
, -1 LEDGER_ID
, MEANING PERIOD_NAME
, -1 PERIOD_YEAR
, -1 PERIOD_NUM
FROM GL_LOOKUPS
WHERE LOOKUP_TYPE = 'LITERAL' AND LOOKUP_CODE = 'N/A' UNION SELECT 'B' ACTUAL_FLAG
, LEDGER_ID LEDGER_ID
, PERIOD_NAME PERIOD_NAME
, PERIOD_YEAR PERIOD_YEAR
, PERIOD_NUM PERIOD_NUM
FROM GL_PERIOD_STATUSES
WHERE APPLICATION_ID = 101

Columns