VIEW: APPS.GL_SRS_GLRTB2_ABE_START_PERIOD

Source

View Text - Preformatted

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

View Text - HTML Formatted

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