View: GL_SRS_LEDGER_PERIOD_START

Product:	GL - General Ledger
Description:	Review valid periods for actuals, budgets, and encumbrances
Implementation/DBA Data:	APPS.GL_SRS_LEDGER_PERIOD_START

View Text

SELECT PER.PERIOD_NUM
, PER.PERIOD_NAME
, PER.PERIOD_YEAR
, ((PER.PERIOD_YEAR * 10000) + PER.PERIOD_NUM) EFFECTIVE_PERIOD_NUM
, LED.LEDGER_ID
, -1 BUDGET_ENCUMBRANCE_ID
, 'A' ACTUAL_FLAG
FROM GL_LEDGERS LED
, GL_PERIODS PER
WHERE PER.PERIOD_SET_NAME = LED.PERIOD_SET_NAME AND PER.PERIOD_TYPE = LED.ACCOUNTED_PERIOD_TYPE AND EXISTS (SELECT 'HAS DATA'
FROM GL_LEDGERS LED2
, GL_LEDGER_SET_ASSIGNMENTS LS
, GL_PERIOD_STATUSES PS WHERE LED2.LEDGER_ID = LED.LEDGER_ID AND LS.LEDGER_SET_ID (+) = LED2.LEDGER_ID AND PS.APPLICATION_ID = 101 AND PS.LEDGER_ID = NVL(LS.LEDGER_ID
, LED.LEDGER_ID) AND PS.CLOSING_STATUS IN ('O'
, 'C'
, 'P') AND PS.PERIOD_NAME = PER.PERIOD_NAME) UNION SELECT GLPS.PERIOD_NUM
, GLPS.PERIOD_NAME PERIOD_NAME
, GLPS.PERIOD_YEAR PERIOD_YEAR
, GLPS.EFFECTIVE_PERIOD_NUM
, GLPS.LEDGER_ID LEDGER_ID
, GLPR.BUDGET_VERSION_ID BUDGET_ENCUMBRANCE_ID
, 'B' ACTUAL_FLAG
FROM GL_PERIOD_STATUSES GLPS
, GL_BUDGET_PERIOD_RANGES GLPR
WHERE GLPS.APPLICATION_ID = 101
AND GLPS.PERIOD_YEAR = GLPR.PERIOD_YEAR
AND GLPS.PERIOD_NUM BETWEEN GLPR.START_PERIOD_NUM AND GLPR.END_PERIOD_NUM UNION SELECT PER1.PERIOD_NUM
, PER1.PERIOD_NAME
, PER1.PERIOD_YEAR
, ((PER1.PERIOD_YEAR * 10000) + PER1.PERIOD_NUM) EFFECTIVE_PERIOD_NUM
, L1.LEDGER_ID
, -1 BUDGET_ENCUMBRANCE_ID
, 'E' ACTUAL_FLAG
FROM GL_LEDGERS L1
, GL_PERIODS PER1
WHERE PER1.PERIOD_SET_NAME = L1.PERIOD_SET_NAME AND PER1.PERIOD_TYPE = L1.ACCOUNTED_PERIOD_TYPE AND EXISTS (SELECT 'HAS DATA' FROM GL_LEDGERS L2
, GL_LEDGER_SET_ASSIGNMENTS LS1
, GL_LEDGERS L3 WHERE L2.LEDGER_ID = L1.LEDGER_ID AND LS1.LEDGER_SET_ID (+) = L2.LEDGER_ID AND L3.LEDGER_ID = NVL(LS1.LEDGER_ID
, L1.LEDGER_ID) AND L3.LATEST_ENCUMBRANCE_YEAR >= PER1.PERIOD_YEAR)

Columns