View: GL_SRS_GLRTB2_ABE_START_PERIOD

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

View Text

SELECT -1 PERIOD_NUM
, MEANING PERIOD_NAME
, -1 PERIOD_YEAR
, -1 LEDGER_ID
, -1 BUDGET_ENCUMBRANCE_ID
, 'A' ACTUAL_FLAG
, 'X' END_PERIOD_NAME
FROM GL_LOOKUPS
WHERE LOOKUP_TYPE = 'LITERAL'
AND LOOKUP_CODE = 'N/A' UNION SELECT GLPS.PERIOD_NUM
, GLPS.PERIOD_NAME PERIOD_NAME
, GLPS.PERIOD_YEAR PERIOD_YEAR
, GLPSEND.LEDGER_ID LEDGER_ID
, GLPR.BUDGET_VERSION_ID BUDGET_ENCUMBRANCE_ID
, 'B' ACTUAL_FLAG
, GLPSEND.PERIOD_NAME END_PERIOD_NAME
FROM GL_PERIOD_STATUSES GLPS
, GL_BUDGET_PERIOD_RANGES GLPR
, GL_PERIOD_STATUSES GLPSEND
WHERE GLPSEND.APPLICATION_ID = 101
AND GLPS.APPLICATION_ID = 101
AND GLPS.LEDGER_ID = GLPSEND.LEDGER_ID
AND GLPS.PERIOD_YEAR = GLPR.PERIOD_YEAR
AND GLPS.PERIOD_NUM BETWEEN GLPR.START_PERIOD_NUM
AND GLPR.END_PERIOD_NUM
AND GLPS.EFFECTIVE_PERIOD_NUM <= GLPSEND.EFFECTIVE_PERIOD_NUM

Columns